Generate idempotent database migrations that won't break on retry

Migration fails halfway through. Need to re-run it without creating duplicate columns or breaking existing data. Need prompts that generate: 'IF NOT EXISTS' checks, rollback logic, and safe retry patterns.