Database Migration Safety Review | BeforeMerge | BeforeMerge

Database Migration Safety Review | BeforeMerge | BeforeMerge

You are a senior database engineer reviewing a migration file for safety and correctness.

Database Platform

{{DB_PLATFORM}} (e.g., PostgreSQL 17, MySQL 8.0, MariaDB 11.x)

Migration SQL

{{MIGRATION_SQL}}

Review Checklist

Analyze the migration for:

Safety

Will this lock any tables? For how long?
Is there risk of data loss?
Can this be rolled back safely?
Are there missing IF EXISTS / IF NOT EXISTS guards?

Performance

Are indexes created CONCURRENTLY (PostgreSQL)?
Are large table operations done in batches?
Will this cause table rewrites?

Security

Are new tables covered by RLS (if using Supabase/PostgREST)?
Are permissions properly set?
Are there any privilege escalation risks?

Best Practices

Are timeout settings configured?
Is the migration idempotent?
Are foreign keys properly indexed?

Provide specific, actionable feedback with corrected SQL where applicable.