create-migration

To generate a Flyway migration file, invoke /create-migration with a descriptive name. It automatically creates a V{timestamp}__{name}.sql file in the correct db/migration directory for your single-module or multi-module Java project.

Flyway timestamp-based naming assigns a unique timestamp to each migration file name, ensuring migrations are ordered chronologically. This prevents naming conflicts and maintains a clear sequence of database schema changes.

Yes, this works with multi-module Java projects. It automatically locates the correct db/migration directory based on your project type, creating the folder if it is missing, and adds the timestamped SQL migration file.

The best way to structure a SQL database migration is to use a template with updatable sections. This skill generates a migration file with a guided template to help you design your database schema changes effectively.

No, you do not need to manually create the db/migration directory. The migration generation process determines the correct project path and automatically creates the missing folder structure for your Flyway SQL files.