Terminal
Terminal/Skill
Guides ClickHouse architecture choices for a given workload, labelling each recommendation as official, derived or field advice.
By ClickHouse
Works with
npx skills add clickhouse/agent-skills --skill clickhouse-architecture-advisorThis 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:
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.