clickhouse-best-practices: a Claude Code skill by ClickHouse
Official
For teams designing or reviewing ClickHouse tables, queries and inserts against the vendor's own rules. Skip it if you don't run ClickHouse.
- Score
- 76of 100
- Rank
- #111of 239
- Installs
- 22.9Kon skills.sh
- Security
- Clear 5 scanners
- Updated
- 2026
- Context
- ~59tokens always
Install
npx skills add https://github.com/clickhouse/agent-skills --skill clickhouse-best-practices
Run it in your terminal. View the source
Using the Claude app rather than Claude Code? You can add a skill there too. How to add it in the app
What does clickhouse-best-practices do?
clickhouse-best-practices is a skill from ClickHouse Inc that checks schemas, queries and ingestion plans against 31 rules and cites each one by name. For a schema review it reads rules on ORDER BY planning, key column order, native types, LowCardinality, Nullable and partition counts. Query reviews cover JOIN algorithms, filtering before joins, ANY JOIN and skipping indices; insert reviews cover 10K to 100K row batches, async inserts and avoiding ALTER UPDATE and OPTIMIZE FINAL. When an agent queries a live database, it connects by MCP or CLI, discovers the schema in seven steps, and runs queries with LIMIT and timeouts. Output lists rules checked, violations and fixes.
When should you use clickhouse-best-practices?
Use it when
- You are writing a CREATE TABLE for ClickHouse
- A ClickHouse query or JOIN runs slowly
- An agent needs safe access to a ClickHouse database
Skip it when
- Your data lives in Postgres, MySQL or another engine
- You want a general SQL tutorial
What it needs and what it can touch
You need
- A ClickHouse database, plus the ClickHouse MCP server or CLI for live queries
What it can do
- Runs queries on your ClickHouse database when connected
- May search the web for current ClickHouse guidance
From reading its instructions, not from running it.
Why it scores 76
Strongest on upkeep (100 of 100), weakest on adoption (39).
Is clickhouse-best-practices safe to install?
Every scanner that checked it passed it. Scanners often miss what other scanners catch, and a skill can change after a scan. Read its source before you install it.
| Scanner | Result | Date |
|---|---|---|
| Gen Agent Trust Hub | Passed | Sep 14, 2026 |
| Socket | Passed | Sep 14, 2026 |
| Snyk | Low risk | Sep 14, 2026 |
| Runlayer | Low risk | Feb 26, 2026 |
| ZeroLeaks | Passed | Apr 15, 2026 |
Details
- Installs
- 22,879
- Repository stars
- 565
- Last repository change
- Tokens always loaded
- about 59
- Tokens when used
- about 2,498
- License
- Apache-2.0
- Data confidence
- High
Did it do the job for you?
Alternatives to clickhouse-best-practices
All skills for this job-
Get supabase-postgres-best-practicessupabase-postgres-best-practices
For developers writing SQL, schemas or row level security policies on any Postgres database.
-
Get neon-postgresneon-postgres
For developers whose Postgres runs on Neon and who want help with connection strings, branches and slow queries.
-
Get sanity-best-practicessanity-best-practices
For developers building or fixing a Sanity project who want Sanity's own patterns for schemas and GROQ.
-
Get instrument-eventsinstrument-events
For product teams adding Amplitude tracking who want each call placed at the right line of code.
clickhouse-best-practices