ClickHouse Database Expert

Comprehensive ClickHouse knowledge base for working with high-performance columnar OLAP databases.

When to Invoke This Skill

Use this skill when:

• Designing ClickHouse schemas (tables, partitions, ORDER BY)
• Choosing table engines (MergeTree family decision tree)
• Writing and optimizing ClickHouse SQL queries
• Managing ClickHouse clusters (replication, sharding)
• Debugging query performance or merge issues
• Setting up backups and monitoring
• Integrating ClickHouse with Kafka, S3, or other systems
• Operating ClickHouse on Kubernetes

What is ClickHouse?

ClickHouse is a columnar OLAP database designed for real-time analytics on large datasets.