clickhouse-best-practices Plugin
Plugin Claude Code Database Databases & StorageData Engineering & AnalyticsThe explanation below is AI-generated. Please verify it against the sources.
clickhouse-best-practices is an Agent Skill within the ClickHouse Agent Skills repository that packages 28 best-practice rules for ClickHouse schema design, query optimization, and data ingestion, prioritized by impact (CRITICAL, HIGH, or MEDIUM) as shown in the README's category table. It is installed via npx skills add clickhouse/agent-skills or the clickhousectl skills command and is intended for use with AI coding agents such as Claude Code, Cursor, and GitHub Copilot. According to the README, the skill activates automatically when an agent works with ClickHouse, such as creating tables, writing queries, or designing data pipelines. The rules apply to both open-source ClickHouse and managed ClickHouse Cloud. Full details are documented in SKILL.md (overview) and AGENTS.md (compiled guide) inside the skill's directory.
Overview
According to the README, this is not a standalone SaaS product but an 'Agent Skill' — a packaged set of instructions that extends AI coding agents with ClickHouse domain expertise. It is designed to work with both open-source ClickHouse and managed ClickHouse Cloud.
What you can do with clickhouse-best-practices
- Install the skill via npx skills add clickhouse/agent-skills or clickhousectl skills
- Get automatic guidance when creating tables and choosing ORDER BY / PRIMARY KEY columns
- Apply rules for data type selection, JOIN optimization, and insert batching
- Reference guidance on partitioning strategy, skipping indices, materialized views, async inserts, and mutation avoidance
- Read SKILL.md for an overview or AGENTS.md for the complete compiled guide in skills/clickhouse-best-practices/
Sources
Original description (English)
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact