ClickHouse agent skills for Claude Code, Cursor and RevampKey

3 ready-made playbooks that teach an AI agent how to do real ClickHouse work: which tools to call, what to check first, and when to stop and ask you.

Download RevampKey, free I have it: connect ClickHouse

Connect ClickHouse once and all 3 skills install themselves and stay up to date. Mac, Windows and Linux.

All 3 ClickHouse skills

Each skill is one job. You ask in plain words and the agent loads the skill that matches, then follows its steps.

Start hereRead-only13 ClickHouse tools

ClickHouse Cloud essentials for AI assistants

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.

Use it when

You connect ClickHouse Cloud to an AI assistant for the first time
You want to explore tables in a specific ClickHouse service
You need to know what the connector can and cannot do

Tools it uses

get_organizations
get_services_list
get_service_details
get_organization_details
get_organization_cost
list_databases
list_tables
run_select_query
list_service_backups
get_service_backup_details
get_service_backup_configuration
list_clickpipes
get_clickpipe

Example

Connect to my ClickHouse Cloud and show me which tables are in the prod-analytics service.

I found two organizations in your account and used the one with prod-analytics. That service has 3 databases. The analytics database holds 14 tables, including events and sessions. I listed them with a filter and did not change anything.

Use in RevampKeyRead the full skill →

Read-only8 ClickHouse tools

Audit ClickHouse backups and ClickPipe health with AI

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.

Use it when

You want to confirm that all production ClickHouse services have recent backups before a release.
A pipeline looks quiet and you need to know whether it is stalled or failing.
You are preparing a disaster-recovery review for the organization.

Tools it uses

get_organizations
get_organization_details
get_services_list
list_service_backups
get_service_backup_details
get_service_backup_configuration
list_clickpipes
get_clickpipe

Example

Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.

Audited 6 ClickHouse services in Acme Analytics as of 2026-03-14 UTC. 2 have critical backup gaps: analytics-prod has no backup in 9 days, and events-staging has backups disabled. Of 4 ClickPipes, 1 is failing with a schema error (orders-ingest into analytics-prod) and 1 has stopped advancing (clicks-stream). The other 2 are running and current.

Use in RevampKeyRead the full skill →

Read-only7 ClickHouse tools

Review ClickHouse query performance and cost

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.

Use it when

A ClickHouse bill jumped and you want to know which service is responsible
A dashboard query got slow and you need to know whether the table or the size is the cause
You want to find the cheapest safe way to speed up a heavy workload

Tools it uses

get_organizations
get_services_list
get_organization_cost
get_service_details
list_databases
list_tables
run_select_query

Example

Why did our ClickHouse spend jump in the second half of last month, and what is causing it?

The analytics service accounts for most of the spend, and it rose sharply on the 14th. Its dashboard refresh scans the full events table with no time filter, running about every 3 minutes. Adding a time filter or a materialized view for that aggregate should cut the scanned volume substantially. I did not change anything; this is the fix for you to apply.

Use in RevampKeyRead the full skill →

Get all 3 without copying a file

RevampKey adds the skills when you connect ClickHouse, updates them for you and removes them when you disconnect.

Download RevampKey

How ClickHouse skills work

Connect ClickHouse
The ClickHouse MCP server gives the agent its tools.
Ask in plain words
“Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.” Each SKILL.md says when it applies, so only the one that fits is loaded.
Approve any change
The agent calls the tools in order, checks its work, and shows you any change before it makes it.

How to install ClickHouse skills

In RevampKey the skills install themselves when you connect ClickHouse. In other tools each skill is one folder with a SKILL.md file, and you also need the ClickHouse MCP server connected there.

About 1 minute · nothing to copy

Download RevampKey for Mac, Windows or Linux and sign in.
Open Connectors and connect ClickHouse. All 3 skills come with it and stay up to date; they go away when you remove the connector.
Ask in plain language, for example “Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.”
Download RevampKeyConnect ClickHouse · 1 click
Get RevampKey to connect ClickHouse
RevampKey is a free desktop app for Mac, Windows and Linux. Install it, sign in, and ClickHouse is one click away with its skills already attached.
Download RevampKey
Not now? Use the skills in your current tool
for s in essentials backup-and-clickpipe-health-audit query-performance-and-cost-review; do curl -fsSL --create-dirs -o .claude/skills/clickhouse-$s/SKILL.md https://revampkey.com/marketplace/clickhouse/skills/$s/SKILL.md done
Other tools

Into this project’s .claude/skills folder

Connect the ClickHouse MCP server in Claude Code.

Run this in your project folder to add all 3 skills:

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

Ask in plain language, for example “Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.”

Into the shared .agents/skills folder

Connect the ClickHouse MCP server in Cursor.

Run this in your project folder to add all 3 skills:

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

Ask in plain language, for example “Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.”

Into the shared .agents/skills folder

Connect the ClickHouse MCP server in Codex.

Run this in your project folder to add all 3 skills:

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

Ask in plain language, for example “Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.”

Into the shared .agents/skills folder

Connect the ClickHouse MCP server in VS Code.

Run this in your project folder to add all 3 skills:

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

Ask in plain language, for example “Audit backups and ClickPipes across my ClickHouse organization and tell me what needs attention.”

RevampKey or copy the files?

In RevampKey

One click when you connect ClickHouse
Updated for you when a skill improves
Removed when you disconnect
The MCP server is set up for you
800+ other connectors, same way

Download free

Copy into your project

One command per project
Run it again to get updates
You connect the ClickHouse MCP server yourself
Works in Claude Code, Cursor, Codex and VS Code

See the command

ClickHouse skills FAQ

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.

ClickHouse MCP server setup · This page as Markdown

Put ClickHouse’s best workflows in your agent

Download RevampKey, connect ClickHouse and ask your first question in about a minute.

Download RevampKey Connect ClickHouse · 1 click

All 3 ClickHouse skills

ClickHouse Cloud essentials for AI assistants

Use it when

Tools it uses

Audit ClickHouse backups and ClickPipe health with AI

Use it when

Tools it uses

Review ClickHouse query performance and cost

Use it when

Tools it uses

Get all 3 without copying a file

How ClickHouse skills work

How to install ClickHouse skills

RevampKey or copy the files?

In RevampKey

Copy into your project

ClickHouse skills FAQ

Put ClickHouse’s best workflows in your agent

Skills for related tools