Database migrations, rehearsed by AI agents
The change nobody wants to run at midnight, rehearsed
Schema changes and data fixes are hard to undo, so they wait for a quiet night and a brave engineer. Agents find every query a change touches, write the migration and the rollback, rehearse both on a copy, and hand you a runbook. A person runs production.
Trace the dependencies of a schema change
A text search finds most of the places that read a column. The ones it misses break the morning after. The agent traces the change through code, reports, and jobs in every repository, then updates each one in the same change.
Rehearse the migration and rollback on a database copy
The migration and its rollback are written together and run against a copy of your database, up and then down, with checks after each. Your team provides the copy or a masked snapshot. What you review is a runbook built from a real rehearsal, not a script nobody has run.
- 01Step order and dependenciesWhich step runs first, and what each one depends on.
- 02How long each rehearsal step tookHow long each step took on a copy of production.
- 03When to pause or roll backThe checks to run, and when to roll back instead of going on.
Resume a backfill after a failed batch
Moving a million rows is where one-off scripts go wrong. The agent writes backfills that run in batches, can run twice safely, and resume after a failure, and check their result against counts you agreed on first.
Rosa reviews an address-table migration rehearsal
Illustrative example, not a customer result.Here is what the work looks like today, and what changes when an AI team takes the busywork off the plate.