ClickHouse Skill Pack
24 skills for building, operating, and scaling ClickHouse-powered analytics — real
@clickhouse/clientcode, real SQL, real MergeTree engines.
Every skill uses the official ClickHouse Node.js client (@clickhouse/client with createClient), actual ClickHouse SQL syntax (MergeTree, ReplacingMergeTree, AggregatingMergeTree), real system tables (system.parts, system.query_log, system.merges), and production patterns (parameterized queries, streaming inserts, materialized views).
Links: tonsofskills.com | ClickHouse Docs | @clickhouse/client
Installation
/plugin install clickhouse-pack@claude-code-plugins-plusSkills (24)
Standard Skills (S01-S12)
| # | Skill | What It Does |
|---|---|---|
| S01 | clickhouse-install-auth |
Install @clickhouse/client, configure Cloud/self-hosted connection, verify with ping + version query |
| S02 | clickhouse-hello-world |
Create MergeTree table, insert with JSONEachRow, query with GROUP BY, explore system.parts |
| S03 | clickhouse-local-dev-loop |
Docker Compose setup, init SQL scripts, seed data, vitest integration tests, CLI shortcuts |
| S04 | clickhouse-sdk-patterns |
Typed query helper, streaming inserts with backpressure, batch retry, streaming SELECT, error handling |
| S05 | clickhouse-core-workflow-a |
Schema design — engine selection, ORDER BY key design, partitioning, codecs, compression |
| S06 | clickhouse-core-workflow-b |
Bulk inserts, analytical queries, parameterized queries, materialized views, window functions |
| S07 | clickhouse-common-errors |
Top 10 error codes (252, 241, 62, 60, 159) with diagnostic SQL and real fixes |
| S08 | clickhouse-debug-bundle |
Diagnostic queries against system tables, automated bash collector, Node.js debug bundle |
| S09 | clickhouse-rate-limits |
Server concurrency limits, per-user quotas, connection pooling, insert buffer pattern |
| S10 | clickhouse-security-basics |
SQL-based user creation, roles, row-level security, TLS config, audit logging |
| S11 | clickhouse-prod-checklist |
Go-live checklist: schema, backup (BACKUP TO S3), monitoring, security, health checks |
| S12 | clickhouse-upgrade-migration |
Server + client version upgrades, breaking change detection, validation scripts, rollback |
Pro Skills (P13-P18)
| # | Skill | What It Does |
|---|---|---|
| P13 | clickhouse-ci-integration |
GitHub Actions with ClickHouse service container, schema validation tests, version matrix |
| P14 | clickhouse-deploy-integration |
Deploy to Vercel/Fly.io/Cloud Run with ClickHouse Cloud connections, secrets, health checks |
| P15 | clickhouse-webhooks-events |
Data ingestion — webhook batching, Kafka table engine, ClickPipes, HTTP bulk insert, S3 import |
| P16 | clickhouse-performance-tuning |
EXPLAIN PLAN, ORDER BY optimization, data skipping indexes, projections, server settings |
| P17 | clickhouse-cost-tuning |
Storage analysis, compression codecs, TTL tiers, compute scaling, query cost tracking |
| P18 | clickhouse-reference-architecture |
3-layer schema (raw → hourly → daily), multi-tenant patterns, data flow diagrams |
Flagship Skills (F19-F24)
| # | Skill | What It Does |
|---|---|---|
| F19 | clickhouse-multi-env-setup |
Dev/staging/prod config, secrets management (Vault/AWS/GCP), environment guards, CI/CD integration |
| F20 | clickhouse-observability |
Prometheus metrics, Grafana dashboards, system table monitoring, alert rules, structured logging |
| F21 | clickhouse-incident-runbook |
P1-P4 triage procedures, KILL QUERY, disk full recovery, merge backlog, communication templates |
| F22 | clickhouse-data-handling |
TTL expiration, GDPR deletion (lightweight DELETE + mutations), data masking, audit trails |
| F23 | clickhouse-enterprise-rbac |
SQL-based RBAC — users, roles, row policies, column grants, quotas, settings profiles |
| F24 | clickhouse-migration-deep-dive |
ALTER TABLE operations, ORDER BY changes, engine migration, versioned migration runner |
What Makes This Different
These are not generic SaaS API wrappers. Every skill is built from actual ClickHouse documentation and real-world patterns:
- Real imports:
import { createClient } from '@clickhouse/client'(the official client) - Real SQL:
ENGINE = MergeTree() ORDER BY (tenant_id, event_type, created_at) PARTITION BY toYYYYMM(created_at) - Real system tables:
system.parts,system.query_log,system.merges,system.mutations - Real error codes: 252 (TOO_MANY_PARTS), 241 (MEMORY_LIMIT_EXCEEDED), 62 (SYNTAX_ERROR)
- Real patterns: Streaming inserts with backpressure, materialized views with AggregateFunction states, parameterized queries with
{name:Type}syntax
License
MIT