SkillVaultskills Browse all 1,000+ skills

Architecture · Version 1.0.0 · Reviewed 2026-08-02

ClickHouse Architecture Review Specialist

Make a defensible decision about ClickHouse architecture boundary review and ClickHouse failure-mode modeling with evidence, explicit trade-offs, and a verification plan.

4 method steps 4 documented failure modes 4 diagnostic checks 7 quality gates

Reviews architecture boundaries, operating assumptions, and failure behavior in ClickHouse using table engines, sort keys, partitions, queries, and materialized views and query logs, parts count, merges, bytes read, and memory use, with explicit attention to a wrong sort key or tiny-part explosion forcing broad scans and merge debt.

₹299 one-time

Get this skill archive

Install in your AI coding tool

SkillVault packages this skill in the open Agent Skills format for five leading coding tools.

What this skill helps you do

  • ClickHouse architecture boundary review
  • ClickHouse failure-mode modeling
  • ClickHouse architecture decision record

How ClickHouse Architecture Review Specialist works

You provide

Requirements, constraints, and the current topology

It inspects

Critical path and failure boundaries for ClickHouse architecture boundary review

It decides

A ClickHouse failure-mode modeling decision with consequences recorded

You verify

Rollout stages with the signal that gates each one

What it checks first

ClickHouse Architecture Review Specialist reviews architecture boundaries, operating assumptions, and failure behavior in ClickHouse using table engines, sort keys, partitions, queries, and materialized views and query logs, parts count, merges, bytes read, and memory use, with explicit attention to a wrong sort key or tiny-part explosion forcing broad scans and merge debt. Use it when the work involves ClickHouse architecture boundary review, ClickHouse failure-mode modeling, ClickHouse architecture decision record.

  1. The quality attribute that actually constrains the design: latency, consistency, availability, cost, or compliance.
  2. The critical path and the number of network hops on it.
  3. Where state lives and who owns it, since ownership ambiguity becomes a correctness problem.
  4. The failure behavior of every dependency: fail open, fail closed, or degrade.

Failure modes it recognizes

  • Synchronous coupling making availability the product of all dependency availabilities.
  • A shared database creating hidden coupling between nominally independent services.
  • A component with no clear owner, so its failure has no defined response.
  • Distributed transactions attempted across services without a saga or compensation model.

Answers it will reject

  • Selecting a technology before establishing the constraint it is meant to satisfy.
  • Presenting a diagram as a design without the failure and data-consistency model.
  • Optimizing for a hypothetical future scale at the cost of present operability.

Decision rules it applies

  • Make the consistency requirement explicit per operation, not per system.
  • Prefer designs whose failure modes are understood over designs whose peak performance is higher.
  • Record the decision, the rejected alternatives, and the conditions that would reverse it.

Evidence it asks for

  • Quantify load, growth, and latency budget with arithmetic and stated assumptions.
  • Define the rollout stages and the signal that gates each one.
  • Name the reversal path for the decision.

The method inside

  1. Map the artifact, actors, boundaries, and invariants relevant to ClickHouse architecture boundary review.
  2. Trace concrete failure or abuse paths for ClickHouse failure-mode modeling; do not report checklist items without a mechanism.
  3. Prioritize ClickHouse architecture decision record findings by impact, likelihood, confidence, and cost of correction.
  4. Recommend the smallest defensible change, then define how an independent reviewer can verify it.

Deliverables

  • ClickHouse architecture boundary review assessment
  • ClickHouse failure-mode modeling decision and action plan
  • ClickHouse architecture decision record verification checklist

Evidence requirements

  • Functional and quality requirements
  • Scale, latency, consistency, cost, and compliance constraints
  • Current topology and alternatives considered

Quality gates

  • Every material claim traces to supplied evidence or is labeled as a hypothesis.
  • The response follows the declared deliverable contract.
  • No execution, access, measurement, or verification is invented.
  • Secrets and personal data are redacted rather than repeated.
  • The user receives a concrete independent verification step.
  • The relevant failure modes in this domain were considered rather than only the reported symptom.
  • No listed anti-pattern was recommended as a solution.

Example task

Input

Apply the architecture review specialist to our ClickHouse system before the next production change. We can provide table engines, sort keys, partitions, queries, and materialized views; the main concern is a wrong sort key or tiny-part explosion forcing broad scans and merge debt.

Expected output

Map primary-key pruning, background merges, distributed tables, and object storage before choosing components. The first design risk to test is a wrong sort key or tiny-part explosion forcing broad scans and merge debt. Compare only options that preserve the stated invariant, then record load assumptions, rollback, ownership, and the signal that would reverse the decision.

Boundaries and compatibility

Ideal for

  • ClickHouse architecture boundary review: produce a decision or artifact grounded in supplied evidence.
  • ClickHouse failure-mode modeling: produce a decision or artifact grounded in supplied evidence.
  • ClickHouse architecture decision record: produce a decision or artifact grounded in supplied evidence.

Out of scope

  • Producing a generic reference architecture without requirements
  • Hiding material trade-offs behind best-practice language

Agent compatibility

  • GitHub Copilot Agent Skills
  • Cursor Agent Skills
  • Claude Code Skills
  • OpenAI Codex Skills
  • JetBrains Junie Skills

Tool policy: Advisory by default. No tools are assumed. If the host provides tools, use read-only evidence gathering unless the user explicitly approves a scoped write or execution action.