postgres - Operate PostgreSQL instances safely
Safely operate PostgreSQL through configuration review, performance diagnostics, vacuum and bloat management, recovery, replication, upgrades, and failover planning.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Review PostgreSQL configuration
- Analyze indexes and query plans
- Manage vacuum and bloat
- Verify WAL archiving and PITR
- Operate replication and failover
- Manage PostgreSQL extensions
- Plan major-version upgrades
- Collect read-only diagnostics
Inputs
- PostgreSQL instance connection details
- Reported symptoms or workload queries
- Target instance and operation scope
- Rollback path
- Human mutation directive
- Relevant logs
Outputs
- Bounded JSON diagnostic results
- Configuration and performance findings
- Recovery and replication verification results
- Upgrade and failover plans
- Confirmed database state changes
Requirements
- Python 3.9+ for pgdiag
- psql client for live diagnostics
- PostgreSQL 10+ server for live diagnostics
- Socket or network access to the instance
- Explicit human directive for mutations