SchemaSentry

SchemaSentry monitors relational database schema changes across environments (dev/stage/prod) and flags risky drift before it causes incidents. It connects to Postgres/MySQL, snapshots schema metadata (tables, columns, indexes, constraints, privileges), and compares it against a declared baseline (Git repo or stored snapshot). When drift is detected—like missing indexes, altered column types, dropped constraints, or privilege changes—it generates a human-readable report plus a safe migration recommendation (SQL diff) and opens a ticket/PR. It also tracks “who changed what” by correlating DDL events with database logs/audit extensions where available. This is not another full DBA suite; it’s a focused guardrail that teams can actually adopt. The MVP should be lightweight, opinionated, and integrate tightly with CI/CD so drift is caught early rather than during outages.