clickhouse-best-practices
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing r…
What it does
- Schema discovery + query execution: any model — the steps are procedural
- EXPLAIN analysis + query optimization: benefits from mid-tier reasoning
- Schema design review against all 28 rules: benefits from mid-tier reasoning
- [ ] PRIMARY KEY / ORDER BY column order (low-to-high cardinality)
- [ ] Data types match actual data ranges
- [ ] LowCardinality applied to appropriate string columns
- [ ] Partition key cardinality bounded (100-1,000 values)
Requirements & configuration
- Use AGENTS.md when you need to check multiple rules quickly without reading individual files.
Configuration: CREATEALTERORDERPRIMARYAGENTS
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
Source
Repository: https://github.com/clickhouse/agent-skills
clickhouse-best-practices FAQ
What does the clickhouse-best-practices skill do?
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses. Schema discovery + query execution: any model — the steps are procedural EXPLAIN analysis + query optimization: benefits from mid-tier reasoning
What does clickhouse-best-practices require?
Use AGENTS.md when you need to check multiple rules quickly without reading individual files. Configuration keys: CREATE, ALTER, ORDER, PRIMARY, AGENTS.
How do I install clickhouse-best-practices?
Run: npx -y skills add https://github.com/clickhouse/agent-skills --skill clickhouse-best-practices --agent claude-code — the source lives at github.com/clickhouse/agent-skills.
Maintain clickhouse-best-practices?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[](https://getagentictools.com/skills/clickhouse-agent-skills-clickhouse-best-practices?ref=badge) npx agentictools info skills/clickhouse-agent-skills-clickhouse-best-practices The second line is the CLI lookup for this page — handy in READMEs and docs.
