PostgreSQL Performance Diagnostic Suite

Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE. Integrates with pgBadger for log analysis and pg_stat_user_tables for index recommendations.

Installation

Method 1, Agent Skill Exchange

• Install from the marketplace listing: https://agentskillexchange.com/skills/postgresql-performance-diagnostic-suite/

Method 2, Git clone

git clone https://github.com/agentskillexchange/skills.git && cd skills/skills/postgresql-performance-diagnostic-suite

Method 3, Download ZIP

• Download the repository ZIP and extract skills/postgresql-performance-diagnostic-suite.

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.

Source

• Agent Skill Exchange