clickhouse

What problem does it solve?

This Skill provides expert guidance on designing efficient ClickHouse schemas, optimizing complex analytical queries, and implementing robust data ingestion strategies to maximize performance and minimize costs.

Core Features & Use Cases

• Schema Design: Guidance on ORDER BY planning, data types, partitioning, and LowCardinality/Enum usage.
• Query Optimization: Strategies for JOIN algorithms, dictionaries, data skipping indices, and materialized views.
• Insert Strategy: Best practices for batching, async inserts, and choosing appropriate MergeTree engines.
• Use Case: Optimize a slow-running ClickHouse analytics dashboard by applying schema design and query optimization best practices.

Quick Start

Use the clickhouse skill to optimize the ORDER BY clause for a new events table.