ClickHouse Architecture Advisor
Skill ActiveMUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. Complements clickhouse-best-practices with decision frameworks and explicit provenance labels.
Use this skill when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.
Features
- Workload classification for ClickHouse architectures
- Decision frameworks for ingestion and modeling patterns
- Explicit provenance labels (official, derived, field)
- Guidance on architecture tradeoffs and system-level design
Use Cases
- Designing real-time ClickHouse architectures
- Selecting appropriate ingestion patterns
- Planning for late-arriving data or upserts
- Building ClickHouse POCs or workshop designs
Non-Goals
- Replacing official ClickHouse documentation
- Performing low-level rule enforcement
- Making commercial recommendations
Workflow
- Identify the workload shape (observability, SIEM, etc.)
- Read relevant decision rule files
- Use doc_links.yaml to attach official documentation
- Classify recommendations (official, derived, field)
- Provide recommendations with provenance, confidence, source, and validation
Trust
- warning:Issues Attention22 issues were opened in the last 90 days and 0 were closed, indicating slow or no maintainer response to open issues.
Installation
First, add the marketplace
/plugin marketplace add clickhouse/agent-skills/plugin install agent-skills@clickhouse-agent-skillsQuality Score
Trust Signals
Similar Extensions
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
V3 Ddd Architecture
100Domain-Driven Design architecture for claude-flow v3. Implements modular, bounded context architecture with clean separation of concerns and microkernel pattern.