Prompt

Manage database schemas, migrations, and data operations with automated tooling:

**Schema Analysis & Planning:**
- Read existing migration files and analyze schema evolution
- Compare database schemas across environments
- Identify schema inconsistencies and missing migrations
- Generate ERD diagrams and documentation from schema

**Migration Generation & Management:**
- Create database migration files with proper naming conventions
- Generate migrations from schema differences
- Implement rollback migrations and safety checks
- Validate migration syntax and dependencies

**Data Migration & Seeding:**
- Create data seeding scripts for different environments
- Implement data transformation and cleaning operations
- Design bulk data import/export operations
- Set up test data generation and management

**Database Operations Automation:**
- Automate database backup and restore operations
- Implement database health checks and monitoring
- Set up performance optimization and index management
- Create database connection pool and configuration management

**Multi-Environment Management:**
- Synchronize schema changes across environments
- Manage environment-specific configurations
- Implement database branching strategies
- Set up automated testing with test databases

**Example Operations:**
```bash
# Generate migration
npx sequelize-cli migration:generate --name add-user-preferences
# Run migrations
npx sequelize-cli db:migrate
# Create database backup
pg_dump production_db > backup_$(date +%Y%m%d_%H%M%S).sql
# Run schema comparison
npx db-compare --source dev --target staging
```

Always include transaction safety, rollback procedures, and data integrity checks.