# ClickHouse Best Practices

> 28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact

## Facts
- Page: https://tashan.sh/capability/plugin-clickhouse-agent-skills-clickhouse-best-practices
- tashan id: plugin:clickhouse/agent-skills/clickhouse-best-practices
- Source: https://github.com/ClickHouse/agent-skills
- Type: plugin
- Category: database
- tashan score: 71.0 / 100
- Adoption: 49.0
- Upkeep: 93.0
- Freshness: 84.0
- Evidence coverage: 84% of the inputs this score can use
- Health: active
- Instruction depth: solid
- GitHub stars: 498
- License: Apache-2.0
- Official: no

## Install

```sh
/plugin marketplace add anthropics/claude-plugins-community
/plugin install clickhouse-best-practices@claude-community
```

## Security audit
Not scanned. We audit npm-published capabilities; this one has no npm package we can resolve, or has not reached the queue. This is not a clean bill of health.

---
Measured 2026-09-13 by tashan (https://tashan.sh) from public evidence. Scorer s5.