Give your coding agent guidance for designing ClickHouse databases, building applications, analyzing data and troubleshooting performance.
ClickHouse Agent Skills gives coding agents task-specific instructions for working with ClickHouse and chdb. It helps with database design, application code, Python analytics and database operations, including local development and ClickHouse Cloud.
The agent can select a relevant skill from your request. In Claude Code, you can also select a plugin skill yourself from the slash menu. These are instructions the agent follows; accessing your databases or managing cloud services still requires the tools and credentials for that task.
Ask the agent to review table definitions, sort keys, data types, joins or insert patterns against ClickHouse-specific rules. For broader design decisions, the architecture advisor weighs ingestion, enrichment, late-arriving data and pre-aggregation against your workload.
Use chdb guidance to query Parquet or CSV files and join them with remote data from Python, without running a separate ClickHouse server. Choose pandas-style DataStore operations or SQL. The skills specify Python 3.9 or later on macOS or Linux.
Get guidance for configuring the ClickHouse client, inserting rows, reading results and binding query parameters. Separate skills cover connection and data-type errors, and generating RowBinary readers or writers. These skills target Node.js, including server-side Next.js code; browser and Edge runtimes are outside their scope.
Ask the agent to follow clickhousectl workflows for local ClickHouse or Docker-backed Postgres, then create or manage services in ClickHouse Cloud. Cloud operations need authentication and can create billable resources; managed Postgres is marked beta.
Follow a workflow for deploying a local OpenTelemetry collector or configuring an existing gateway collector, creating an ingest user, sending test telemetry and checking that it appears in ClickStack. This requires a target Managed ClickStack service and the tools for the chosen collector setup.
Use Prometheus metrics and the beta Slow Query Patterns API to investigate a ClickHouse-managed Postgres service. Supply the organization and service IDs plus a Cloud API key and secret. The skill recommends a fix without applying it and does not have query plans or per-table scan counters.
The collection has 11 skills. The Claude Code plugin loads all 11; Codex and Copilot CLI plugin installs load the eight listed in the manifest. Skills CLI offers all 11 for selection, and clickhousectl installs all 11.
Showing all 11
Review ClickHouse schemas, queries and ingestion patterns against task-specific rules.
Choose ingestion, enrichment, partitioning and pre-aggregation patterns for your workload.
Analyze and join files or remote data with pandas-style operations in Python.
Run ClickHouse SQL on files and remote sources inside Python, without a server.
Write ClickHouse application code for Node.js. Available through the Claude Code plugin, Skills CLI and clickhousectl; excluded from Codex and Copilot plugin installs.
Generate RowBinary readers and writers for Node.js. Available through the Claude Code plugin, Skills CLI and clickhousectl; excluded from Codex and Copilot plugin installs.
Diagnose Node.js client connection, TLS, compression, query and data-type errors.
Set up local ClickHouse or manage ClickHouse Cloud services with clickhousectl.
Run local Postgres or manage and migrate to ClickHouse Cloud Postgres.
Investigate managed Postgres performance and recommend fixes without applying them. Available through the Claude Code plugin, Skills CLI and clickhousectl; excluded from Codex and Copilot plugin installs.
Connect a new or existing OpenTelemetry collector to Managed ClickStack and verify ingestion.
No matching results.
Choose your AI tool, then an installation method. Marketplace routes install plugins; Skills CLI and clickhousectl install skills directly.
This installs all 11 skills directly. clickhousectl supports macOS and Linux on ARM64 and x86_64. Its first run sends no telemetry; collection begins on a later run unless disabled. See the installation and telemetry settings.
Run this in your project terminal to install clickhousectl and open its skill installer. Choose Claude Code and your installation scope. Make sure ~/.local/bin is on your PATH.
curl https://clickhouse.com/cli | sh
clickhousectl skillsIn Claude Code, list the available skills and check that the ClickHouse skills appear. If the installer created a skills directory after the session began, reload skills first.
/reload-skills/skillsInstall clickhouse-best-practices for the full collection of 11 skills. The marketplace also offers individual plugins for narrower tasks. The full-collection loading behavior is documented for Claude Code 2.1.136 and later.
Add the ClickHouse marketplace inside your Claude Code session.
/plugin marketplace add clickhouse/agent-skillsOpen the full collection's install panel, choose user, project or local scope, and complete the installation.
/plugin install clickhouse-best-practices@clickhouse-agent-skillsRead the installation summary. If it says the plugin is active, continue; if it asks for a reload, closing the panel normally applies it. If the plugin remains pending, use the reload command in the session.
/reload-pluginsType a forward slash in the session and look for skills prefixed with clickhouse-best-practices. You can also open the plugin panel and check its Installed tab.
/pluginFor a narrower install, use the panel's Discover tab to choose a ClickHouse marketplace entry and install that plugin as a whole. See Claude Code's plugin installation guide for scope and reload details.
Use Node.js 22.20 or later. This installer offers all 11 skills and installs your selection directly. It collects anonymous usage data; see its telemetry settings before running if you want to opt out.
Run this in your project terminal, choose the skills you want and select Claude Code. The default scope is the current project; the installer also supports a global scope.
npx skills add clickhouse/agent-skillsIn Claude Code, check the available skill list. If the installer created the top-level skills directory during this session, reload skills first.
/reload-skills/skillsThis route installs skills for GitHub Copilot in VS Code. Use Node.js 22.20 or later, and review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in the project's terminal. Select your skills and GitHub Copilot, then choose project or global scope.
npx skills add clickhouse/agent-skillsIn VS Code's Copilot chat, open Customizations and check the installed skills. Type a forward slash in chat to find an available skill. See VS Code's skill guide for harness-specific discovery.
The clickhouse-best-practices plugin loads eight manifest-listed skills. To install Node.js coding, RowBinary generation or managed Postgres investigation skills, use Skills CLI instead.
Add the ClickHouse marketplace from your terminal.
copilot plugin marketplace add ClickHouse/agent-skillsInstall the plugin from the same terminal.
copilot plugin install clickhouse-best-practices@clickhouse-agent-skillsList installed plugins in the terminal and confirm that clickhouse-best-practices appears.
copilot plugin listThese commands combine GitHub's plugin installation syntax with ClickHouse's marketplace and plugin names. The marketplace also lists individual plugins for narrower tasks.
Use Node.js 22.20 or later. Skills CLI offers all 11 skills for direct installation. Review its telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select the skills you want, GitHub Copilot and project or global scope.
npx skills add clickhouse/agent-skillsStart a Copilot CLI session, then list the available skills and confirm your selections appear.
/skills listUse Node.js 22.20 or later. Review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills, Cursor and project or global scope.
npx skills add clickhouse/agent-skillsRestart Cursor so it discovers the new skills. In Agent chat, type a forward slash and search for a selected skill's name. See Cursor's skill guide.
Use Node.js 22.20 or later. The installer's Windsurf target uses skill directories that Devin Desktop continues to read. Review its telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills, Windsurf and project or global scope.
npx skills add clickhouse/agent-skillsOpen Customize in the Agents window and check the Skills tab for the skills the agent has loaded. See Devin Desktop's customization guide.
Use Node.js 22.20 or later. Review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills, Cline and project or global scope.
npx skills add clickhouse/agent-skillsIn Cline, click the scale icon at the bottom of the panel and open Skills. Confirm your selected skills are present and enabled. See Cline's skill guide.
Use Codex CLI for this route; plugins are unavailable in the IDE extension. The clickhouse-best-practices plugin loads eight manifest-listed skills. For Node.js coding, RowBinary generation or managed Postgres investigation, choose a direct skill installer instead.
Add the ClickHouse marketplace from your terminal.
codex plugin marketplace add ClickHouse/agent-skillsOpen the plugin browser in Codex CLI. Select the clickhouse-agent-skills marketplace and install clickhouse-best-practices for its eight bundled skills, or select an individual plugin for a narrower task.
/pluginsStart a new Codex session. Open the plugin browser again and confirm that the selected plugin is installed and enabled.
/pluginsThe marketplace command combines Codex's documented syntax and legacy marketplace support with the ClickHouse repository's marketplace identity.
Use Node.js 22.20 or later. This offers all 11 skills for direct installation, including the three excluded from Codex plugin installs. Review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills and Codex; choose project or global scope.
npx skills add clickhouse/agent-skillsIn Codex CLI or the IDE extension, open the skill picker and confirm that the selected skills appear. In the desktop app, check Skills in the sidebar. Codex detects skill changes automatically; restart it if the new skills do not appear.
/skillsThis installs all 11 skills directly. clickhousectl supports macOS and Linux on ARM64 and x86_64. Its first run sends no telemetry; collection begins on a later run unless disabled. See the installation and telemetry settings.
Run this in your project terminal to install clickhousectl and open its skill installer. Choose Codex and your installation scope. Make sure ~/.local/bin is on your PATH.
curl https://clickhouse.com/cli | sh
clickhousectl skillsIn Codex CLI or the IDE extension, open the skill picker and check for the ClickHouse skills. In the desktop app, check Skills in the sidebar. Restart Codex if the newly installed skills do not appear.
/skillsUse Node.js 22.20 or later. Review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills, Gemini CLI and project or global scope.
npx skills add clickhouse/agent-skillsIn Gemini CLI, reload skills and list them to confirm your selections appear.
/skills reload/skills listWhen Gemini selects a skill for a matching task, it asks you to approve activation and access to that skill's directory.
This route targets Kiro CLI. Use Node.js 22.20 or later, and review the installer's telemetry settings if you want to opt out of anonymous usage collection.
Run this in your project terminal. Select your skills, Kiro CLI and project or global scope.
npx skills add clickhouse/agent-skillsAsk Kiro which skills are available in the current session and check for your selections. See Kiro's skill guide.