create-migration

To generate a database migration file with Goose format, use this Skill to automatically create SQL scripts containing essential `-- +goose Up` and `-- +goose Down` annotations. It enforces consistent file naming and standardizes schema changes for microservices.

The standard way to add a new table column using a SQL migration is by generating Up and Down statements. This Skill creates the migration file and guides you on updating GORM models and repository interfaces to reflect the schema modification.

Yes, this migration generator supports UUID primary keys and soft deletes. It enforces project-specific patterns for these fields and provides best practice guidance for timestamps, foreign keys, and JSONB fields in the generated SQL.

Yes, you can create indexes concurrently in your database schema migrations. The Skill provides specific examples and explanations for defining indexes using the `CONCURRENTLY` option within the generated Goose Up and Down SQL statements.

The best way to manage database schema changes across microservices is by enforcing standardized naming conventions and structured annotations. This Skill streamlines that process by generating compliant SQL migration files and guiding updates to your CHANGELOG.md.

To update GORM models after creating a new SQL migration, follow the guidance provided by the Skill upon file generation. It outlines the necessary steps to align your repository interfaces and GORM structures with the newly applied database schema changes.