Summary
This is a comprehensive pattern library for ClickHouse, the columnar OLAP database built for analytical workloads. You get concrete examples of table engine choices (MergeTree for general use, ReplacingMergeTree for deduplication, AggregatingMergeTree for pre-aggregated metrics), query optimization techniques, and bulk insert patterns that actually matter at scale. The materialized views section shows how to build real-time aggregations, and there are ready-to-use queries for retention analysis, funnel tracking, and cohort analysis. If you're running analytics on large datasets and need sub-second query times, this covers the practical patterns you'll actually implement. The performance monitoring queries alone are worth having around when things get slow.
Install to Claude Code
npx -y skills add sickn33/antigravity-awesome-skills --skill cc-skill-clickhouse-io --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 →
