clickhouse-architecture-advisor

To design a ClickHouse architecture for real-time ingestion, this skill applies decision frameworks to classify your workload and generate a target architecture with provenance-labeled recommendations and example SQL.

The best way to partition time-series data in ClickHouse is determined by using this skill's time-series retention design frameworks, which evaluate your workload to output structured partitioning strategies and validation steps.

You need materialized views for pre-aggregation planning in ClickHouse when your analytics workload requires specific enrichment path selection, which this skill evaluates to produce pre-aggregation recommendations with explicit provenance tracking.

Handling late-arriving data patterns in ClickHouse ingestion strategies involves applying this skill's decision frameworks to assess your workload and output a structured ingestion strategy with official or field-derived guidance.

This ClickHouse architecture advisor provides explicit provenance management, ensuring all workload analysis and architecture decisions are clearly labeled as official, derived, or field guidance with documented sources.

You can get example SQL for your ClickHouse analytics workload by describing your scenario, which triggers the skill's output contract to generate target architecture designs, key decisions, and corresponding example SQL.