MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. Complements clickhouse-best-practices with decision frameworks and explicit provenance labels.
Permissions
Just instructions. No commands, network, or file access.
Files
MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. Complements clickhouse-best-practices with decision frameworks and explicit provenance labels.
This skill adds workload-aware architecture decisioning on top of clickhouse-best-practices.
Official docs remain the source of truth. This skill must always prefer official ClickHouse documentation when available.
Before producing recommendations:
Version history
rules/mappings/doc_links.yaml to attach official documentationofficialderivedfieldofficialUse this when the recommendation is directly backed by official docs.
derivedUse this when the recommendation is not stated verbatim in docs but follows logically from documented ClickHouse behavior.
fieldUse this only for experience-based guidance that may be situational.
When using field, include:
rules/decision-ingestion-strategy.mdrules/decision-real-time-preaggregation.mdrules/decision-partitioning-timeseries.mdrules/decision-join-enrichment.mdrules/decision-late-arriving-upserts.mdStructure responses like this:
## Workload Summary
- workload:
- latency target:
- data shape:
- primary query patterns:
- operational constraints:
## Key Decisions
- ...
- ...
## Recommendations
### <Recommendation title>
**What**
...
**Why**
...
**How**
...
**Category**
official | derived | field
**Confidence**
high | medium | heuristic
**Source**
- doc link(s)
**Validation**
- concrete SQL, metric, or smoke test
Prefer decision frameworks over generic advice. Good responses should:
See AGENTS.md for the compiled version and examples/ for sample outputs.
In these kits
More from @clickhouse
Works with
Claude, Codex, Cursor & more