sk Skill · affaan-m
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is too slow.
Open on skills.sh ↗read 2026-09-17
- installs 8w
- 1,541
- 30-day movement
- starts with the next reading
- Related entries
- 7
- Connections
- 0
typescriptsqlJavaScript
A SKILL.md agent skill that loads ClickHouse guidance into an AI coding agent. It covers table design with MergeTree engines, query optimization, insertion patterns, materialized views, and analytics query recipes.
Reach for it when your agent is writing ClickHouse schemas or queries, or when an analytical query is too slow and you want ClickHouse-specific patterns applied.
Use it to
- Design MergeTree table schemas
- Optimize slow analytical queries
- Write time series, funnel, or cohort queries
- Set up materialized views for real-time aggregation
- Follow bulk insert and partitioning best practices
For Developers building analytics on ClickHouse with AI agents
- Host repository
- affaan-m/ECC
- Installs, lifetime
- 2,900
- Installs, 8 weeks
- 1,541
- Host stars
- 261k
- Host language
- JavaScript
topicsclickhouseolapquery-optimizationschema-designanalyticssql