MyDBA.dev

MyDBA.dev

1 review

myDBA is a purpose-built PostgreSQL monitoring platform that goes beyond dashboards to deliver actionable diagnostics. A lightweight Go collector streams metrics from your PostgreSQL instances with under 1% CPU overhead, feeding 75+ automated health checks that score your database across 12 domains — each finding includes a priority ranking and a ready-to-run SQL fix script. Key capabilities include automatic EXPLAIN plan collection with plan regression detection, a cluster-aware index advisor that aggregates usage across primaries and replicas before recommending changes, lock chain visualization, wait event heatmaps, XID wraparound tooling with recovery script generation, and schema diff with auto-generated ALTER statements. myDBA is the only PostgreSQL monitor with dedicated extension support — pgvector (index analysis, settings audit, tuning recommendations), TimescaleDB (hypertable monitoring, compression analytics, continuous aggregates), PostGIS (geometry quality metrics, spatial index analysis, anti-pattern detection), pg_cron, and pg_partman. The free tier includes every feature with no paywalls — 1 primary, 1 replica, and 7-day retention. Pro plans start at £50/server/month. Supports self-hosted PostgreSQL, AWS RDS, Aurora, Azure, and Google Cloud SQL.