Design and optimize ClickHouse analytics workloads with table engines, partitioning, and materialized views.
npx skills add https://github.com/flag3/dotfiles --skill clickhouse-io
Please help me install this Agent Skill. Skill: clickhouse-io Source: https://github.com/flag3/dotfiles/tree/main/.claude/skills/clickhouse-io Command: npx skills add https://github.com/flag3/dotfiles --skill clickhouse-io
This Skill provides structured guidance for designing and optimizing ClickHouse analytics workloads, helping teams achieve faster queries and more scalable data models.
Follow the patterns and SQL examples to start modeling a ClickHouse analytics workload or to optimize an existing dataset.
High-intent search queries and answers about installing and using this skill.
Query optimization in ClickHouse focuses on filtering, aggregations, and window functions. Apply best practices like leveraging primary keys, using appropriate table engines, and structuring aggregations efficiently to reduce execution time and improve throughput.
Table engine selection depends on your access patterns and data volume. ClickHouse patterns recommend specific engines optimized for analytics—typically MergeTree variants for real-time data and aggregations, chosen based on your partitioning and query requirements.
Design ClickHouse schemas around your query access patterns using materialized views, strategic partitioning, and aggregation tables. This approach sustains fast query performance and scalable throughput for dashboards over event data.
Materialized views pre-compute aggregations and transformations in ClickHouse, reducing query load and enabling faster dashboard queries. They work in synergy with partitioning and table engine selection to maintain consistent performance.
Partitioning in ClickHouse improves query speed by enabling efficient data pruning and parallel processing. Pattern-based guidance covers partition key selection, maintenance, and monitoring to sustain performance as your dataset grows.
Performance monitoring in ClickHouse tracks query execution, throughput, and resource usage to identify bottlenecks. Regular measurement using system tables and query logs helps maintain fast analytics and detect when data modeling adjustments are needed.
klu-devOptimize ClickHouse table design, queries, and data ingestion for analytical workloads.
weirdgmeDesign and implement scalable platform engineering patterns for internal developer platforms.
sangrokjungDesign ClickHouse databases and optimize queries for analytical workloads.
RambleRainbowOptimize ClickHouse MergeTree schemas and OLAP queries for large datasets.
