Agent Skills
Installable agent skills package for ClickHouse and chdb best practices, schema design, query optimization, and data ingestion patterns.
ClickHouse · AI review on file
Installation
Read the source and dependencies before running a command. Copying does not install or execute anything.
npx skills add ClickHouse/agent-skillsAbout this skill
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 |