ClickHouse Analytics Patterns ClickHouse-specific patterns for high-performance analytics and data engineering. When to Activate Designing ClickHouse table schemas (MergeTree engine selection) Writing analytical queries (aggregations, window functions, joins) Optimizing query performance (partition pruning, projections, materialized views) Ingesting large volumes of data (batch inserts, Kafka integration) Migrating from PostgreSQL/MySQL to ClickHouse for analytics Implementing real-time dashboards or time-series analytics 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. Show more Installs 1.5K Repository affaan-m/ecc GitHub Stars 239.2K First Seen May 19, 2026 Security Audits Gen Agent Trust Hub Pass Socket Pass Snyk Pass
clickhouse-io
安装
npx skills add https://github.com/affaan-m/ecc --skill clickhouse-io