clickhouse-best-practices
Comprehensive rules and review procedures for ClickHouse schema design, query optimization, and data ingestion.
Install
npx skills add https://github.com/clickhouse/agent-skills --skill clickhouse-best-practicesStats
| Total installs | 1,659 |
| Weekly installs | 1.7K |
| GitHub stars | 376 |
| First seen | Jan 27, 2026 |
| Source | @clickhouse/agent-skills |
Summary
- Covers three critical areas: primary key and data type selection (immutable design decisions), JOIN and query optimization, and insert batching with mutation avoidance
- Includes 28 rules prioritized by impact, with schema design and query optimization rules marked CRITICAL due to ClickHouse's columnar storage and sparse index mechanics
- Provides structured review procedures for schemas, queries, and insert strategies, with checklists and rule citations for formal code reviews
- Each rule file contains incorrect/correct examples and trade-off context; full compiled guide available in AGENTS.md for quick multi-rule reference
Tags
Related skills
| Skill | Installs | vs clickhouse-best-practices |
|---|---|---|
| postgres-pro | 1,525 | -134 |
| convex-migrations | 1,408 | -251 |
| memory-management | 1,543 | -116 |
| fastapi-expert | 1,625 | -34 |
| fastapi | 1,967 | +308 |
FAQ
- How many installs does clickhouse-best-practices have?
- clickhouse-best-practices has 1,659 total installs and 1.7K installs this week.
- Where is clickhouse-best-practices hosted?
- clickhouse-best-practices is published by @clickhouse/agent-skills at https://github.com/clickhouse/agent-skills.
- How many GitHub stars does clickhouse-best-practices have?
- clickhouse-best-practices has 376 GitHub stars.
- When was clickhouse-best-practices first indexed?
- OrangeBot.AI first indexed clickhouse-best-practices on Jan 27, 2026.
- How do I install clickhouse-best-practices?
- Run: npx skills add https://github.com/clickhouse/agent-skills --skill clickhouse-best-practices