clickhouse-io
ClickHouse patterns for high-performance analytics, data engineering, and optimized SQL query design.
Install
npx skills add https://github.com/affaan-m/everything-claude-code --skill clickhouse-ioStats
| Total installs | 1,653 |
| Weekly installs | 1.6K |
| GitHub stars | 112.5K |
| First seen | Jan 22, 2026 |
| Source | @affaan-m/everything-claude-code |
Summary
- Covers three primary MergeTree engine variants: standard MergeTree for time-series data, ReplacingMergeTree for deduplication, and AggregatingMergeTree for pre-aggregated metrics
- Includes query optimization patterns for efficient filtering, aggregations, window functions, and percentile calculations with ClickHouse-specific functions
- Demonstrates data insertion strategies (bulk inserts, streaming), materialized views for real-time aggregations, and performance monitoring via system tables
- Provides ready-to-use patterns for common analytics workflows: time-series analysis, retention, funnels, cohorts, and ETL/CDC pipelines with TypeScript examples
Tags
Related skills
| Skill | Installs | vs clickhouse-io |
|---|---|---|
| pydantic | 1,783 | +130 |
| stock-market-pro | 1,898 | +245 |
| derivatives-trading-usds-futures | 1,469 | -184 |
| query-address-info | 1,988 | +335 |
| file-organizer | 1,802 | +149 |
FAQ
- How many installs does clickhouse-io have?
- clickhouse-io has 1,653 total installs and 1.6K installs this week.
- Where is clickhouse-io hosted?
- clickhouse-io is published by @affaan-m/everything-claude-code at https://github.com/affaan-m/everything-claude-code.
- How many GitHub stars does clickhouse-io have?
- clickhouse-io has 112.5K GitHub stars.
- When was clickhouse-io first indexed?
- OrangeBot.AI first indexed clickhouse-io on Jan 22, 2026.
- How do I install clickhouse-io?
- Run: npx skills add https://github.com/affaan-m/everything-claude-code --skill clickhouse-io