clickhouse-architecture-advisor

Classify ClickHouse workloads and generate YAML architecture guidance with provenance labels.

1|1|Updated Apr 11, 2026
One-click install
npx skills add https://github.com/Borisserz/FoodTracker --skill clickhouse-architecture-advisor-borisserz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: clickhouse-architecture-advisor
Source: https://github.com/Borisserz/FoodTracker/tree/main/.agents/skills/skills/clickhouse-architecture-advisor
Command: npx skills add https://github.com/Borisserz/FoodTracker --skill clickhouse-architecture-advisor-borisserz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides workload-aware architecture decisioning for ClickHouse, translating best practices into workload-specific system designs and embedding explicit provenance labels to distinguish official, derived, and field guidance.

Core Features & Use Cases

  • Workload classification and scenario mapping to guidance tailored for real-time ingestion, time-series, and mutable-state workloads.
  • Decision frameworks that translate official documentation and core ClickHouse behavior into architecture patterns (e.g., raw vs pre-aggregated paths, partitioning, and enrichment strategies).
  • Explicit provenance labeling for each recommendation (official, derived, field) with clear sources and validation steps.
  • Output contracts that structure guidance into workload summaries, key decisions, target architectures, example patterns, and validation tests.
  • Read and reference rule files under rules/ and link documentation via mappings/doc_links.yaml to attach official docs.
  • Non-reliance on field guidance as official and explicit disclaimers when uncertain.
  • Supports multiple workload scenarios and provides actionable architecture patterns, not low-level tuning.

Quick Start

Provide architecture guidance for a representative ClickHouse workload by applying the decision frameworks and citing provenance sources.

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 real-time ingestion and time-series workloads?

Designing ClickHouse architecture for real-time ingestion involves classifying workload shapes and applying decision frameworks to output target architectures, key decisions, and validation steps in a structured YAML format with provenance labels.

What is the best way to use materialized views for enrichment tasks in ClickHouse?

Using materialized views for enrichment tasks in ClickHouse involves applying decision frameworks that translate official documentation into architecture patterns, distinguishing between raw and pre-aggregated paths with explicit provenance labeling.

How do I know if a ClickHouse architecture recommendation is based on official documentation or field guidance?

ClickHouse architecture recommendations are labeled with explicit provenance tags—official, derived, or field—by referencing rule files and mapping official documentation, ensuring you know the exact source and validation steps for each guidance point.

Can I get workload-specific architecture patterns for mutable-state scenarios in ClickHouse?

Workload-specific architecture patterns for mutable-state scenarios in ClickHouse are generated through scenario mapping and decision frameworks that output target architectures, example patterns, and validation tests while indicating uncertainties when present.

Does this ClickHouse architecture advisor provide low-level tuning recommendations?

This ClickHouse architecture advisor does not provide low-level tuning, but instead focuses on actionable architecture patterns like raw vs pre-aggregated paths, partitioning, and enrichment strategies tailored to specific workload classifications.