Optimizes ClickHouse database schemas and analytical queries for high-performance OLAP workloads.
This skill provides Claude with expert knowledge of ClickHouse, a column-oriented DBMS optimized for online analytical processing (OLAP). It enables Claude to design efficient MergeTree table schemas, write high-performance SQL queries using ClickHouse-specific functions, implement real-time materialized views, and manage large-scale data ingestion patterns. Whether you are migrating from traditional RDBMS like PostgreSQL or building real-time dashboards and time-series analytics from scratch, this skill ensures your implementation follows industry best practices for speed and scalability.
Key Features
01Real-time aggregation using Materialized Views
020 GitHub stars
03High-performance analytical query optimization and window functions
04Advanced MergeTree engine selection and schema design
05Efficient data ingestion patterns including Bulk, Streaming, and CDC
06Performance monitoring and system table analysis
Use Cases
01Designing real-time analytics dashboards and time-series data stores
02Implementing ETL pipelines and data migration from transactional databases to ClickHouse
03Optimizing slow analytical queries on massive datasets
