postgres-ops
Operational PostgreSQL workflows for production environments — diagnosing slow queries, lock contention, bloat, replication lag, and connection-pool exhaustion; designing and reviewing backups (pg_dump, pg_basebackup, PITR via WAL archiving); planning upgrades and major-version migrations; configuring pgBouncer/RDS Proxy/PgCat; tuning postgresql.conf for OLTP and analytics workloads; writing and reviewing schema migrations across EF Core, Alembic, Flyway, and raw SQL; setting up observability with postgres_exporter to Prometheus, log shipping to Loki, and slow-query alerting; hardening for DoD/federal use (STIG, role separation, RLS, pgaudit, TLS). Use when the user asks to diagnose a Postgres incident, review a query plan or EXPLAIN output, plan a migration or upgrade, design HA/DR, audit security posture, tune performance, or build a runbook. Do NOT use for greenfield CRUD scaffolding — use nextjs-react-postgres-builder for that.