Summary
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.
Install to Claude Code
npx -y skills add terrylica/cc-skills --skill clickhouse-architect --agent claude-codeInstalls into .claude/skills of the current project.
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →
Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Files
SKILL.md
Select a file.
Featured
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
