ClickHouse Analytics Patterns
ClickHouse table design, ordering keys, materialized views, and query optimization
Test report
- Verdict
- Tested · Works
- Score
- Tested
- Jul 18, 2026
- Environment
- Claude Code 2.x (agent harness)
- Upstream re-checked
- Jul 20, 2026 · 4904e17
⚠ This skill is no longer available upstream. Our re-check on Aug 10, 2026 couldn't find it any more (repo unreachable/deleted). The test below is what we measured on Jul 18, 2026 and we're leaving it up as a record — but there is nothing left to install, so we've removed the command.
Ran the skill's patterns live on a real 20M-row table in ClickHouse 26.7: its ORDER BY (date, market_id) + monthly partitioning cut a filtered query from a full 20M-row scan (2443 granules) to 286K rows (35 granules), and its AggregatingMergeTree materialized view answered an hourly rollup by reading 360K pre-aggregated rows instead of re-scanning all 20M — identical results, ~55-70x fewer rows touched.
Scored on four weighted criteria — install, triggering, output vs. baseline, docs. How scoring works
- Installs cleanly 5/5
- Triggers reliably 5/5
- Output vs. baseline 9/10
- Docs & honesty 5/5
What ClickHouse Analytics Patterns does
ClickHouse-specific patterns for high-performance OLAP: MergeTree/ReplacingMergeTree/AggregatingMergeTree table design, time partitioning, ordering-key selection, materialized-view pre-aggregation, bulk inserts, and analytics queries (funnels, cohorts, retention). Triggers when designing or optimizing ClickHouse schemas and queries. Not applicable to Postgres/MySQL.
How to install ClickHouse Analytics Patterns
Nothing to install: the source repository no longer has this skill. If the author brings it back, our daily re-check will pick it up and the command will reappear here.
Commands — how to trigger ClickHouse Analytics Patterns
-
/clickhouse-ioClickHouse table design, ordering keys, materialized views, and query optimization
It also activates on plain-language prompts like these:
-
Why is my ClickHouse aggregation query scanning way more rows than needed? -
Design a ClickHouse table schema for hourly analytics on trade data. -
Help me optimize this ClickHouse query with better ordering keys.
Frequently asked questions
- Is the ClickHouse Analytics Patterns skill free?
- Yes. The skill itself is free from arabicapp/everything-claude-code. SkillProof publishes the install command and an independent test verdict at no cost.
- Does ClickHouse Analytics Patterns work with Claude Code?
- We tested it with Claude Code 2.x (agent harness) on Jul 18, 2026. Verdict: Tested · Works. Ran the skill's patterns live on a real 20M-row table in ClickHouse 26.7: its ORDER BY (date, market_id) + monthly partitioning cut a filtered query from a full 20M-row scan (2443 granules) to 286K rows (35 granules), and its AggregatingMergeTree materialized view answered an hourly rollup by reading 360K pre-aggregated rows instead of re-scanning all 20M — identical results, ~55-70x fewer rows touched.
- What is the ClickHouse Analytics Patterns SkillProof Score?
- 9.6/10 — installs cleanly 5/5, triggers reliably 5/5, output vs. baseline 9/10, docs & honesty 5/5.
- How do I install ClickHouse Analytics Patterns?
- Copy the install command from this page, run it in your terminal, and restart Claude Code. Skills live in ~/.claude/skills/ (global) or .claude/skills/ inside a project.
- Can I use ClickHouse Analytics Patterns with Cursor, Copilot, Gemini CLI, Codex or other AI tools?
- The SKILL.md format is native to Claude (Claude Code, Desktop, claude.ai). The instructions inside adapt to other assistants: Cursor rules, GitHub Copilot instructions, Windsurf rules, Custom GPTs, AGENTS.md for OpenAI Codex, and GEMINI.md for Google Gemini CLI — our conversion guides cover each, and the free converter on the tools page does the wrapping for you.