clickhouseOfficial·11 Agent Skills Included

agent-skills

ClickHouse schema design, query optimization, and in-process analytics

Optimizes ClickHouse schemas, queries, and ingestion pipelines with 31 prioritized rules and workload-aware architecture decision frameworks. Runs serverless SQL and pandas-style analytics on files, databases, and cloud storage through chdb, eliminating slow pandas code and manual server setup. Diagnoses managed Postgres performance issues and troubleshoots the ClickHouse Node.js client with evidence-based workflows.

525|36

↗

npx skills add clickhouse/agent-skills --all -g -y

All Skills in This Repository (11)

Pure Emerald Level Indicators

📦 In Repo

clickhouse

infra-postgres

Sets up and manages local Docker-backed and ClickHouse Cloud Postgres services via clickhousectl.

infra-clickhouse

Sets up local ClickHouse development servers and deploys managed ClickHouse Cloud services via clickhousectl.

chdb-sql

Embed ClickHouse SQL in Python to query local files, URLs, S3, and remote databases.

clickhousectl-local-dev

Provides tools and workflows for designing, validating, and preparing cloud-agnostic services for deployment.

clickhouse-architecture-advisor

Guide ClickHouse architecture decisions with provenance-labeled recommendation frameworks.

chdb-datastore

Run pandas-compatible tabular workflows on a ClickHouse-backed DataStore.

clickhouse-js-node-coding

Configure and operate the @clickhouse/client for Node.js queries and inserts.

clickhouse-js-node-troubleshooting

Diagnose ClickHouse Node.js client issues like ECONNRESET, keep-alive, and TLS errors.

clickhousectl-cloud-deploy

Automate ClickHouse Cloud service deployment and local schema migration with clickhousectl.

clickhouse-managed-postgres-rca

Diagnose ClickHouse-managed Postgres performance issues using Prometheus metrics and Slow Query Patterns API evidence.

clickhouse-best-practices

Apply ClickHouse best practices to schema design, query optimization, and data ingestion.

Official

Advanced

Frequently Asked Questions

FAQPage Schema

How to install ClickHouse agent-skills?▼

Run `npx skills add ClickHouse/agent-skills --all -g -y` in your terminal to install all skills globally.

How to optimize slow ClickHouse queries?▼

The clickhouse-best-practices skill checks your schema and queries against 31 prioritized rules covering primary keys, JOINs, partitioning, and insert batching, then cites the exact rule behind each fix.

Can I speed up pandas without rewriting my code?▼

Yes. The chdb-datastore skill is a drop-in pandas replacement backed by ClickHouse — change one import line and your existing code runs 10-100x faster, with joins across MySQL, S3, Parquet, and more.

Does it work with Claude Code and Cursor?▼

Yes. All skills follow the open agentskills.io standard and work with Claude Code, Cursor, Copilot, Windsurf, Codex, and other compatible coding agents.

Can it diagnose slow managed Postgres instances?▼

Yes. The managed-postgres-rca skill scrapes Prometheus metrics and slow query patterns from ClickHouse Cloud, triages the signal against known heuristics, and produces a recommend-only fix report.