clickhouse-best-practices

Partner, reviewed

28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact

Plugin · by clickhouse · runs in Claude Code, Cowork, claude.ai · 11 skills · listed 2026-04-17

Claude Code

claude plugin install clickhouse-best-practices

Source

Skills (11)

Skill chdb-datastore

Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas.

Any agent
```
npx skills add clickhouse/agent-skills --skill chdb-datastore
```
Skill chdb-sql

Use 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 Cloud, Iceberg, Delta…

Any agent
```
npx skills add clickhouse/agent-skills --skill chdb-sql
```
Skill clickhouse-architecture-advisor

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

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-architecture-advisor
```
Skill clickhouse-best-practices

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations.

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-best-practices
```
Skill clickhouse-js-node-coding

Write idiomatic application code with the ClickHouse Node.js client (`@clickhouse/client`). Use this skill whenever a user is *building* against the Node.js client — configuring the client, pinging…

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-js-node-coding
```
Skill clickhouse-js-node-rowbinary

Generate TypeScript/JavaScript code that reads/decodes AND writes/encodes ClickHouse RowBinary streams for the ClickHouse HTTP server.

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-js-node-rowbinary
```
Skill clickhouse-js-node-troubleshooting

Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client). Use this skill whenever a user reports errors, unexpected behavior, or configuration questions…

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-js-node-troubleshooting
```
Skill clickhouse-managed-postgres-rca

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. Provides an evidence-based RCA workflow that scrapes the Prometheus endpoint for system signal, pulls…

Any agent
```
npx skills add clickhouse/agent-skills --skill clickhouse-managed-postgres-rca
```
Skill clickstack-otel-collector

Use when a user wants to wire an OpenTelemetry collector into a Managed ClickStack service on ClickHouse Cloud, either by deploying a new local collector (Docker run or Docker Compose) or by…

Any agent
```
npx skills add clickhouse/agent-skills --skill clickstack-otel-collector
```
Skill infra-clickhouse

Sets up and manages ClickHouse using the clickhousectl CLI — installs and runs a local ClickHouse server for development, and creates managed ClickHouse Cloud services for production…

Any agent
```
npx skills add clickhouse/agent-skills --skill infra-clickhouse
```
Skill infra-postgres

Sets up and manages Postgres using the clickhousectl CLI — runs a local Docker-backed Postgres for development, and creates and operates managed ClickHouse Cloud Postgres services (connections, TLS…

Any agent
```
npx skills add clickhouse/agent-skills --skill infra-postgres
```

From Anthropic's public plugin directory, read on 2026-10-16. Find a skill by task.