MyDBA.dev

MyDBA.dev is a PostgreSQL performance monitoring platform that goes beyond dashboards. It runs 75+ automated health checks across configuration, performance, security, replication, and maintenance — then gives you priority-ranked action items with ready-to-run SQL fix scripts.

Key features:

• Health Scoring: Automated checks with P1-P4 priority rankings and SQL remediation scripts
• Cluster-Aware Index Advisor: Analyses index usage across your entire replication topology — primary, replicas, and cascading standbys. Detects unused, duplicate, and missing indexes with space-waste estimates and DDL
• Query Monitoring: Performance tracking, EXPLAIN plan collection and analysis, wait event monitoring, and plan regression detection
• XID Wraparound Protection: Blocker detection for long-running transactions, prepared transactions, and replication slots, with auto-generated recovery scripts
• Extension Monitoring: Deep monitoring for TimescaleDB (compression, chunks, continuous aggregates, jobs), pgvector (index health, distance functions, embeddings), and PostGIS (spatial indexes, SRID validation, geometry quality)
• Lock Chain Visualization: Interactive dependency graphs showing exactly which query is blocking which
• Schema Diff: Compare schemas across instances with generated ALTER scripts
• Alerting: Configurable alerts with email notifications and digest scheduling

The lightweight Go collector runs on your infrastructure (self-hosted or managed fleet on Fly.io) and sends metrics to MyDBA.dev's hosted backend. Works with self-hosted PostgreSQL, AWS RDS, Aurora, and any PostgreSQL-compatible service.

Free forever for 1 server + 1 replica with all features included. No credit card required. Also includes 12 free client-side developer tools (EXPLAIN visualizer, SQL formatter, config tuner, and more) at mydba.dev/tools.