Individual skill
clickhouse-pro
ClickHouse columnar analytics — schema design, MergeTree tuning, and fast queries — use for OLAP and high-volume event data.
skills/clickhouse-pro/SKILL.md
Source commit faf37c0859ebf627bfcb5225e8057d088691e0ae
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- Yes
- Observed behavior
- Not checked yet
- Last checked
- Nov 8, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 54
- Repository last updated
- Oct 10, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai-agents Repository topic
- ai-agents-automation Repository topic
- ai-skills Repository topic
- awesome Repository topic
- awesome-list Repository topic
- chatgpt Repository topic
- claude-skills Repository topic
- meta-ai Repository topic
- muse-ai Repository topic
- data Derived category
- design Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 4,462 bytes
Read excerpt
## Overview
ClickHouse is a columnar OLAP database built for sub-second analytics over
billions of rows. Its speed comes from a storage layout (MergeTree family) and
query engine designed for scans and aggregations — which means schema and query
patterns differ sharply from row-oriented databases. This skill covers designing
for ClickHouse's strengths.
## When to use
- Designing tables (`MergeTree`, `ReplacingMergeTree`, `AggregatingMergeTree`)
- Choosing `ORDER BY` / partition keys for time-series or event data
- Writing aggregation queries (`GROUP BY`, `uniq`, `quantiles`, window functions)
- Tuning inserts (batches vs trickle), mutations, and background merges