flyway

What problem does it solve?

This skill enforces a disciplined approach to database schema changes by ensuring all modifications are tracked as Flyway migrations, preventing edits to already-applied migrations, and preserving reproducible environments through ddl-auto=validate.

Core Features & Use Cases

• Enforces migration discipline by requiring new migrations for every change instead of modifying existing files.
• Maintains strict schema governance with ddl-auto=validate to guarantee consistent, repeatable deployments across environments.
• Provides safe backfill guidance for NOT NULL changes and clearly documents repair workflows for development and testing.
• Documents end-to-end migration workflow: scope identification, creation of new migrations, backfill planning, and validation before deployment.

Quick Start

Create a new SQL migration under src/main/resources/db/migration and run your build or tests to validate the migration against the configured Flyway rules.