Database DevOps and Schema Migration

Help me implement database DevOps for my application.

Database details:
- Database type: [PostgreSQL/MySQL/MongoDB/etc.]
- Environments: [dev/staging/prod]
- Migration tool: [Flyway/Liquibase/Alembic/custom]
- CI/CD platform: [GitHub Actions/GitLab/Jenkins]

Requirements:
1. Schema migration
   - Version control for schemas
   - Migration scripts structure
   - Rollback capabilities
   - Data migrations

2. CI/CD integration
   - Migration in pipeline
   - Pre-deployment validation
   - Environment-specific handling
   - Approval gates for production

3. Safety measures
   - Migration testing
   - Backward compatibility checks
   - Lock management
   - Large table migrations

4. Operations
   - Migration history tracking
   - Drift detection
   - Emergency rollback procedures
   - Database seeding

Include:
- Migration tool configuration
- CI/CD pipeline integration
- Example migrations
- Operational runbooks