🎯

clickhouse-best-practices

🎯Skill

from clickhouse/agent-skills

What it does

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(6 items)

clickhouse-best-practices

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add clickhouse/agent-skills --skill clickhouse-best-practices

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add clickhouse/agent-skills --skill clickhouse-best-practices

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/clickhouse-best-practices/SKILL.md

SKILL.md

2,615Installs

AddedFeb 4, 2026

View on GitHub Back to Skills

More from this repository5

🎯

clickhouse-architecture-advisor🎯Skill

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.

🎯

clickhousectl-local-dev🎯Skill

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.

🎯

clickhousectl-cloud-deploy🎯Skill

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.

🎯

chdb-sql🎯Skill

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.

🎯

chdb-datastore🎯Skill

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.