π―Skills3
π―clickhouse-schema-designπ―Skill
Optimizes ClickHouse table schemas with 15+ rules to achieve sub-second queries, 10x compression, and automated data lifecycle management.
clickhouse-schema-design
π―clickhouse-materialized-viewsπ―Skill
Generates real-time aggregations and transforms ClickHouse data using materialized views with optimized MergeTree engine variants for efficient incremental processing.
clickhouse-materialized-views
π―clickhouse-query-optimizationπ―Skill
Optimizes ClickHouse queries with 20+ rules, reducing query execution time by 10-100x and memory usage by 90%.
clickhouse-query-optimization