Schema Design
Optimal ORDER BY, PARTITION BY, and TTL for 10x compression and sub-second queries on billions of rows.
Teach your AI assistant to design schemas, optimize queries, and build materialized views. One command to install.
$ npx add-skill obsessiondb/clickhouse-skillsWhen 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.
From schema design to query optimization. Each skill encodes real-world ClickHouse expertise.
Optimal ORDER BY, PARTITION BY, and TTL for 10x compression and sub-second queries on billions of rows.
Debug slow joins, fix memory errors, and write performant queries. 10-100x faster, 90% less memory.
Real-time aggregation with SummingMergeTree, AggregatingMergeTree, and battle-tested MV patterns.
Ask for what you need. The right skill loads itself, and the output follows its rules.
> Create a table for event analytics with 90-day TTL
● Loaded skill: clickhouse-schema-design
CREATE TABLE events
(
event_time DateTime,
event_type LowCardinality(String),
user_id UInt64,
properties String CODEC(ZSTD(3))
)
ENGINE = MergeTree
PARTITION BY toYYYYMM(event_time)
ORDER BY (event_type, toDate(event_time), user_id)
TTL event_time + INTERVAL 90 DAY;One command adds all three ClickHouse skills to your project.
Your AI detects the task and loads the right skill automatically.
The AI follows 45+ rules to produce production-grade ClickHouse code.
Sub-second queries, 10x compression, and zero full table scans. Let your AI do it right.