Clickhouse Architecture Advisor

This is a workload-aware decision framework for ClickHouse schema and ingestion design. It doesn't just recite best practices. It asks you to identify your workload type (observability, product analytics, SIEM, etc.), then walks through scenario-specific decision rules covering real-time preaggregation, partitioning strategies, join enrichment patterns, and late-arriving event handling. Every recommendation is labeled as official, derived, or field guidance with explicit confidence levels and doc links. The format is structured around tradeoffs and bottlenecks rather than generic settings. Useful if you're past the getting-started phase and need to make architectural calls that depend on your specific access patterns and constraints.