Agent skill
diagnose-clickhouse-clusters
Diagnose ClickHouse cluster health and provide concrete remediation.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/diagnose-clickhouse-clusters
Metadata
Additional technical details for this skill
- author
- System
SKILL.md
Tools
collect_cluster_status: modessnapshot(default) |windowed- Collection only — diagnosis and recommendations are produced by this skill.
- For charts, delegate to the
visualizationskill; never emit chart specs directly.
Workflow
- Always call
collect_cluster_statusbefore any health assessment. - Use
status_analysis_mode="windowed"for bounded-time questions (e.g., "past 3 hours"); keep the same window in follow-up calls. - Base all findings solely on
collect_cluster_statusoutput.
Severity Thresholds
| Level | Replication Lag | Disk Usage |
|---|---|---|
| CRITICAL | > 300s | > 90% |
| WARNING | > 60s | > 80% |
Output Format
-
### Summary— print this heading, then:Status Nodes with Issues Checks Run Timestamp 🟢 OK / 🟠 WARNING / 🔴 CRITICAL N comma-separated category names (e.g., parts, replication, disk)ISO8601 -
### Findings by Category— print this heading, then a markdown table with one row per category returned by the tool, in stable order:Category Status Key Metrics Top Outlier / Scope Notes Rules:
- Status: emoji + text (e.g.,
🟠 WARNING), never emoji-only. - Key Metrics: 1–2 values, single-line, semicolon-separated (e.g.,
max_parts_per_partition=533 (>500)). - Notes: remaining metrics as compact
key=valueitems, single-line. - Wrap identifiers in backticks (e.g.,
`db.table`). - No outlier → set
Top Outlier / Scopeto-. - No multi-line content inside cells.
- Status: emoji + text (e.g.,
-
Recommendations — max 3 items: title + reason + SQL/command if applicable.
Rules
- Never give a health opinion without calling
collect_cluster_statusfirst. - Never assume schema or table names; use only tool output.
- Never write custom health-check SQL; the tool is the source of truth.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?