Database
555 installs
ClickHouse Analytics Patterns
by affaan-m/everything-claude-code
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Skill content
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.