clickhouse-architecture-advisor

Generate workload-aware ClickHouse architecture decisions with provenance-labeled guidance.

1.6k|107|Updated Feb 15, 2026
One-click install
npx skills add https://github.com/Makisuo/maple --skill clickhouse-architecture-advisor-makisuo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: clickhouse-architecture-advisor
Source: https://github.com/Makisuo/maple/tree/main/.agents/skills/clickhouse-architecture-advisor
Command: npx skills add https://github.com/Makisuo/maple --skill clickhouse-architecture-advisor-makisuo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Enables teams to design ClickHouse architectures by applying workload-aware decision frameworks and provenance-labeled guidance.

Core Features & Use Cases

  • Provides structured decision frameworks for ingestion strategy, time-series partitioning, enrichment path selection, handling late-arriving data, and real-time pre-aggregation.
  • Attaches official documentation links and strict provenance labels (official, derived, field) to recommendations.
  • Supports workshop, proof-of-concept, and production design workflows through guideline-driven outputs.

Quick Start

Provide a workload description (for example, 'observability/logs with real-time dashboards') to generate an architecture blueprint.

Frequently Asked Questions about clickhouse-architecture-advisor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a ClickHouse architecture for a specific workload like observability logs?

To design a ClickHouse architecture, provide a workload description such as observability logs with real-time dashboards. The advisor applies workload-aware decision frameworks to generate a validated architecture blueprint with example architectures for your specific use case.

What is the best way to handle time-series partitioning and late-arriving data in ClickHouse?

Time-series partitioning and late-arriving data handling in ClickHouse are resolved using structured decision frameworks. The advisor provides provenance-labeled guidance, classifying recommendations as official, derived, or field practices to ensure validated design choices.

Can I use this advisor for production ClickHouse deployments or only proof-of-concept workflows?

Yes, you can use this advisor for production ClickHouse deployments. It explicitly supports workshop, proof-of-concept, and production design workflows by applying guideline-driven outputs and decision frameworks across all deployment stages.

How does the advisor choose between different enrichment paths for ClickHouse ingestion?

Enrichment path selection for ClickHouse ingestion is determined by applying workload-aware decision frameworks. The advisor reads rule files, attaches official documentation provenance, and labels recommendations as official, derived, or field to guide your choice.

Do I need to provide specific workload details to get real-time pre-aggregation recommendations?

Yes, you need to provide a workload description to receive real-time pre-aggregation recommendations. The advisor requires workload context to apply its decision frameworks and generate validated design guidance tailored to your deployment.

Why are ClickHouse architecture recommendations labeled as official, derived, or field?

ClickHouse architecture recommendations are labeled official, derived, or field to attach strict provenance and attach official documentation links. This classification ensures transparency regarding the source and validation level of each design guidance point provided.