troubleshoot-pgbouncer

What problem does it solve?

This skill helps you quickly diagnose why PgBouncer is failing or degrading—specifically pool exhaustion, connection limits, file descriptor exhaustion, backend unreachable states, and pool mode mismatches.

Core Features & Use Cases

• Operator playbook triage flow via MCP: walks an agent through a structured diagnostic tree using the same Netdata signal surface as the PgBouncer operator playbook.
• Root-cause archetype matching: identifies the dominant failure mode and narrows investigation to the load-bearing signals and related contexts.
• Verification-driven remediation: recommends remediation pointers and validates improvements by re-running the MCP queries and checking for signal recovery.

Use case: An on-call engineer is alerted because a PgBouncer instance shows rising errors/latency; this skill guides the agent through MCP queries, finds anomalous pgbouncer.* contexts, and produces a remediation path focused on the most likely archetype.

Quick Start

Ask the agent to troubleshoot PgBouncer using Netdata MCP by running the PgBouncer health queries over the last 15 to 30 minutes and selecting the correct remediation based on the detected failure archetype.