# ClickHouse agent skills for Claude Code, Cursor and RevampKey

> Ready-made ClickHouse playbooks for AI agents: audit ClickHouse backups and ClickPipe health with AI, review ClickHouse query performance and cost. Free SKILL.md files for Claude Code, Cursor and Codex, or one click in RevampKey.

## Skills

- [ClickHouse Cloud essentials for AI assistants](https://revampkey.com/marketplace/clickhouse/skills/essentials.md): Teaches an AI assistant to use the ClickHouse Cloud remote MCP connector safely: confirm the organization and service first, pick the right read-only tool, and run bounded SELECT queries. It never changes data.
- [Audit ClickHouse backups and ClickPipe health with AI](https://revampkey.com/marketplace/clickhouse/skills/backup-and-clickpipe-health-audit.md): Checks every ClickHouse service in an organization for recent, verified backups and reviews ClickPipe ingestion status, then returns a ranked health report. It only reads and never changes backups or pipes.
- [Review ClickHouse query performance and cost](https://revampkey.com/marketplace/clickhouse/skills/query-performance-and-cost-review.md): Finds why a ClickHouse service or query is slow or expensive by combining cost, service state and read-only schema and SELECT checks. It ranks the causes with evidence and suggests fixes you apply yourself, and it never changes your service.

## Install

- RevampKey: connect ClickHouse at https://revampkey.com/marketplace/clickhouse; the skills come with it.
- Any Agent Skills tool, into the current project:

```bash
for s in essentials backup-and-clickpipe-health-audit query-performance-and-cost-review; do
  curl -fsSL --create-dirs -o .agents/skills/clickhouse-$s/SKILL.md https://revampkey.com/marketplace/clickhouse/skills/$s/SKILL.md
done
```

### What is a ClickHouse agent skill?

A SKILL.md file: a short playbook an AI agent loads when your request matches it. Each ClickHouse skill describes one job, which ClickHouse tools to use in which order, what to check first and when to stop and ask you.

### Do the ClickHouse skills change anything on their own?

3 of the 3 only read. The others tell the agent to show you the change and wait for a yes before it creates, edits or deletes anything in ClickHouse.

### Which tools can use these skills?

Any agent that reads the open Agent Skills format: Claude Code, Cursor, Codex, VS Code with Copilot and RevampKey. In RevampKey they are attached when you connect ClickHouse; elsewhere you copy the folders into your project or skills directory.

### Do I need the ClickHouse MCP server too?

Yes. The skills tell the agent how to do the work; the ClickHouse MCP server gives it the tools to do it. The ClickHouse MCP setup guide covers every client.

MCP setup guide: https://revampkey.com/marketplace/clickhouse.md