Optimized analytical query patterns and data engineering best practices for ClickHouse database management.
This skill provides a comprehensive set of patterns and best practices for high-performance analytical workloads using ClickHouse. It enables Claude to assist with designing efficient table schemas using MergeTree variants, optimizing complex SQL queries for OLAP, and implementing high-throughput data ingestion strategies. Whether you are building real-time dashboards with Materialized Views or performing deep cohort analysis on billions of rows, this skill provides the domain-specific logic needed to maximize ClickHouse's column-store performance and scalability.
主な機能
01Optimized MergeTree, ReplacingMergeTree, and AggregatingMergeTree schema designs
02Efficient batch and stream data insertion implementations
03High-performance SQL query optimization and ClickHouse-specific aggregation functions
040 GitHub stars
05Advanced analytical templates for time series, funnel, and cohort analysis
06Real-time data aggregation patterns using Materialized Views
ユースケース
01Building real-time data pipelines and monitoring dashboards
02Optimizing slow analytical queries to achieve sub-second response times
03Designing scalable OLAP schemas for large-scale data warehousing
