Clickhouse Architecture Advisor
Plugin ActiveWorkload-aware architecture decision skill for ClickHouse — ingestion strategies, partitioning, enrichment, upsert patterns, and pre-aggregation with explicit official/derived/field provenance
To guide users in designing robust and efficient ClickHouse architectures tailored to specific workloads, by offering decision frameworks and expert-backed recommendations with clear provenance.
Features
- Workload classification for architecture design
- Decision frameworks for ingestion and modeling patterns
- Architecture tradeoff guidance
- Explicit provenance for recommendations (official, derived, field)
Use Cases
- Designing real-time ClickHouse architectures
- Choosing between ingestion patterns for throughput and latency
- Selecting enrichment strategies (JOIN, dictionary, denormalization)
- Planning for mutable state and late-arriving data
Non-Goals
- Replacing official ClickHouse documentation
- Providing low-level schema and query rule checks (handled by `clickhouse-best-practices`)
- Automated implementation of architectural changes
Trust
- warning:Issues AttentionThere were 2 issues opened in the last 90 days and 0 closed, indicating slow or non-existent maintainer response to new issues.
Installation
First, add the marketplace
/plugin marketplace add clickhouse/agent-skills/plugin install clickhouse-architecture-advisor@clickhouse-agent-skillsQuality Score
Trust Signals
Similar Extensions
Database Design
99Database architecture, schema design, and SQL optimization for production systems
Multi Platform Apps
99Cross-platform application development coordinating web, iOS, Android, and desktop implementations
C4 Architecture
99Comprehensive C4 architecture documentation workflow with bottom-up code analysis, component synthesis, container mapping, and context diagram generation
Serverless Eda
99AWS serverless and event-driven architecture best practices based on Well-Architected Framework with MCP servers for SAM, Lambda, Step Functions, and messaging
Comprehensive Review
99Multi-perspective code analysis covering architecture, security, and best practices
Ruflo Adr
99ADR lifecycle management — create, index, supersede, check compliance, and link Architecture Decision Records to code via AgentDB hierarchical store + causal edges (supersedes/amends/depends-on/related)