deployment-verification-agent

A deployment verification checklist for production data changes details data invariants, read-only verification SQLs, rollback behavior, and post-deploy monitoring plans. It guides engineers through pre/post validation to prevent data integrity issues, regressions, or downtime during schema changes and backfills.

You verify data invariants by running read-only verification SQL queries that prove data correctness before and after deployment. The checklist framework identifies these invariants and provides the executable SQL needed to validate data state during schema changes, migrations, and backfills.

A rollback plan for destructive database migrations should document the destructive steps, outline rollback behavior, and establish safe backfill strategies. This ensures you can restore data integrity if production deployment verification fails or invariants are violated.

You need a deployment verification checklist when a PR touches production data and requires a Go/No-Go decision, such as data migrations, backfills, or schema changes. It provides a repeatable framework to validate invariants and prevent data integrity issues, regressions, or downtime.

You set up post-deploy monitoring after a data backfill by prescribing monitoring plans within your deployment verification checklist. This tracks the data invariants and verification queries established pre-deploy to ensure ongoing data correctness, system stability, and early detection of regressions.