clickhouse-core-workflow-a
Installation
SKILL.md
ClickHouse Schema Design (Core Workflow A)
Overview
Design ClickHouse tables with correct engine selection, ORDER BY keys, partitioning, and codec choices for analytical workloads.
Prerequisites
@clickhouse/clientconnected (seeclickhouse-install-auth)- Understanding of your query patterns (what you filter and group on)
Instructions
Step 1: Choose the Right Engine
| Engine | Best For | Dedup? | Example |
|---|---|---|---|
MergeTree |
General analytics, append-only logs | No | Clickstream, IoT |
Related skills