DriftGuard

DriftGuard is a web app (with a lightweight CLI agent) that continuously verifies your database schema matches what your migration history claims across environments. It connects read-only to Postgres/MySQL and inspects live schema, then compares it to expected state derived from migration files (Flyway/Liquibase/Prisma/Knex) and your ORM models. It flags risky drift patterns: hotfixes applied directly in prod, missing migrations, out-of-order changes, divergent branches, and destructive operations that slipped through review. The product generates a clear “drift report” with exact DDL diffs, impact estimates (tables/rows/indexes affected), and a safe remediation plan (forward-fix migrations, not manual edits). It also enforces policy in CI: block deploys when drift exceeds thresholds. This is not glamorous, but it’s the kind of boring tool teams will pay for once it saves them a single outage.