clickhouse-schema-design
Installation
SKILL.md
ClickHouse Schema Design
ALWAYS LOAD when creating or modifying ClickHouse tables.
Goals
- Sub-second query response on billion-row tables
- 10x+ compression ratios vs raw data
- Zero-maintenance data retention and tiered storage
- Queries that scan <1% of data instead of full table scans
Reference Documentation
Related skills
More from obsessiondb/clickhouse-skills
clickhouse-query-optimization
20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.
26clickhouse-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.
21