What problem does it solve?
Manually writing Flyway migration scripts for Spring Boot + PostgreSQL projects often leads to inconsistent naming, missing safety guards, and schema errors that cause deployment failures or production downtime.
Core Features & Use Cases
- Strict Naming Convention Enforcement: Automatically generates migration files that follow the required V{version}__{description}.sql format, eliminating common naming mistakes.
- Safe SQL Pattern Templates: Provides pre-vetted templates for all common schema change operations (table creation, column additions, indexes, enums, junction tables) that include mandatory audit columns, foreign key constraints, and idempotency guards.
- Use Case: For example, if you need to add a non-nullable
phone_number column to an existing users table, this skill generates the correct 3-step backfill migration to avoid breaking existing data.
Quick Start
Use the spring-migration skill to generate a production-safe Flyway migration script that adds a last_login timestamp column to the users table with a NOT NULL constraint and a corresponding index for query performance.