Stats
Actions
Available In
Tags
Plugin
clickhouse
Achieve sub-second ClickHouse queries, 10x compression, and zero full table scans by designing schemas with optimal ORDER BY, PARTITION BY, TTL, and engines; building real-time ETL pipelines via Materialized Views on SummingMergeTree and AggregatingMergeTree; and optimizing queries for 10-100x faster execution with 90% less memory.
What's Inside
Skills3
clickhouse-query-optimization
/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.
clickhouse-schema-design
/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.
clickhouse-materialized-views
/clickhouse-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.
README
ClickHouse Skills for Claude Code
Build ClickHouse tables with sub-second queries, 10x compression, and zero full table scans.
Installation
npx skills add obsessiondb/clickhouse-skills
Available Skills
| Skill | Rules | Trigger |
|---|---|---|
| clickhouse-schema-design | 15+ | Creating/modifying tables, ORDER BY, PARTITION BY, TTL |
| clickhouse-query-optimization | 20+ | Writing/debugging queries, slow queries, JOINs, memory errors |
| clickhouse-materialized-views | 10+ | Creating MVs, real-time aggregation, pre-aggregation |
How Skills Work
Skills load automatically when relevant tasks are detected:
- Mention "CREATE TABLE" or "schema" → loads schema-design
- Mention "slow query", "JOIN", or "optimize" → loads query-optimization
- Mention "materialized view" or "MV" → loads materialized-views
Skill Structure
Each skill contains a SKILL.md file with:
- Goals - Measurable outcomes (e.g., "10x compression")
- Critical Rules - Prioritized as CRITICAL, HIGH, MEDIUM
- Patterns - Good vs Bad code examples
- Troubleshooting - Common problems and solutions
Contributing
Contributions welcome! See AGENTS.md for skill authoring guidelines.
License
MIT + Commons Clause (free to use, not for resale)
Sponsor
Sponsored by ObsessionDB — ClickHouse® infrastructure as a service that decouples processing from storage for high-volume event data.
Stats
Version1.0.1
Stars13
Forks1
MaintenanceGood
Last Commit
Added
Available In
