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.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
