.agents/skills/clickhouse-best-practices/README.md
Agent skill providing comprehensive ClickHouse guidance for schema design, query optimization, and data ingestion.
npx skills add 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: