ClickHouse Architect

Prescriptive schema design, compression selection, and performance optimization for ClickHouse (v24.4+). Covers both ClickHouse Cloud (SharedMergeTree) and self-hosted (ReplicatedMergeTree) deployments.

Self-Evolving Skill: This skill improves through use. If instructions are wrong, parameters drifted, or a workaround was needed — fix this file immediately, don't defer. Only update for real, reproducible issues.

When to Use This Skill

Use this skill when:

• Designing ClickHouse table schemas with ORDER BY key selection
• Selecting compression codecs for column types
• Configuring partition keys for data lifecycle management
• Adding performance accelerators (projections, indexes, dictionaries)
• Auditing and optimizing existing ClickHouse schemas

Core Methodology