By obsessiondb
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.
npx claudepluginhub obsessiondb/clickhouse-skills --plugin clickhouse20+ 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.
15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle.
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.
Build ClickHouse tables with sub-second queries, 10x compression, and zero full table scans.
npx skills add obsessiondb/clickhouse-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 |
Skills load automatically when relevant tasks are detected:
Each skill contains a SKILL.md file with:
Contributions welcome! See AGENTS.md for skill authoring guidelines.
MIT + Commons Clause (free to use, not for resale)
Sponsored by ObsessionDB — ClickHouse® infrastructure as a service that decouples processing from storage for high-volume event data.
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
Share bugs, ideas, or general feedback.
Claude Code skill pack for ClickHouse (24 skills)
Specialized assistance for the ClickHouse Monitor dashboard - a real-time monitoring dashboard for ClickHouse clusters
Comprehensive BigQuery skill suite: query optimization, SQL generation, schema design, cost optimization, and feature guidance.
Skills for Snowflake query optimization
SQL query optimization and execution plan analysis