# clickhouse-best-practices

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

Plugin by ClickHouse. Category: Data and backend.

## Install

Global (for every project on this machine):

```sh
npx plugins add clickhouse/agent-skills
```

Works with: Claude Code, Codex CLI, Cursor, Copilot CLI.

Project (for this project only):

```sh
npx plugins add clickhouse/agent-skills -s project
```

Works with: Claude Code, Codex CLI, Cursor, Copilot CLI.

## What's inside

- Skills: chdb-datastore, chdb-sql, clickhouse-architecture-advisor, clickhouse-best-practices, clickhouse-js-node-coding, clickhouse-js-node-rowbinary, clickhouse-js-node-troubleshooting, clickhouse-managed-postgres-rca, clickstack-otel-collector, infra-clickhouse, infra-postgres

## Source

[Open the source](https://github.com/clickhouse/agent-skills). Checked 2026-10-10. This summary may contain AI-generated text, so it can be wrong. Check the source before you rely on it.

- Previous: [infra-postgres](https://syn4pse.dev/terminal/clickhousectl-postgres.md)
- Next: [studio-cli](https://syn4pse.dev/terminal/automattic-studio-cli.md)
- [Terminal](https://syn4pse.dev/terminal.md)
- [Suggest a change](mailto:terminal@syn4pse.dev?subject=Terminal%20suggestion)
