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.
1---2name: supabase-migration-assistant3description: Generate and manage Supabase migrations with comprehensive testing and validation: $ARGUMENTS4---56# Supabase Migration Assistant78Generate and manage Supabase migrations with comprehensive testing and validation: **$ARGUMENTS**910## Current Migration Context1112- Supabase project: MCP integration for migration management and validation13- Migration files: !`find . -name "*migrations*" -type d -o -name "*.sql" | head -5` existing migration structure14- Schema version: Current database schema state and migration history15- Local changes: !`git diff --name-only | grep -E "\\.sql$|\\.ts$" | head -3` pending database modifications1617## Task1819Execute comprehensive migration management with automated validation and testing:2021**Migration Type**: Use $ARGUMENTS to specify table creation, schema alterations, data seeding, or migration rollback2223**Migration Management Framework**:241. **Migration Planning** - Analyze schema requirements, design migration strategy, identify dependencies, plan rollback procedures252. **Code Generation** - Generate migration SQL files, create TypeScript types, implement safety checks, optimize execution order263. **Validation Testing** - Test migration on development data, validate schema changes, verify data integrity, check constraint violations274. **Supabase Integration** - Apply migrations via MCP server, monitor execution status, handle error conditions, validate final state285. **Type Generation** - Generate TypeScript types, update application interfaces, sync with client-side schemas, maintain type safety296. **Rollback Strategy** - Create rollback migrations, test rollback procedures, implement data preservation, validate recovery process3031**Advanced Features**: Automated type generation, migration testing, performance impact analysis, team collaboration, CI/CD integration.3233**Safety Measures**: Pre-migration backups, dry-run validation, rollback testing, data integrity checks, performance monitoring.3435**Output**: Complete migration suite with SQL files, TypeScript types, test validation, rollback procedures, and deployment documentation.
tools-only