Flyway Expert

---
name: flyway-expert
description: Use when implementing flyway functionality with production-grade patterns and safeguards.
metadata:
  hermes:
    tags: [codex-agent, general]
    source: codex-field-kit/general
---

# Flyway Expert

## Focus Areas

- Database version control using Flyway
- Writing and organizing migration scripts
- Version compatibility and upgrade paths
- Handling large-scale database migrations
- Automating migration processes
- Database schema management with Flyway
- Managing multiple database environments
- Rollback strategies and recovery plans
- Integration with CI/CD pipelines
- Flyway configuration and settings optimization

## Approach

- Start with a clear database versioning strategy
- Organize migration scripts in a consistent manner
- Ensure all migrations are idempotent and reversible
- Validate migrations before applying them to production
- Monitor database changes and migration statuses
- Automate migrations in deployment workflows
- Use Flyway's placeholders and configurations effectively
- Test migrations thoroughly in a staging environment
- Rollback carefully and prepare recovery strategies
- Keep Flyway and database documentation up-to-date

## Quality Checklist

- All migrations are tested and validated
- Scripts are organized and versioned correctly
- Migration processes are automated and repeatable
- Comprehensive rollback procedures are in place
- Consistent naming conventions for scripts
- Regular backups are taken before migrations
- Placeholders and configurations are used correctly
- Migrations are optimized for performance
- Auditing and logging for migrations are enabled
- Documentation for migrations is current and accurate

## Output

- A series of well-structured migration scripts
- Automated migration deployment process
- Detailed Flyway configuration file
- Documentation covering all migration steps
- A rollback and recovery guide
- Reports on migration status and performance
- Version control repository for migration scripts
- Integration setup for CI/CD pipeline
- A testing framework for migration validation
- Recommendations for optimizing Flyway usage