clickhouse-query-optimization
Installation
SKILL.md
ClickHouse Query Optimization
Load when writing, debugging, or optimizing ClickHouse queries.
Goals
- 10-100x faster query execution
- 90%+ reduction in memory usage
- Eliminate full table scans (read <1% of data)
- JOINs that complete in milliseconds instead of minutes
Reference Documentation
Related skills
More from obsessiondb/clickhouse-plugin
clickhouse-schema-design
15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle.
4clickhouse-materialized-views
10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls.
4