Database

ClickHouse agent skills for Claude Code, Codex and other agents.

Open-source column-oriented database for real-time analytics on large datasets.
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)

Official ClickHouse skills
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
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/skills278—~2.8kAutomated safety check: PassApache-2.0yesterday
2

Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU).

PostHog/posthog-foss721—~5.1kAutomated safety check: PassMITtoday
3

How to add a new ingestion warning type to the event ingestion pipeline.

PostHog/posthog-foss721—~3.7kAutomated safety check: PassMITtoday
4

Analyze the experiment precompute result-consistency canary across prod-US and prod-EU, deep-dive any issues, and produce an actionable report.

PostHog/posthog-foss721—~3.5kAutomated safety check: PassMITtoday
5

ClickHouse migration patterns and rules. An agent skill from PostHog/posthog-foss.

PostHog/posthog-foss721—~3kAutomated safety check: PassMITtoday
6

Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog-foss.

PostHog/posthog-foss721—~2.4kAutomated safety check: NotesMITtoday
7

Runs read-only production database analysis through PostHog's internal Metabase instances.

PostHog/posthog-foss721—~2.8kAutomated safety check: PassMITtoday
8
8.Querying TophogOfficial

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/posthog-foss721—~2.3kAutomated safety check: PassMITtoday
9

Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password.

PostHog/posthog-foss721—~585Automated safety check: PassMITtoday
10

Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production.

PostHog/posthog-foss721—~9.1kAutomated safety check: PassMITtoday
11

Workflow for optimizing ClickHouse and HogQL queries. An agent skill from PostHog/posthog-foss.

PostHog/posthog-foss721—~5.7kAutomated safety check: PassMITtoday
12

Profiles slow PostHog API endpoints when the main cost is in Postgres or Python.

PostHog/posthog-foss721—~1kAutomated safety check: PassMITtoday

Community

Community ClickHouse skills
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
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/vemetric3942 repos~1.4kAutomated safety check: PassApache-2.0today
14

Build or review Langfuse backend code. An agent skill from langfuse/langfuse.

langfuse/langfuse35k—~1.9kAutomated safety check: PassUnknowntoday
15

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

hellangleZ/burn-in-cceverywhere-ralph11214 repos~2.5kAutomated safety check: PassNo licence8 mo ago
16

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/vemetric3941 repo~1.2kAutomated safety check: PassApache-2.0today
17

Analyzes a single GitHub issue at a time. An agent skill from ClickHouse/clickhouse-java.

ClickHouse/clickhouse-java1.6k—~904Automated safety check: PassApache-2.0yesterday
18

Build, refactor, or review production-grade admin interfaces with Vue 3 + JavaScript + Ant Design Vue 4.x.

lazzyfu/goInsight730—~2kAutomated safety check: PassMIT6 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/evlog1.9k—~2.9kAutomated safety check: PassMITyesterday
20

Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.

ClickHouse/clickhouse-java1.6k—~3.1kAutomated safety check: PassApache-2.0yesterday
21

MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.

vemetric/vemetric3942 repos~791Automated safety check: PassApache-2.0today
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/Observal4.1k—~774Automated safety check: PassApache-2.0yesterday
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/agent-skills544—~1.3kAutomated safety check: PassApache-2.08 days ago
24

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

vemetric/vemetric3942 repos~2.6kAutomated safety check: PassApache-2.0today
25

Standard branch, commit, and pull-request workflow for this repo.

wgzhao/Addax1.4k—~216Automated safety check: PassApache-2.0today
26

Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries.

FrankChen021/datastoria327—~731Automated safety check: PassUnknown2 mo ago
27

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

langfuse/langfuse35k—~3.5kAutomated safety check: PassApache-2.0today
28

Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection.

sidequery/sidemantic129—~5.5kAutomated safety check: PassAGPL-3.0today
29

Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output.

ClickHouse/clickhouse-java1.6k—~457Automated safety check: PassApache-2.0yesterday
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/stock_datasource188—~2.5kAutomated safety check: PassMIT29 days ago
31
31.Surf

Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls.

BlockRunAI/ClawRouter6.6k—~4kAutomated safety check: PassMIT2 days ago
32

Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo.

litefuse/litefuse1001 repo~5.8kAutomated safety check: PassUnknown14 days ago
33

Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator.

ar-io/ar-io-node127—~8.2kAutomated safety check: NotesAGPL-3.0today
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/opik22k—~2.4kAutomated safety check: PassApache-2.0today
35

Cut a stable hypequery release via Changesets, or explain/check the canary flow.

hypequery/hypequery103—~623Automated safety check: PassUnknowntoday
36

Rules for charts and visualization. An agent skill from FrankChen021/datastoria.

FrankChen021/datastoria327—~1.2kAutomated safety check: PassUnknown2 mo ago
37

Build, validate, and manage semantic models using Sidemantic.

sidequery/sidemantic129—~4.2kAutomated safety check: PassApache-2.0today
38

Generate C++ header files following Google Style Guide. An agent skill from ClickHouse/pg_stat_ch.

ClickHouse/pg_stat_ch124—~772Automated safety check: PassApache-2.0yesterday
39

Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests.

ClickHouse/clickhouse-java1.6k—~290Automated safety check: PassApache-2.0yesterday
40

Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx.

tempoxyz/tidx107—~3.1kAutomated safety check: PassMITyesterday
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/benchmarks126—~3kAutomated safety check: NotesMITyesterday
42

Check C++ naming conventions against Google Style Guide. An agent skill from ClickHouse/pg_stat_ch.

ClickHouse/pg_stat_ch124—~701Automated safety check: PassApache-2.0yesterday
43

GFS MCP Server for AI agent integration. An agent skill from Guepard-Corp/gfs.

Guepard-Corp/gfs158—~4kAutomated safety check: PassMITyesterday
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/datastoria327—~610Automated safety check: PassUnknown2 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/stock_datasource188—~1.2kAutomated safety check: PassMIT29 days ago
46

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.

ClickHouse/agent-skills544—~1.2kAutomated safety check: PassApache-2.08 days ago
47

Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.

sidequery/sidemantic129—~982Automated safety check: PassAGPL-3.0today
48

Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance.

hypequery/hypequery103—~618Automated safety check: PassUnknowntoday

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.