troubleshoot-cockroachdb

Diagnose CockroachDB incidents by mapping Netdata health signals to failure archetypes.

1|Updated Apr 17, 2026
One-click install
npx skills add https://github.com/netdata/skills --skill troubleshoot-cockroachdb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: troubleshoot-cockroachdb
Source: https://github.com/netdata/skills/tree/main/skills/troubleshoot-cockroachdb
Command: npx skills add https://github.com/netdata/skills --skill troubleshoot-cockroachdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Troubleshoots recurring CockroachDB failure modes (LSM compaction death spiral, raft liveness failures, clock skew crises, hot ranges, and intent accumulation) by turning Netdata health signals into a structured diagnostic path.

Core Features & Use Cases

  • Symptom-to-signal triage: Routes an AI through dominant failure archetypes using Netdata operator playbook logic and CockroachDB-specific MCP queries.
  • Evidence-first verification: Recommends remediation steps and validates the fix by re-running the same MCP queries and checking for a clean anomaly result.
  • Focused for on-call and incidents: Designed for cases where latency, saturation, errors, or unexpected restarts indicate CockroachDB behavior outside its expected envelope.

Real-world use case: You receive a Netdata alert for a CockroachDB node that appears “stuck,” and you need to quickly determine whether it matches a compaction spiral, raft liveness loss, clock drift, or hot range bottleneck.

Quick Start

Ask the AI to troubleshoot your CockroachDB incident by querying the relevant Netdata CockroachDB MCP health signals and mapping the results to the correct failure archetype.

Frequently Asked Questions about troubleshoot-cockroachdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot CockroachDB raft liveness failures using health signals?

Troubleshoot CockroachDB raft liveness failures by mapping Netdata health signals to dominant failure archetypes. Use the operator playbook diagnostic tree and CockroachDB-specific MCP queries to identify liveness loss, then verify remediation by re-running queries for clean anomaly results.

What causes LSM compaction death spirals in CockroachDB and how do I diagnose them?

Diagnose LSM compaction death spirals in CockroachDB by querying Netdata collector contexts via MCP. Apply the operator playbook logic to match observed health signals against the compaction death spiral archetype, distinguishing it from clock skew, hot ranges, or intent accumulation.

How do I validate CockroachDB remediation steps after fixing a hot range bottleneck?

Validate CockroachDB remediation by re-running the same Netdata MCP queries used during triage. Check the specified load-bearing contexts to ensure a clean anomaly result, confirming the hot range bottleneck or intent accumulation issue is fully resolved.

Can I use Netdata to triage CockroachDB clock skew crises and unexpected node restarts?

Use Netdata to triage CockroachDB clock skew crises and unexpected restarts by routing health signals through the diagnostic tree. Query CockroachDB-specific MCP contexts to match symptoms against the clock skew crisis archetype for structured incident resolution.

What Netdata contexts do I need to diagnose intent accumulation in CockroachDB?

Diagnose CockroachDB intent accumulation by querying specific Netdata CockroachDB collector contexts via MCP. Follow the diagnostic tree to verify whether observed latency and saturation signals match the intent accumulation archetype before recommending remediation steps.

Does this diagnostic approach work for all CockroachDB failure modes or just specific archetypes?

This triage approach covers specific CockroachDB failure archetypes: LSM compaction death spirals, raft liveness failures, clock skew crises, hot ranges, and intent accumulation. It routes Netdata signals through the operator playbook to match the correct archetype during incident remediation.