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.
- skills.sh installs
- 10.7K
- GitHub stars
- 565
- last updated
- Aug 21, 2026
Install
$ npx -y skills add clickhouse/agent-skills --skill clickhouse-architecture-advisor --agent claude-codeInstalls into .claude/skills of the current project.
Files
ClickHouse Architecture Advisor
This skill adds workload-aware architecture decisioning on top of clickhouse-best-practices.
Official docs remain the source of truth. This skill must always prefer official ClickHouse documentation when available.
Required behavior
Before producing recommendations:
- Identify the workload shape
- observability
- security / SIEM
- product analytics
- IoT / telemetry
- market data / financial services
- mixed OLAP with point-lookups
- Read the relevant decision rule files in
rules/ - Use
mappings/doc_links.yamlto attach official documentation - Classify every recommendation as:
officialderivedfield
- Never present field guidance as official guidance
- If a recommendation is uncertain, say so explicitly
Provenance rules
official
Use this when the recommendation is directly backed by official docs.
derived
Use this when the recommendation is not stated verbatim in docs but follows logically from documented ClickHouse behavior.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/clickhouse/agent-skills
- Categories
- Code Review & Quality, AI & Agent Building, Productivity & Planning, Databases
- First seen
- May 16, 2026
More from clickhouse/agent-skills
All 10Recommended
More Code Review & Quality
code-reviewanthropics/knowledge-work-pluginsReview code changes for security, performance, and correctness. Trigger with a PR URL or diff, "review this before I merge", "is this code safe?", or when check10.1Kskills.sh installs
frontend-code-reviewlanggenius/difyUse only when the user explicitly requests a review or audit of frontend code under `web/` or `packages/dify-ui/`. Supports pending-change, file-focused, and pa10.1Kskills.sh installs
differential-reviewtrailofbits/skillsPerforms security-focused differential review of code changes (PRs, commits, diffs). Adapts analysis depth to codebase size, uses git history for context, calcu10Kskills.sh installs
java-refactoring-remove-parametergithub/awesome-copilotRefactoring using Remove Parameter in Java Language8.9Kskills.sh installs
architectureanthropics/knowledge-work-pluginsCreate or evaluate an architecture decision record (ADR). Use when choosing between technologies (e.g., Kafka vs SQS), documenting a design decision with trade-7Kskills.sh installs