ClickHouse/agent-skills

Registry

Summary

The official Claude Skill repository for ClickHouse and ClickHouse Cloud, providing agent capabilities to interact with these database platforms.

Key features

• Official ClickHouse integration
• Designed for ClickHouse Cloud
• Agent framework implementation
• JavaScript-based development

Use cases

• Building AI agents for ClickHouse
• Cloud database automation
• Query execution and management
• Database monitoring agents

README excerpt

# ClickHouse Agent Skills The official Agent Skills for [ClickHouse](https://clickhouse.com/). These skills help LLMs and agents to adopt best practices when working with ClickHouse and [chdb](https://clickhouse.com/docs/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](https://clickhouse.com/cloud?utm_medium=github&utm_source=github&utm_ref=agent-skills). ## Installation ### npx ```bash 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`](https://github.com/ClickHouse/clickhousectl) to install the agent skills: ```bash 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](https://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 | CRI

Topics