MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
Add this skill
npx mdskills install ClickHouse/clickhouse-best-practicesComprehensive ClickHouse guidance with 28 prioritized rules, clear review procedures, and actionable instructions
Agent skill providing comprehensive ClickHouse guidance for schema design, query optimization, and data ingestion.
npx add-skill ClickHouse/clickhouse-agent-skills
28 atomic rules organized by prefix:
| Prefix | Count | Coverage |
|---|---|---|
schema-pk-* | 4 | PRIMARY KEY selection, cardinality ordering |
schema-types-* | 5 | Data types, LowCardinality, Nullable |
schema-partition-* | 4 | Partitioning strategy, lifecycle management |
schema-json-* | 1 | JSON type usage |
query-join-* | 5 | JOIN algorithms, filtering, alternatives |
query-index-* | 1 | Data skipping indices |
query-mv-* | 2 | Incremental and refreshable MVs |
insert-batch-* | 1 | Batch sizing (10K-100K rows) |
insert-async-* | 2 | Async inserts, data formats |
insert-mutation-* | 2 | Mutation avoidance |
insert-optimize-* | 1 | OPTIMIZE FINAL avoidance |
This skill activates when you:
| File | Purpose |
|---|---|
SKILL.md | Quick reference and decision frameworks |
AGENTS.md | Complete rule reference (auto-generated) |
rules/*.md | Individual rule definitions |
All rules link to official ClickHouse documentation:
Install via CLI
npx mdskills install ClickHouse/clickhouse-best-practicesClickhouse Best Practices is a free, open-source AI agent skill. MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
Install Clickhouse Best Practices with a single command:
npx mdskills install ClickHouse/clickhouse-best-practicesThis downloads the skill files into your project and your AI agent picks them up automatically.
Clickhouse Best Practices works with Claude Code, Claude Desktop, Cursor, Vscode Copilot, Windsurf, Continue Dev, Codex, Gemini Cli, Amp, Roo Code, Goose, Opencode, Trae, Qodo, Command Code. Skills use the open SKILL.md format which is compatible with any AI coding agent that reads markdown instructions.