ClickHouse Agent Skills
Official ClickHouse skills: schema design, queries, and chdb.
About
The official ClickHouse skill pack: 28 best-practice rules for schema design and query optimization, an architecture advisor, a Node.js client troubleshooting guide, chdb skills for in-process Python analytics (including a pandas-compatible DataStore), and infra skills for ClickHouse and Postgres via clickhousectl.
Honest limitations: genuinely useful only if you run ClickHouse or chdb — the best-practices rules don't transfer to other databases. The skills activate automatically, which is convenient but means you don't always see which rule shaped a query.
What it can do
- 28 ClickHouse best-practice rules
- Architecture decision frameworks
- chdb SQL and pandas-compatible DataStore
- Infra skills for ClickHouse and Postgres
Setup
- Run npx skills add clickhouse/agent-skills (the CLI auto-detects your agent).
- Or run clickhousectl skills.
- Ask ClickHouse questions naturally; skills activate when you create tables or write queries.
Prerequisites
Any of 20+ supported agents (Claude Code, Cursor, Copilot, Codex, and more). ClickHouse or chdb for the database-backed skills.
Use cases
Works with
Trust score — 9/10
Scored 9/10 (verified tier, metrics-v1). Evidence: 547 stars, 40 commits, 38 forks; official ClickHouse repo; 8 skills with detailed docs: 28 best-practice rules, architecture advisor, chdb skills, infra skills; Supported-agents table lists 20+ agents; strongest vendor skill in this batch. License: Apache-2.0.
★ 547 GitHub stars
How the trust score is built
Full methodology →- Adoption · stars/downloads, log-scaled vs peers
- 8.0/10
- Maintenance · recency, releases, issue load
- 8.0/10
- Openness · license + docs
- 9.0/10
- Manual review · sanity read + red-flag check
- 9.0/10
- · 547 stars, 40 commits, 38 forks; official ClickHouse repo
- · 8 skills with detailed docs: 28 best-practice rules, architecture advisor, chdb skills, infra skills
- · Supported-agents table lists 20+ agents; strongest vendor skill in this batch
Sources
Every fact above was checked against these sources. Where a claim comes from the provider and couldn't be independently verified, the text says so.