Know what your migration
will do to production

  MigrationPilot — migrations/002_alter_users.sql

  Risk:  RED  Score: 80/100

  ┌───┬────────────────────────────────────────┬──────────────────┬────────┬───────┐
  │ # │ Statement                              │ Lock Type        │ Risk   │ Long? │
  ├───┼────────────────────────────────────────┼──────────────────┼────────┼───────┤
  │ 1 │ CREATE INDEX idx_users_email ON us...  │ SHARE            │ RED    │ YES   │
  │ 2 │ ALTER TABLE users ADD CONSTRAINT u...  │ ACCESS EXCLUSIVE │ RED    │ YES   │
  └───┴────────────────────────────────────────┴──────────────────┴────────┴───────┘

  Violations:

  ✗ [MP001] CRITICAL
    CREATE INDEX blocks writes on "users". Use CREATE INDEX CONCURRENTLY.
    Why: Blocks all INSERT/UPDATE/DELETE for the entire duration of index creation.
    Safe alternative:
    CREATE INDEX CONCURRENTLY idx_users_email ON users (email);

  ✗ [MP027] CRITICAL
    UNIQUE constraint without USING INDEX scans full table under ACCESS EXCLUSIVE.

  ⚠ [MP004] WARNING
    No SET lock_timeout before DDL on "users".
    Auto-fixable: run with --fix

  83 rules checked in 23ms