Does it provide code for data ingestion?

Yes, it features production-ready snippets for both batch inserts (the recommended approach) and streaming ingestion using TypeScript and Node.js.

What ClickHouse table engines does this skill cover?

The skill provides patterns for MergeTree, ReplacingMergeTree, and AggregatingMergeTree, which are the core engines for high-performance analytical storage.

How does it handle real-time data updates?

The skill provides patterns for Materialized Views to perform real-time aggregation and Change Data Capture (CDC) methods to sync data from sources like PostgreSQL.

Can this skill help optimize slow analytical queries?

Yes, it includes specific guidance on efficient filtering, using ClickHouse-specific aggregation functions like 'uniq' and 'quantile', and proper join strategies.

Does this skill help with database maintenance?

It includes administrative queries for monitoring table sizes, checking query logs for bottlenecks, and auditing memory usage.

ClickHouse Performance & Analytics

Name: ClickHouse Performance & Analytics
Author: affaan-m

byaffaan-m

•

43,117

Database Management

Provides expert guidance on ClickHouse database design, query optimization, and high-performance analytical patterns.

About

This skill equips Claude with specialized knowledge of ClickHouse, a high-performance columnar database optimized for OLAP workloads. It covers essential table engine implementations like MergeTree and AggregatingMergeTree, sophisticated query optimization techniques, and real-time data ingestion patterns. Whether you are building real-time dashboards or complex data engineering pipelines, this skill provides battle-tested code snippets for complex aggregations, materialized views, and efficient ETL processes to ensure maximum analytical throughput.

Key Features

Advanced MergeTree engine configurations and partitioning strategies
Performance monitoring and system diagnostic query templates
OLAP-specific query optimization for high-cardinality data
43,117 GitHub stars
Batch and stream ingestion patterns for Node.js and TypeScript
Materialized view implementations for real-time data aggregation

Use Cases

Designing high-volume time-series schemas for market analytics
Implementing robust ETL and Change Data Capture (CDC) pipelines
Optimizing slow-running SQL queries using ClickHouse-specific functions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill

GitHub