Use when you need to add or review Flyway database migrations in a Spring Boot application — Maven dependencies, db/migration scripts, spring.flyway.* configuration, baseline and validation, and alignment with JDBC or Spring Data JDBC. This should trigger for requests such as Add or review Flyway migrations in a Spring Boot project; Configure spring.flyway or db/migration layout; Add versioned Flyway SQL migrations for Spring Boot; Review Spring Boot database migration ordering; Fix repeatable F
NewMaintained
Automatic
◆Coding pack
Last verified 8/20/2026
What it changes
Passed 13 of 18 test cases with the skill, and 16 of 18 without it.
Without skill87%
With skill74%
Checks it passed that the model alone missed
Halts operation immediately if project compilation fails.
1 fixed16 passed either way2 still failing4 broke
Pass-rate lift
-13 pp
Tokens
+36%
Agent turns
0%
Response time
-21%
Model gemini-3.6-flashMeasured 8/20/2026v117 of 23 cases passed with skill · 18 comparable
Tokens, turns and time describe resource use, not a dollar price.
See it in action
A test case the skill fixed. Same model, same prompt, with and without the skill.
Prompt
We have drafted a Flyway SQL migration script to add a foreign key constraint. Before we apply this migration or write further code, what mandatory compilation step must be run according to standard safe workflow constraints in a Maven-based project?
What was checked, without and with the skill
Checked
Without skill
With skill
Requires executing `./mvnw compile` or `mvn compile` before applying migration changes.
Passed
Passed
Halts operation immediately if project compilation fails.
Missed
Passed
case-10 · gemini-3.6-flash · 8/20/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md62 lines4 files
Spring — Database migrations (Flyway)
Apply Flyway migration guidelines for Spring Boot.
What is covered in this Skill?
flyway-core and database-specific Flyway modules (e.g. PostgreSQL) with Spring Boot BOM
Versioned SQL under src/main/resources/db/migration (V{version}__{description}.sql)
Optional Java migrations (BaseJavaMigration) for data backfills
Forward-only discipline: do not rewrite applied migrations in shared environments
Parallel Change as the safe expand, migrate, contract workflow for breaking or data-sensitive schema changes
Coordination with @311-frameworks-spring-jdbc and @312-frameworks-spring-data-jdbc
Scope: Apply recommendations based on the reference rules and good/bad examples.
Constraints
Before applying Flyway or SQL changes, ensure the project compiles. After improvements, run full verification.
MANDATORY: Run ./mvnw compile or mvn compile before applying any change
SAFETY: If compilation fails, stop immediately
VERIFY: Run ./mvnw clean verify or mvn clean verify after applying improvements
BEFORE APPLYING: Read the reference for detailed rules and good/bad patterns
BREAKING CHANGE REVIEW: Before recommending or applying a migration, assess whether it can break deployed application versions, dependent services, reports, jobs, or production data interpretation; if yes, require explicit human review before proceeding
EDGE CASE: If the user goal is ambiguous, stop and ask a clarifying question before editing files or running project-wide commands
EDGE CASE: If required context, files, credentials, or tools are missing, report the blocker explicitly and ask whether to proceed with setup or fallback guidance
EDGE CASE: If requested changes conflict with project constraints or safety boundaries, explain the conflict and ask for user confirmation on the preferred trade-off
When to use this skill
Add or review Flyway migrations in a Spring Boot project
Configure spring.flyway or db/migration layout
Add versioned Flyway SQL migrations for Spring Boot
Review Spring Boot database migration ordering
Fix repeatable Flyway migrations in a Spring project
Use when you need to add or review Mongock MongoDB data migrations in a Spring Boot application — including Maven coordinates, Spring Data MongoDB drivers, migration scan packages, @ChangeUnit classes, lock/transaction settings, and optional policy-approved MongoDB integration verification. This should trigger for requests such as Add Mongock migrations in Spring Boot; Review Spring MongoDB data migrations; Configure Mongock change units for Spring Data MongoDB; Create Mongock change units for S