Manage database schema changes through versioned Flyway migrations.
npx skills add https://github.com/GreenFirst-kr/green_first_be --skill flyway
Please help me install this Agent Skill. Skill: flyway Source: https://github.com/GreenFirst-kr/green_first_be/tree/main/.claude/skills/flyway Command: npx skills add https://github.com/GreenFirst-kr/green_first_be --skill flyway
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.
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.
High-intent search queries and answers about installing and using this skill.
To manage schema changes, create a new SQL migration under src/main/resources/db/migration and run your build or tests. This validates the migration against configured Flyway rules and ensures consistent, repeatable deployments.
Flyway validation fails on checksum mismatches when an already-applied migration file is modified. You can fix this by following profile-scoped auto-repair rules or creating a new migration file instead of editing existing ones.
The safe backfill pattern for NOT NULL columns requires documenting a multi-step migration process to populate existing rows before applying the NOT NULL constraint, ensuring no data is lost during schema updates.
Yes, you need to set ddl-auto=validate to maintain strict schema governance. This guarantees consistent, repeatable deployments across environments by ensuring Hibernate validates the schema without applying automated changes.
No, Flyway enforces immutable migrations to prevent editing applied files. You must create a new migration for every schema change to maintain auditable, reproducible environments and avoid validation failures.
To set up a baseline migration for a clean environment, configure Flyway to establish a baseline version, allowing new migrations to apply sequentially while maintaining strict migration discipline across the database.
takemo101Configure containerized technology stacks and test database migrations with Flyway, Prisma, and Alembic.
wojonsTest database schemas, migrations, and data integrity with automated scripts.
RevealUIStudioCoordinate Drizzle ORM migrations across NeonDB and Supabase schemas.
inbharataiGenerate up/down database migration scripts for Alembic, Flyway, and Liquibase.
