@apilium/migration-gen

Database migration generation skill for Mayros -- generate migration files with rollback support for Prisma, Drizzle, Knex, Flyway, golang-migrate, and raw SQL.

Installation

Copy this skill directory into your Mayros skills folder:

cp -r skills/migration-gen ~/.mayros/skills/migration-gen

Or install via the Mayros CLI:

mayros skill install @apilium/migration-gen

Usage

Once configured, the agent can:

• Prisma: Generate schema models and run prisma migrate dev
• Drizzle: Define tables with drizzle-orm and run drizzle-kit generate
• Knex: Create migration files with knex migrate:make and manage with knex migrate:latest / knex migrate:rollback
• Raw SQL: Generate versioned SQL files for Flyway (V001__description.sql) or golang-migrate (000001_description.up.sql / 000001_description.down.sql)
• Rollback: Every migration includes a corresponding down/rollback migration
• Common operations: Create table, add column, drop column, rename column, add index, add foreign key, change column type, add constraint

Example prompts

"Generate a Prisma migration for a users table with email and name"
"Create a Knex migration to add a phone column to the users table"
"Write up and down SQL migrations for a posts table with foreign key to users"
"Generate a Drizzle schema for an orders table"
"What's the best practice for migration rollback in production?"

Semantic Predicates

| Predicate | Scope | Description | |-----------|-------|-------------| | migration:generated | agent | Migrations generated by the agent | | migration:rollback_verified | agent | Rollback migrations that have been verified | | migration:history | namespace | Migration history across the namespace |

License

MIT