spring-migration

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.