go-migration-gen

You can generate golang-migrate compatible SQL migration files directly from Go structs. The skill translates struct fields into PostgreSQL schema definitions, automatically applying NOT NULL constraints, indexes, and soft delete columns while generating matching Up and Down SQL statements.

Mapping Go types to PostgreSQL data types in a SQL migration is handled automatically by this skill. When translating Go domain structs, it applies correct PostgreSQL type mapping rules to ensure database columns accurately match your application struct field definitions without manual conversion.

Yes, you can automatically add soft delete columns and indexes when creating SQL migrations from Go structs. The skill detects your struct configuration and automatically includes soft delete columns, applies indexes, and enforces NOT NULL constraints within the generated golang-migrate SQL files.

Yes, this SQL generation skill supports rollback migrations for PostgreSQL by generating matching Down migration files. Alongside the Up migration that creates your tables, it outputs the corresponding Down SQL statements required to reverse the schema changes using golang-migrate.

To update your Makefile with new golang-migrate targets after generating SQL files, leverage the skill's Makefile integration feature. It automatically injects the necessary migration targets into your Makefile, streamlining the execution of database schema evolution commands for your Go microservices.