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.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Files
SKILL.md
Select a file.
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
