Help us improve
Share bugs, ideas, or general feedback.
From clickhouse-best-practices
Guides workload-aware ClickHouse architecture decisions: ingestion strategy, partitioning, enrichment, and late-arriving data. Complements best-practices with provenance labels (official/derived/field).
npx claudepluginhub clickhouse/agent-skills --plugin chdb-sqlHow this skill is triggered — by the user, by Claude, or both
Slash command
/clickhouse-best-practices:clickhouse-architecture-advisorThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
This skill adds workload-aware architecture decisioning on top of `clickhouse-best-practices`.
AGENTS.mdREADME.mdexamples/README.mdexamples/finserv-market-surveillance.mdexamples/observability-high-throughput.mdexamples/siem-security-analytics.mdmappings/doc_links.yamlmetadata.jsonrules/decision-ingestion-strategy.mdrules/decision-join-enrichment.mdrules/decision-late-arriving-upserts.mdrules/decision-partitioning-timeseries.mdrules/decision-real-time-preaggregation.mdschemas/recommendation_schema.yamlReviews ClickHouse schemas, queries, and configurations using 31 prioritized rules across schema design, query optimization, data ingestion, and agent connectivity. Essential when working with ClickHouse databases.
Provides production reference architecture for ClickHouse apps: project layout, data flows, multi-tenancy, operational topology in TypeScript/Node.js. For designing/reviewing systems.
Provides 15+ schema design rules for ClickHouse tables including ORDER BY, PARTITION BY, data types, TTL, and engine selection for sub-second queries, 10x compression, and automated retention. Load when creating or modifying tables.
Share bugs, ideas, or general feedback.
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:
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.