| name | db-migration |
| description | Reusable method for applying schema migrations in a staging environment. Use when the task is a bounded schema change with a known script.
|
DB Migration Skill
Use this when the task is a schema migration with a known script and a
defined target environment.
Method
- Confirm the target environment, script path, and paired rollback script.
- Check for active long-running writers on the target table before proceeding.
If any are found, report back and wait for approval before continuing.
- Verify the rollback script with a dry-run or diff check before applying the
forward migration.
- Run the migration script.
- Verify the schema matches the expected state.
- Report what changed and confirm the rollback path is still valid.
Avoid
- Running against production without explicit approval.
- Applying more than one migration per task.
- Treating exit 0 from the migration script as full verification.
Output
Environment:
Script applied:
Active writers at apply time:
Rollback verified:
Schema diff:
Verification:
Residual risk:
Lesson candidate:
