ClickHouse Architect Skill for MergeTree Sort Keys
Use query shapes to choose a sort key and verify the design with an owned local ClickHouse fixture.
中文Install in Claude Code
Use a local ClickHouse instance and synthetic events with fictional sites and timestamps.
- Get the complete `plugins/quality-tools/skills/clickhouse-architect` directory from the pinned GitHub commit.
- Copy it into the target project's `.claude/skills/`. Check `.claude/skills/clickhouse-architect/SKILL.md`, start Claude Code at the project root, and call `/clickhouse-architect`.
Example task
Insert events for A and B into synthetic_events. Sort by (site_id, occurred_at), query site A for a UTC day, and inspect the query plan.What to check
Only A's rows for that day contribute. The design notes connect the sort key to its workload and observed checks.
Original SKILL.md on GitHub · Updated
Frequently asked question
Must the sort key be a unique primary key?
The MergeTree sort key primarily controls data organization and query access. Document uniqueness requirements separately.