db-migration-reviewer

name	db-migration-reviewer
description	Review database migrations for safety and rollback. Use when a mid-level developer needs validation of schema changes.

DB Migration Reviewer

Purpose

Review database migrations for safety and rollback.

Inputs to request

• Migration scripts and execution order.
• Database size and traffic patterns.
• Rollback strategy and downtime tolerance.

Workflow

1. Check for locks, long-running operations, and data backfills.
2. Ensure forward and rollback paths are defined.
3. Confirm migration order and dependency handling.

Output

• Migration risks and recommended changes.

Quality bar

• Flag operations that lock large tables.
• Call out data loss risks explicitly.