clickhouse-schema-design

What problem does it solve?

This Skill helps you design and optimize ClickHouse table schemas to achieve sub-second query performance, significantly improve data compression, and automate data lifecycle management.

Core Features & Use Cases

• Schema Design Rules: Provides critical, high, and medium priority rules for ORDER BY, PARTITION BY, and data types.
• Engine Selection Guidance: Explains the use cases for various MergeTree engines.
• TTL Configuration: Demonstrates how to set up data retention and tiered storage policies.
• Use Case: When creating a new table for event logs, use this Skill to ensure your ORDER BY clause is optimized for common query patterns, your PARTITION BY is set for efficient data management, and you select the most space-efficient data types.

Quick Start

Use the clickhouse-schema-design skill to generate an optimized schema for an events table with daily partitioning and a time-based order by clause.