postgresql-health-check
CommunityDiagnose PostgreSQL performance and health.
Authorrudi-bruchez
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps identify and diagnose common performance issues and potential problems within a PostgreSQL database instance, ensuring optimal health and stability.
Core Features & Use Cases
- Comprehensive Health Analysis: Checks connections, wait events, lock contention, bloat, autovacuum status, replication lag, and transaction ID wraparound risk.
- Proactive Monitoring: Use during routine audits or when experiencing slowness, connection refusals, or high resource utilization.
- Use Case: When users report that PostgreSQL is slow or queries are timing out, run this health check to pinpoint the bottleneck, whether it's lock contention, excessive bloat, or replication lag.
Quick Start
Run a PostgreSQL health check by executing the provided diagnostic queries.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgresql-health-check Download link: https://github.com/rudi-bruchez/dba-skills/archive/main.zip#postgresql-health-check Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.