# ClickHouse AI Agent Skills ClickHouse publishes official AI agent skills for its tools, services, and developer workflows. Browse 53 official AI agent skills across 9 ClickHouse repositories, with install commands and source links. Official page: https://skillscout.sh/official/clickhouse/ Markdown page: https://skillscout.sh/official/clickhouse/clickhouse_skills_skillscout.md Vendor website: https://clickhouse.com/ ## Prompt for your agent Fetch this Markdown manifest as plain text: https://skillscout.sh/official/clickhouse/clickhouse_skills_skillscout.md. If your browser cannot display the Markdown directly, use curl or another text fetcher. Recommend the relevant ClickHouse skills package or packages for my goal, explain which individual skills matter, and wait for my approval. After I approve, install with the npx command. If no project is open, install it as an agent skill I can use later. ## Skills packages ### clickhouse/agent-skills Includes 11 official skills: clickhouse-best-practices, clickhouse-architecture-advisor, chdb-datastore, chdb-sql, clickhouse-js-node-troubleshooting, clickhouse-js-node-coding. Install: ```bash npx skills add clickhouse/agent-skills -y ``` Source: https://www.skills.sh/official#clickhouse/agent-skills ### clickhouse/clickhouse-js Includes 3 official skills: clickhouse-js-node-troubleshooting, clickhouse-js-node-coding, clickhouse-js-node-rowbinary. Install: ```bash npx skills add clickhouse/clickhouse-js -y ``` Source: https://www.skills.sh/official#clickhouse/clickhouse-js ### clickhouse/clickhouse Includes 14 official skills: clickhouse-pr-description, review, cpu-profile, alloc-profile, bisect, create-worktree. Install: ```bash npx skills add clickhouse/clickhouse -y ``` Source: https://www.skills.sh/official#clickhouse/clickhouse ### clickhouse/clickhouse-claude-code-plugin Includes 2 official skills: setup, clickhouse-best-practices. Install: ```bash npx skills add clickhouse/clickhouse-claude-code-plugin -y ``` Source: https://www.skills.sh/official#clickhouse/clickhouse-claude-code-plugin ### clickhouse/pg_stat_ch Includes 5 official skills: cpp-header-template, cpp-naming-check, cpp-review, create-new-release, google-cpp-style. Install: ```bash npx skills add clickhouse/pg_stat_ch -y ``` Source: https://www.skills.sh/official#clickhouse/pg_stat_ch ### clickhouse/nerve Includes 2 official skills: nerve-dev, nerve-workspace. Install: ```bash npx skills add clickhouse/nerve -y ``` Source: https://www.skills.sh/official#clickhouse/nerve ### clickhouse/mintlify-docs-dev Includes 9 official skills: chdb-datastore, chdb-sql, clickhouse-architecture-advisor, clickhouse-best-practices, clickhouse-js-node-coding, clickhouse-js-node-troubleshooting. Install: ```bash npx skills add clickhouse/mintlify-docs-dev -y ``` Source: https://github.com/ClickHouse/mintlify-docs-dev ### clickhouse/skills Covers chdb-datastore, chdb-sql, clickhouse-architecture-advisor, clickhouse-best-practices, clickhousectl-cloud-deploy, clickhousectl-local-dev. chDB DataStore exposes the ClickHouse engine behind a pandas-compatible API so existing pandas code runs 10-100x faster on large datasets, with cross-source joins across MySQL, PostgreSQL, S3, MongoDB, ClickHouse, Iceberg, Delta Lake, and file formats like Parquet, CSV, JSON, Arrow, and ORC. chDB SQL runs ClickHouse SQL queries directly against local files, remote databases, and cloud storage from Python without a running ClickHouse server. Install: ```bash npx skills add clickhouse/skills -y ``` Source: https://officialskills.sh/clickhouse/skills ### clickhouse/clickhouse-docs Includes 1 official skill: clickstack-otel-collector. Install: ```bash npx skills add clickhouse/clickhouse-docs -y ``` Source: https://github.com/ClickHouse/clickhouse-docs ## Individual skills ### clickhouse-best-practices Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-best-practices -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-best-practices ### clickhouse-architecture-advisor Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-architecture-advisor -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-architecture-advisor ### chdb-datastore Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@chdb-datastore -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/chdb-datastore ### chdb-sql Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@chdb-sql -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/chdb-sql ### clickhouse-js-node-troubleshooting Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-js-node-troubleshooting -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-js-node-troubleshooting ### clickhouse-js-node-coding Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-js-node-coding -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-js-node-coding ### clickhouse-managed-postgres-rca Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-managed-postgres-rca -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-managed-postgres-rca ### clickhouse-js-node-rowbinary Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickhouse-js-node-rowbinary -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickhouse-js-node-rowbinary ### clickstack-otel-collector Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@clickstack-otel-collector -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/clickstack-otel-collector ### infra-clickhouse Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@infra-clickhouse -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/infra-clickhouse ### infra-postgres Official ClickHouse skill from clickhouse/agent-skills. Install: ```bash npx skills add clickhouse/agent-skills@infra-postgres -y ``` Package: clickhouse/agent-skills Source: https://github.com/clickhouse/agent-skills/tree/HEAD/skills/infra-postgres ### clickhouse-js-node-troubleshooting Official ClickHouse skill from clickhouse/clickhouse-js. Install: ```bash npx skills add clickhouse/clickhouse-js@clickhouse-js-node-troubleshooting -y ``` Package: clickhouse/clickhouse-js Source: https://github.com/clickhouse/clickhouse-js/tree/HEAD/skills/clickhouse-js-node-troubleshooting ### clickhouse-js-node-coding Official ClickHouse skill from clickhouse/clickhouse-js. Install: ```bash npx skills add clickhouse/clickhouse-js@clickhouse-js-node-coding -y ``` Package: clickhouse/clickhouse-js Source: https://github.com/clickhouse/clickhouse-js/tree/HEAD/skills/clickhouse-js-node-coding ### clickhouse-js-node-rowbinary Official ClickHouse skill from clickhouse/clickhouse-js. Install: ```bash npx skills add clickhouse/clickhouse-js@clickhouse-js-node-rowbinary -y ``` Package: clickhouse/clickhouse-js Source: https://github.com/clickhouse/clickhouse-js/tree/HEAD/skills/clickhouse-js-node-rowbinary ### clickhouse-pr-description Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@clickhouse-pr-description -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/clickhouse-pr-description ### review Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@review -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/review ### cpu-profile Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@cpu-profile -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/cpu-profile ### alloc-profile Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@alloc-profile -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/alloc-profile ### bisect Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@bisect -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/bisect ### create-worktree Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@create-worktree -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/create-worktree ### fix-sync Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@fix-sync -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/fix-sync ### continue-pr Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@continue-pr -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/continue-pr ### perf-report Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@perf-report -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/perf-report ### install-skills Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@install-skills -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/install-skills ### update-contrib Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@update-contrib -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/update-contrib ### close-flaky-issues Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@close-flaky-issues -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/close-flaky-issues ### edit-changelog Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@edit-changelog -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/edit-changelog ### keeper-stress-analysis Official ClickHouse skill from clickhouse/clickhouse. Install: ```bash npx skills add clickhouse/clickhouse@keeper-stress-analysis -y ``` Package: clickhouse/clickhouse Source: https://www.skills.sh/clickhouse/clickhouse/keeper-stress-analysis ### setup Official ClickHouse skill from clickhouse/clickhouse-claude-code-plugin. Install: ```bash npx skills add clickhouse/clickhouse-claude-code-plugin@setup -y ``` Package: clickhouse/clickhouse-claude-code-plugin Source: https://github.com/clickhouse/clickhouse-claude-code-plugin/tree/HEAD/skills/setup ### clickhouse-best-practices Official ClickHouse skill from clickhouse/clickhouse-claude-code-plugin. Install: ```bash npx skills add clickhouse/clickhouse-claude-code-plugin@clickhouse-best-practices -y ``` Package: clickhouse/clickhouse-claude-code-plugin Source: https://github.com/clickhouse/clickhouse-claude-code-plugin/tree/HEAD/skills/clickhouse-best-practices ### cpp-header-template Official ClickHouse skill from clickhouse/pg_stat_ch. Install: ```bash npx skills add clickhouse/pg_stat_ch@cpp-header-template -y ``` Package: clickhouse/pg_stat_ch Source: https://www.skills.sh/clickhouse/pg_stat_ch/cpp-header-template ### cpp-naming-check Official ClickHouse skill from clickhouse/pg_stat_ch. Install: ```bash npx skills add clickhouse/pg_stat_ch@cpp-naming-check -y ``` Package: clickhouse/pg_stat_ch Source: https://www.skills.sh/clickhouse/pg_stat_ch/cpp-naming-check ### cpp-review Official ClickHouse skill from clickhouse/pg_stat_ch. Install: ```bash npx skills add clickhouse/pg_stat_ch@cpp-review -y ``` Package: clickhouse/pg_stat_ch Source: https://www.skills.sh/clickhouse/pg_stat_ch/cpp-review ### create-new-release Official ClickHouse skill from clickhouse/pg_stat_ch. Install: ```bash npx skills add clickhouse/pg_stat_ch@create-new-release -y ``` Package: clickhouse/pg_stat_ch Source: https://www.skills.sh/clickhouse/pg_stat_ch/create-new-release ### google-cpp-style Official ClickHouse skill from clickhouse/pg_stat_ch. Install: ```bash npx skills add clickhouse/pg_stat_ch@google-cpp-style -y ``` Package: clickhouse/pg_stat_ch Source: https://www.skills.sh/clickhouse/pg_stat_ch/google-cpp-style ### nerve-dev Official ClickHouse skill from clickhouse/nerve. Install: ```bash npx skills add clickhouse/nerve@nerve-dev -y ``` Package: clickhouse/nerve Source: https://github.com/clickhouse/nerve/tree/HEAD/nerve/templates/skills/nerve-dev ### nerve-workspace Official ClickHouse skill from clickhouse/nerve. Install: ```bash npx skills add clickhouse/nerve@nerve-workspace -y ``` Package: clickhouse/nerve Source: https://github.com/clickhouse/nerve/tree/HEAD/nerve/templates/skills/nerve-workspace ### chdb-datastore Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@chdb-datastore -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/chdb-datastore ### chdb-sql Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@chdb-sql -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/chdb-sql ### clickhouse-architecture-advisor Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhouse-architecture-advisor -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/clickhouse-architecture-advisor ### clickhouse-best-practices Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhouse-best-practices -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/ClickHouse/mintlify-docs-dev/tree/main/.mintlify/skills/clickhouse-best-practices ### clickhouse-js-node-coding Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhouse-js-node-coding -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/clickhouse-js-node-coding ### clickhouse-js-node-troubleshooting Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhouse-js-node-troubleshooting -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/ClickHouse/mintlify-docs-dev/tree/main/.mintlify/skills/clickhouse-js-node-troubleshooting ### clickhouse-managed-postgres-rca Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhouse-managed-postgres-rca -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/clickhouse-managed-postgres-rca ### clickhousectl-cloud-deploy Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhousectl-cloud-deploy -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/clickhousectl-cloud-deploy ### clickhousectl-local-dev Official ClickHouse skill from clickhouse/mintlify-docs-dev. Install: ```bash npx skills add clickhouse/mintlify-docs-dev@clickhousectl-local-dev -y ``` Package: clickhouse/mintlify-docs-dev Source: https://github.com/clickhouse/mintlify-docs-dev/tree/HEAD/.mintlify/skills/clickhousectl-local-dev ### chdb-datastore chDB DataStore exposes the ClickHouse engine behind a pandas-compatible API so existing pandas code runs 10-100x faster on large datasets, with cross-source joins across MySQL, PostgreSQL, S3, MongoDB, ClickHouse, Iceberg, Delta Lake, and file formats like Parquet, CSV, JSON, Arrow, and ORC. Install: ```bash npx skills add clickhouse/skills@chdb-datastore -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/chdb-datastore ### chdb-sql chDB SQL runs ClickHouse SQL queries directly against local files, remote databases, and cloud storage from Python without a running ClickHouse server. Install: ```bash npx skills add clickhouse/skills@chdb-sql -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/chdb-sql ### clickhouse-architecture-advisor Complements clickhouse-best-practices with decision frameworks and explicit provenance labels for designing ClickHouse architectures, selecting between ingestion or modeling patterns, and mapping best practices onto specific workloads. Install: ```bash npx skills add clickhouse/skills@clickhouse-architecture-advisor -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/clickhouse-architecture-advisor ### clickhouse-best-practices A set of 28 validated rules for ClickHouse covering schema design, query optimization, and data ingestion. Install: ```bash npx skills add clickhouse/skills@clickhouse-best-practices -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/clickhouse-best-practices ### clickhousectl-cloud-deploy Guides deployments to ClickHouse Cloud using clickhousectl, covering first-time production rollouts, managed service setup, and migration from a local ClickHouse to ClickHouse Cloud. Install: ```bash npx skills add clickhouse/skills@clickhousectl-cloud-deploy -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/clickhousectl-cloud-deploy ### clickhousectl-local-dev Covers the full flow from zero to a working local ClickHouse setup with clickhousectl: install ClickHouse, create a local server, create tables, and start developing an application against it. Install: ```bash npx skills add clickhouse/skills@clickhousectl-local-dev -y ``` Package: clickhouse/skills Source: https://officialskills.sh/clickhouse/skills/clickhousectl-local-dev ### clickstack-otel-collector Official ClickHouse skill from clickhouse/clickhouse-docs. Install: ```bash npx skills add clickhouse/clickhouse-docs@clickstack-otel-collector -y ``` Package: clickhouse/clickhouse-docs Source: https://github.com/clickhouse/clickhouse-docs/tree/HEAD/static/skills/clickstack-otel-collector ## clickhouse/agent-skills package overview Includes 11 official skills: clickhouse-best-practices, clickhouse-architecture-advisor, chdb-datastore, chdb-sql, clickhouse-js-node-troubleshooting, clickhouse-js-node-coding. ### Top skills in this package - clickhouse-best-practices: Official ClickHouse skill from clickhouse/agent-skills. - clickhouse-architecture-advisor: Official ClickHouse skill from clickhouse/agent-skills. - chdb-datastore: Official ClickHouse skill from clickhouse/agent-skills. - chdb-sql: Official ClickHouse skill from clickhouse/agent-skills. - clickhouse-js-node-troubleshooting: Official ClickHouse skill from clickhouse/agent-skills. - clickhouse-js-node-coding: Official ClickHouse skill from clickhouse/agent-skills. - clickhouse-managed-postgres-rca: Official ClickHouse skill from clickhouse/agent-skills. - clickhouse-js-node-rowbinary: Official ClickHouse skill from clickhouse/agent-skills. ### Install Install the full package: ```bash npx skills add clickhouse/agent-skills -y ``` Install a specific skill: ```bash npx skills add clickhouse/agent-skills@clickhouse-best-practices -y ``` Use the package when you want your agent to choose the relevant skill from this official repository. Source: https://github.com/clickhouse/agent-skills#readme