Optimizes high-performance analytical workloads using ClickHouse-specific schema designs, query patterns, and data engineering best practices.
This skill equips Claude with specialized knowledge for architecting and optimizing ClickHouse, the industry-leading column-oriented database for real-time analytics. It covers everything from selecting the right MergeTree engine and partitioning strategies to implementing complex analytical functions like funnel and cohort analysis. Users can leverage this skill to improve query latency through projections and materialized views, manage large-scale data ingestion via batching, and monitor system performance to ensure reliable OLAP operations at scale.
주요 기능
01Performance Diagnostics & Monitoring
02Complex Analytical Query Patterns
03High-Volume Batch Ingestion
040 GitHub stars
05Real-time Materialized Views
06MergeTree Engine Optimization
사용 사례
01Optimizing complex time-series queries and window functions
02Building real-time analytics dashboards for high-velocity event data
03Migrating analytical workloads from MySQL or PostgreSQL to ClickHouse
