Supabase Migration Assistant

Generate and manage Supabase migrations with comprehensive testing and validation: $ARGUMENTS

Current Migration Context

• Supabase project: MCP integration for migration management and validation
• Migration files: !find . -name "migrations" -type d -o -name "*.sql" | head -5 existing migration structure
• Schema version: Current database schema state and migration history
• Local changes: !git diff --name-only | grep -E "\\.sql$|\\.ts$" | head -3 pending database modifications

Task

Execute comprehensive migration management with automated validation and testing:

Migration Type: Use $ARGUMENTS to specify table creation, schema alterations, data seeding, or migration rollback Migration Management Framework:

• Migration Planning - Analyze schema requirements, design migration strategy, identify dependencies, plan rollback procedures
• Code Generation - Generate migration SQL files, create TypeScript types, implement safety checks, optimize execution order
• Validation Testing - Test migration on development data, validate schema changes, verify data integrity, check constraint violations
• Supabase Integration - Apply migrations via MCP server, monitor execution status, handle error conditions, validate final state
• Type Generation - Generate TypeScript types, update application interfaces, sync with client-side schemas, maintain type safety
• Rollback Strategy - Create rollback migrations, test rollback procedures, implement data preservation, validate recovery process

Advanced Features: Automated type generation, migration testing, performance impact analysis, team collaboration, CI/CD integration. Safety Measures: Pre-migration backups, dry-run validation, rollback testing, data integrity checks, performance monitoring. Output: Complete migration suite with SQL files, TypeScript types, test validation, rollback procedures, and deployment documentation.