Clickhouse Architect

If you're designing ClickHouse schemas, this skill walks you through the critical decisions: ORDER BY key selection (3-5 columns, lowest cardinality first), compression codec matching (DoubleDelta for timestamps, Gorilla for floats, T64 for counters), and partition strategies for data lifecycle management. It's opinionated about what matters (ORDER BY is everything) and what doesn't (partitioning is for TTLs, not query speed). The anti-patterns checklist is especially useful since it notes what's actually been fixed in recent versions, like the 1700x improvement in mutations for v24.4+. Covers both ClickHouse Cloud and self-hosted deployments with concrete SQL examples throughout.

skills.sh installs: 157
GitHub stars: 2
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add terrylica/cc-skills --skill clickhouse-architect --agent claude-code

Installs into .claude/skills of the current project.

Files

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.