api-migration-verifier

Purpose

Verifies database migrations are safe, reversible, don't lose data, include proper indexes, and follow multi-tenancy patterns.

Responsibilities

1. Safety Checks

   • Check for destructive operations (DROP, ALTER)
   • Verify rollback SQL is present
   • Check for data loss risks
   • Validate foreign key dependencies

2. Performance Analysis

   • Check for missing indexes
   • Identify slow operations
   • Suggest index additions
   • Validate composite indexes for tenant queries