Cc Skill Clickhouse Io
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.
- skills.sh installs
- 211
- GitHub stars
- 39.4K
- last updated
- Jun 3, 2026
Install
$ npx -y skills add sickn33/antigravity-awesome-skills --skill cc-skill-clickhouse-io --agent claude-codeInstalls into .claude/skills of the current project.
Files
ClickHouse Analytics Patterns
ClickHouse-specific patterns for high-performance analytics and data engineering.
Overview
ClickHouse is a column-oriented database management system (DBMS) for online analytical processing (OLAP). It's optimized for fast analytical queries on large datasets.
Key Features:
- Column-oriented storage
- Data compression
- Parallel query execution
- Distributed queries
- Real-time analytics
Correctness and measurement boundaries
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/sickn33/antigravity-awesome-skills
- Category
- Databases
- First seen
- Jun 3, 2026
More from sickn33/antigravity-awesome-skills
All 708- Embedding Strategies210
- Xlsx208
- Cqrs Implementation207
- Bats Testing Patterns206
- Antigravity Skill Orchestrator205
- Conductor Validator205
- Julia Pro205
- X Article Publisher Skill205
- Ml Pipeline Workflow204
- Distributed Tracing203
- Fix Review203
- Pci Compliance203
- Team Collaboration Issue203
- Fal Generate201
- Graphql Architect201
- Incident Response Incident Response201
- Network 101201
- Workflow Patterns201
- Multi Cloud Architecture200
- Stride Analysis Patterns199
- Bazel Build Optimization198
- Hybrid Search Implementation198
- Pypict Skill198
- Top Web Vulnerabilities198
Recommended
More Databases
convex-helpers-guideget-convex/convex-agent-pluginsDiscover and use convex-helpers utilities for relationships, filtering, sessions, custom functions, and more. Use when you need pre-built Convex patterns.186skills.sh installs
sqlite-vecexistential-birds/beaglesqlite-vec extension for vector similarity search in SQLite. Use when storing embeddings, performing KNN queries, or building semantic search features. Triggers171skills.sh installs
convex-authzdbjpanda/convex-tenantsAdd production-ready authorization (RBAC, ABAC, ReBAC) to Convex apps with O(1) permission checks. Use when implementing roles, permissions, access control, mul170skills.sh installs
clickhouse-architectterrylica/cc-skillsClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.157skills.sh installs