clickhouse-best-practices

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.