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.

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

01Advanced MergeTree engine configurations and partitioning strategies

02Performance monitoring and system diagnostic query templates

03OLAP-specific query optimization for high-cardinality data

0443,117 GitHub stars

05Batch and stream ingestion patterns for Node.js and TypeScript

06Materialized view implementations for real-time data aggregation

Use Cases

01Designing high-volume time-series schemas for market analytics

02Implementing robust ETL and Change Data Capture (CDC) pipelines

03Optimizing 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