How does this skill help with ClickHouse performance?

It provides specific patterns for index selection, partition strategies, and efficient aggregation functions to minimize disk I/O and query latency.

Does it support Materialized Views?

Absolutely, it includes templates for creating real-time aggregated views using State and Merge functions to significantly speed up dashboard queries.

Which ClickHouse table engines are covered?

The skill focuses on the MergeTree family, including ReplacingMergeTree for deduplication, AggregatingMergeTree for pre-aggregation, and VersionedCollapsingMergeTree.

Can it help migrate data from MySQL or PostgreSQL?

Yes, it offers guidance on schema mapping, data type conversions, and CDC (Change Data Capture) patterns to sync transactional data to ClickHouse for analysis.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: xu-xiang

byxu-xiang

•

323

•

データベース管理

Provides expert guidance on ClickHouse database schema design, high-performance query optimization, and efficient data engineering patterns.

This skill equips Claude with specialized knowledge for architecting and managing ClickHouse, the leading open-source OLAP columnar database. It covers advanced table engine selection (such as MergeTree and AggregatingMergeTree), optimized SQL patterns for large-scale analytics, and materialized view implementations. It is designed to help developers and data engineers build high-throughput data ingestion pipelines, perform complex time-series analysis, and troubleshoot performance bottlenecks in real-time analytical environments.

主な機能

01High-performance analytical query optimization and window functions

02Expert MergeTree engine configuration and table schema design

03Real-time data aggregation using Materialized Views

04323 GitHub stars

05Best practices for batch and streaming data ingestion

06Performance monitoring and query log analysis

ユースケース

01Designing a high-performance schema for real-time dashboards and telemetry

02Optimizing slow analytical queries on datasets with billions of rows

03Implementing ETL/CDC pipelines to sync transactional data to ClickHouse

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-xiang/everything-claude-code-zh clickhouse-io

For use in Claude.ai and ChatGPT

主な機能

01High-performance analytical query optimization and window functions

02Expert MergeTree engine configuration and table schema design

03Real-time data aggregation using Materialized Views

04323 GitHub stars

05Best practices for batch and streaming data ingestion

06Performance monitoring and query log analysis

ユースケース

01Designing a high-performance schema for real-time dashboards and telemetry

02Optimizing slow analytical queries on datasets with billions of rows

03Implementing ETL/CDC pipelines to sync transactional data to ClickHouse

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-xiang/everything-claude-code-zh clickhouse-io

For use in Claude.ai and ChatGPT