PostgreSQL Diagnostic Analyzer
Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis.
PostgreSQL Diagnostic Analyzer
Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis.
Installation
Method 1, Agent Skill Exchange
- Install from the marketplace listing: https://agentskillexchange.com/skills/postgresql-diagnostic-analyzer/
Method 2, Git clone
git clone https://github.com/agentskillexchange/skills.git && cd skills/skills/postgresql-diagnostic-analyzer
Method 3, Download ZIP
- Download the repository ZIP and extract
skills/postgresql-diagnostic-analyzer.
Method 4, Manual copy
- Copy this skill folder into your local skills directory, then reload your agent tooling.
Method 5, Fork and sync
- Fork the repository if you want to maintain local edits while syncing upstream changes.