clickhouse-best-practices
🎯Skillfrom clickhouse/agent-skills
|Official ClickHouse best practices skill with 28 rules across schema design, query optimization, and data ingestion, prioritized by impact
Overview
ClickHouse Best Practices is the official agent skill from ClickHouse, providing 28 rules covering schema design, query optimization, and data ingestion for ClickHouse databases. The rules are prioritized by impact level (Critical, High, Medium) and work with both open-source ClickHouse and managed ClickHouse Cloud.
Key Features
- 28 Prioritized Rules - Covers primary key selection, data type selection, JOIN optimization, insert batching, mutation avoidance, partitioning, skipping indices, materialized views, and more
- Impact-Based Organization - Rules categorized as CRITICAL (primary keys, data types, JOINs, inserts, mutations), HIGH (partitioning, indices, materialized views, async inserts), or MEDIUM (JSON usage)
- Automatic Activation - Skill activates automatically when creating tables, writing queries, designing data pipelines, or optimizing performance in ClickHouse
- Agent-Agnostic - Works across Claude Code, Cursor, Copilot, and other AI coding assistants that support the agent skills format
- ClickHouse Cloud Support - Compatible with both self-hosted ClickHouse and ClickHouse Cloud with $300 in free credits available
Who is this for?
This skill is for data engineers and backend developers working with ClickHouse who want AI assistance following official best practices for schema design, query optimization, and data ingestion. It is particularly valuable for teams setting up new ClickHouse deployments or optimizing existing ones who need guidance on primary key ordering, data types, JOINs, and insert strategies.
Same repository
clickhouse/agent-skills(9 items)
Installation
npx vibeindex add clickhouse/agent-skills --skill clickhouse-best-practicesnpx skills add clickhouse/agent-skills --skill clickhouse-best-practices~/.claude/skills/clickhouse-best-practices/SKILL.mdSKILL.md
More from this repository8
Provides 5 decision frameworks for workload-aware ClickHouse architecture decisions, covering ingestion strategy, join patterns, late-arriving data, time-series partitioning, and real-time pre-aggregation for production deployments.
Official ClickHouse agent skill providing 28 best-practice rules for schema design, query optimization, and data ingestion, supporting local development with clickhousectl CLI including primary key selection, JOIN optimization, and partitioning strategies.
Official ClickHouse agent skill providing AI coding assistants with expertise in chdb SQL queries for in-process analytics with Python, covering schema design, query optimization, and data ingestion best practices.
Official ClickHouse agent skill providing AI coding assistants with chdb datastore capabilities for persistent in-process data storage, covering data management patterns with ClickHouse's embedded analytics engine.
An official ClickHouse agent skill that teaches AI agents best practices for ClickHouse Cloud deployment, covering schema design, query optimization, and data ingestion patterns across 28 prioritized rules.
Official ClickHouse agent skills providing 28 best-practice rules for schema design, query optimization, and data ingestion, plus chdb (in-process ClickHouse for Python) expertise. Covers primary key selection, JOIN optimization, partitioning strategy, materialized views, and troubleshooting patterns.
The official ClickHouse agent skills repository, providing AI coding agents with domain-specific expertise in ClickHouse and chdb (in-process ClickHouse for Python). Includes 28 prioritized rules covering schema design, query optimization, JOIN strategies, data ingestion patterns, and in-process analytics.
Official ClickHouse agent skills providing 28 best-practice rules for schema design, query optimization, and data ingestion, covering both open-source ClickHouse and ClickHouse Cloud. Also includes skills for chdb, the in-process ClickHouse engine for Python.