Database
ClickHouse agent skills for Claude Code, Codex and other agents.
- skills
- 114
- official
- 12
- Type
- Database
- Website
- clickhouse.com
- Official GitHub
- ClickHouse
- Reviews
- See ClickHouse on Enlisted
ClickHouse skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
Official (12 skills)
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Generate a copy-paste Grafana data source provisioning file (YAML or Terraform) for any plugin from its standardized settings schema on the plugins CDN. | grafana/ | 278 | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 2 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 721 | — | ~5.1k | Automated safety check: Pass | MIT | today |
| 3 | How to add a new ingestion warning type to the event ingestion pipeline. | PostHog/ | 721 | — | ~3.7k | Automated safety check: Pass | MIT | today |
| 4 | Analyze the experiment precompute result-consistency canary across prod-US and prod-EU, deep-dive any issues, and produce an actionable report. | PostHog/ | 721 | — | ~3.5k | Automated safety check: Pass | MIT | today |
| 5 | ClickHouse migration patterns and rules. An agent skill from PostHog/posthog-foss. | PostHog/ | 721 | — | ~3k | Automated safety check: Pass | MIT | today |
| 6 | Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog-foss. | PostHog/ | 721 | — | ~2.4k | Automated safety check: Notes | MIT | today |
| 7 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 721 | — | ~2.8k | Automated safety check: Pass | MIT | today |
| 8 | Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (teamid, distinctid, sessionid, partition) during incident triage. | PostHog/ | 721 | — | ~2.3k | Automated safety check: Pass | MIT | today |
| 9 | Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password. | PostHog/ | 721 | — | ~585 | Automated safety check: Pass | MIT | today |
| 10 | Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production. | PostHog/ | 721 | — | ~9.1k | Automated safety check: Pass | MIT | today |
| 11 | Workflow for optimizing ClickHouse and HogQL queries. An agent skill from PostHog/posthog-foss. | PostHog/ | 721 | — | ~5.7k | Automated safety check: Pass | MIT | today |
| 12 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 721 | — | ~1k | Automated safety check: Pass | MIT | today |
Community
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 13 | A skill your agent uses when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. | vemetric/ | 394 | 2 repos | ~1.4k | Automated safety check: Pass | Apache-2.0 | today |
| 14 | Build or review Langfuse backend code. An agent skill from langfuse/langfuse. | langfuse/ | 35k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 15 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | hellangleZ/ | 112 | 14 repos | ~2.5k | Automated safety check: Pass | No licence | 8 mo ago |
| 16 | 16.Chdb SQL A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse… | vemetric/ | 394 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | today |
| 17 | Analyzes a single GitHub issue at a time. An agent skill from ClickHouse/clickhouse-java. | ClickHouse/ | 1.6k | — | ~904 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 18 | Build, refactor, or review production-grade admin interfaces with Vue 3 + JavaScript + Ant Design Vue 4.x. | lazzyfu/ | 730 | — | ~2k | Automated safety check: Pass | MIT | 6 mo ago |
| 19 | Walks through adding a new built-in evlog drain adapter for an observability platform: source, build config, exports, tests, docs and PR scope. | evloghq/ | 1.9k | — | ~2.9k | Automated safety check: Pass | MIT | yesterday |
| 20 | Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting. | ClickHouse/ | 1.6k | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 21 | MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. | vemetric/ | 394 | 2 repos | ~791 | Automated safety check: Pass | Apache-2.0 | today |
| 22 | Administers Observal users, settings, diagnostics, review queues, security events, audit logs, SAML, SCIM, the local Observal server, its upgrades and rollback, and its own PostgreSQL and ClickHouse… | Observal/ | 4.1k | — | ~774 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 23 | Generates TypeScript or JavaScript readers and writers for ClickHouse's RowBinary formats over HTTP in Node.js, after checking that RowBinary suits the data. | ClickHouse/ | 544 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 8 days ago |
| 24 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | vemetric/ | 394 | 2 repos | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 25 | 25.Git PR Flow Standard branch, commit, and pull-request workflow for this repo. | wgzhao/ | 1.4k | — | ~216 | Automated safety check: Pass | Apache-2.0 | today |
| 26 | Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. | FrankChen021/ | 327 | — | ~731 | Automated safety check: Pass | Unknown | 2 mo ago |
| 27 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | langfuse/ | 35k | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | today |
| 28 | Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection. | sidequery/ | 129 | — | ~5.5k | Automated safety check: Pass | AGPL-3.0 | today |
| 29 | Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output. | ClickHouse/ | 1.6k | — | ~457 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 30 | Turns a Tushare API doc URL into a full data plugin for the stock_datasource repo: extractor, ClickHouse schema, query service, config and curl examples. | Yourdaylight/ | 188 | — | ~2.5k | Automated safety check: Pass | MIT | 29 days ago |
| 31 | 31.Surf Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls. | BlockRunAI/ | 6.6k | — | ~4k | Automated safety check: Pass | MIT | 2 days ago |
| 32 | Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo. | litefuse/ | 100 | 1 repo | ~5.8k | Automated safety check: Pass | Unknown | 14 days ago |
| 33 | Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator. | ar-io/ | 127 | — | ~8.2k | Automated safety check: Notes | AGPL-3.0 | today |
| 34 | Java conventions for the Opik backend: layered resource, service and DAO classes, naming rules, Lombok and Guice usage, and notes on MySQL, ClickHouse, migrations and testing. | comet-ml/ | 22k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | today |
| 35 | 35.Release Cut a stable hypequery release via Changesets, or explain/check the canary flow. | hypequery/ | 103 | — | ~623 | Automated safety check: Pass | Unknown | today |
| 36 | Rules for charts and visualization. An agent skill from FrankChen021/datastoria. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 37 | 37.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | today |
| 38 | Generate C++ header files following Google Style Guide. An agent skill from ClickHouse/pg_stat_ch. | ClickHouse/ | 124 | — | ~772 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 39 | 39.Code Review Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests. | ClickHouse/ | 1.6k | — | ~290 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 40 | Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx. | tempoxyz/ | 107 | — | ~3.1k | Automated safety check: Pass | MIT | yesterday |
| 41 | Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials. | computesdk/ | 126 | — | ~3k | Automated safety check: Notes | MIT | yesterday |
| 42 | Check C++ naming conventions against Google Style Guide. An agent skill from ClickHouse/pg_stat_ch. | ClickHouse/ | 124 | — | ~701 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 43 | 43.Use Gfs MCP GFS MCP Server for AI agent integration. An agent skill from Guepard-Corp/gfs. | Guepard-Corp/ | 158 | — | ~4k | Automated safety check: Pass | MIT | yesterday |
| 44 | Diagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-code root cause analysis. | FrankChen021/ | 327 | — | ~610 | Automated safety check: Pass | Unknown | 2 mo ago |
| 45 | Sets up and troubleshoots MCP API key authentication for a stock data service, covering key creation, client configuration and per-tool usage statistics. | Yourdaylight/ | 188 | — | ~1.2k | Automated safety check: Pass | MIT | 29 days ago |
| 46 | MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. | ClickHouse/ | 544 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 8 days ago |
| 47 | Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer. | sidequery/ | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | today |
| 48 | 48.Manual Test Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance. | hypequery/ | 103 | — | ~618 | Automated safety check: Pass | Unknown | today |
Questions, answered from the data.
What is the best ClickHouse skill?
Datasources Provisioning (official) from grafana/skills ranks first of the 114 ClickHouse skills listed here, with the highest score: its repository has 278 GitHub stars, its SKILL.md loads about 2.8k tokens and it passes the automated safety check with no findings. Next come Generating Clickhouse Query Performance Reports and Adding Ingestion Warnings.
Is there an official ClickHouse skill?
12 of the 114 ClickHouse skills are official, published by the vendor's own GitHub organization: Datasources Provisioning, Generating Clickhouse Query Performance Reports, Adding Ingestion Warnings, Analyzing Experiment Precompute Canary, Clickhouse Migrations and 7 more.
How are these skills ranked?
By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.