Azure Cosmos Db Assistant
Expert assistant for Azure Cosmos DB — data modeling, query optimization, performance tuning, and best...
CCCXGBCUPi
SkillMaxx / Database / ClickHouse Best Practices
ClickHouse Best Practices
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
- Stars
- ★ 550
- Last updated
- Hands-on tests
- Tested ✓ in 2 of 5
Install
Tested ✓✓ Verified from docsOfficial docs ↗
/plugin install clickhouse-best-practices@claude-plugins-officialTested ✓ on 2026-10-16: installed and loaded in a throwaway sandbox with no credentials.
Log excerpt
Installing plugin "clickhouse-best-practices@claude-plugins-official"...✔ Successfully installed plugin: clickhouse-best-practices@claude-plugins-official (scope: user)
$ verify:
❯ clickhouse-best-practices@claude-plugins-official
Status: ✔ enabled1 run, latest 2026-10-16
Not yet tested
No official Codex instructions yet. We haven't found docs saying this works in Codex.
Know it works? Tell us →Tested ✓✓ Verified from docsOfficial docs ↗
Auto-loaded from your Claude Code plugins (no extra setup per xAI docs)Tested ✓ on 2026-10-16: installed and loaded in a throwaway sandbox with no credentials.
Log excerpt
Installed 1 plugin(s) from claude-plugins-official: clickhouse-best-practices $ verify: agent-skills-68f79860: clickhouse-best-practices [git: https://github.com/ClickHouse/agent-skills.git] (claude-plugins-official)
1 run, latest 2026-10-16
Not yet tested
No official Cursor instructions yet. We haven't found docs saying this works in Cursor.
Know it works? Tell us →Not yet tested
No official Pi instructions yet. We haven't found docs saying this works in Pi.
Know it works? Tell us →README
View on GitHub ↗ClickHouse Agent Skills
The official Agent Skills for ClickHouse. These skills help LLMs and agents to adopt best practices when working with ClickHouse and chdb (in-process ClickHouse for Python).
You can use these skills with open-source ClickHouse and managed ClickHouse Cloud. Try ClickHouse Cloud with $300 in free credits.
Installation
npx
npx skills add clickhouse/agent-skills
The CLI auto-detects installed agents and prompts you to select where to install.
clickhousectl
Use the ClickHouse CLI clickhousectl to install the agent skills:
clickhousectl skills
What is this?
Agent Skills are packaged instructions that extend AI coding agents (Claude Code, Cursor, Copilot, etc.) with domain-specific expertise. This repository provides skills for ClickHouse databases and chdb — covering schema design, query optimization, data ingestion patterns, and in-process analytics with Python.
When an agent loads these skills, it gains knowledge of ClickHouse best practices and chdb APIs, and can apply them while helping you design tables, write queries, analyze data, or troubleshoot performance issues.
Skills follow the open specification at agentskills.io.
Available Skills
ClickHouse Best Practices
28 rules covering schema design, query optimization, and data ingestion—prioritized by impact.
| Category | Rules | Impact |
|---|---|---|
| Primary Key Selection | 4 | CRITICAL |
| Data Type Selection | 5 | CRITICAL |
| JOIN Optimization | 5 | CRITICAL |
| Insert Batching | 1 | CRITICAL |
| Mutation Avoidance | 2 | CRITICAL |
| Partitioning Strategy | 4 | HIGH |
| Skipping Indices | 1 | HIGH |
| Materialized Views | 2 | HIGH |
| Async Inserts | 2 | HIGH |
| OPTIMIZE Avoidance | 1 | HIGH |
| JSON Usage | 1 | MEDIUM |
Location: skills/clickhouse-best-practices/
For humans: Read SKILL.md for an overview, or AGENTS.md for the complete compiled guide.
Preview from the source repo. Images are removed.
Similar alternatives
Redis Development
Redis development best practices — data structures, query engine, vector search, caching, and performance...
CCCXGBCUPi
Bigquery Data Analytics
Connect, query, and generate data insights for BigQuery datasets and data.
CCCXGBCUPi
Oracledb
Connect, query, and interact with Oracle Databases and their data.
CCCXGBCUPi