Teach your AI assistant to design schemas, optimize queries, and build materialized views. One command to install.
$ npx add-skill obsessiondb/clickhouse-skillsSkills are instruction packages for AI coding assistants. When you ask your AI to “create a ClickHouse table,” it loads the relevant skill and follows best practices automatically.
Each skill encodes the rules and patterns that ClickHouse experts use every day. No prompt engineering needed. Install once, use anywhere.
- Works offline in your local environment
- No data leaves your machine
- 45+ rules across 3 specialized skills
From schema design to query optimization. Each skill encodes real-world ClickHouse expertise.
Schema Design
15+ rulesOptimal ORDER BY, PARTITION BY, and TTL for 10x compression and sub-second queries on billions of rows.
Query Optimization
20+ rulesDebug slow joins, fix memory errors, and write performant queries. 10-100x faster, 90% less memory.
Materialized Views
10+ rulesReal-time aggregation with SummingMergeTree, AggregatingMergeTree, and battle-tested MV patterns.
Install the skills
One command adds all three ClickHouse skills to your project.
npx add-skill obsessiondb/clickhouse-skillsAsk in plain English
Your AI detects the task and loads the right skill automatically.
"Create a table for event analytics with 90-day TTL"Get expert output
The AI follows 45+ rules to produce production-grade ClickHouse code.
-- Optimal schema: ORDER BY, PARTITION BY, TTLWorks with
Sub-second queries. 10x compression. Zero full table scans. Let your AI do it right.