Skip to main contentRunning ClickHouse® in production? Free cost audit, plus $3K in credits if you convert. Get the audit →
Free to use, built by ObsessionDB

AI Skills for ClickHouse® DB

Teach your AI assistant to design schemas, optimize queries, and build materialized views. One command to install.

or view on GitHub ↗
Shell
$ npx add-skill obsessiondb/clickhouse-skills

What are skills? Instruction packages your AI loads on demand.

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.

Runs
Offline, in your local environment
Your data
Never leaves your machine
Coverage
45+ rules across 3 skills
Cost
Free to use

Three skills, one install

From schema design to query optimization. Each skill encodes real-world ClickHouse expertise.

Read the rules on GitHub ↗
15+ rules

Schema Design

Optimal ORDER BY, PARTITION BY, and TTL for 10x compression and sub-second queries on billions of rows.

SCHEMASORDER BYTTL
20+ rules

Query Optimization

Debug slow joins, fix memory errors, and write performant queries. 10-100x faster, 90% less memory.

slow queryJOINPREWHERE
10+ rules

Materialized Views

Real-time aggregation with SummingMergeTree, AggregatingMergeTree, and battle-tested MV patterns.

MVsAggregateFunctionMergeTree

How it works

Ask for what you need. The right skill loads itself, and the output follows its rules.

Your AI assistant
> 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;
  1. 01

    Install the skills

    One command adds all three ClickHouse skills to your project.

  2. 02

    Ask in plain English

    Your AI detects the task and loads the right skill automatically.

  3. 03

    Get expert output

    The AI follows 45+ rules to produce production-grade ClickHouse code.

Works withClaude CodeOpenAI CodexCursorVS Code CopilotGemini CLIAny AI agent

Sub-second queries, 10x compression, and zero full table scans. Let your AI do it right.

Start building better.

View on GitHub ↗