Database Migrations

Migrations keep SQL schema changes versioned with the app.

Common Commands

Generate a migration:

./myxa make:migration create_posts_table --create=posts

Run pending migrations:

./myxa migrate

Show status:

./myxa migrate:status

Rollback:

./myxa migrate:rollback --step=1

The migration repository table is created automatically if it does not exist.

Snapshot the current schema:

./myxa migrate:snapshot

Compare a live table to the stored snapshot:

./myxa migrate:diff users
./myxa migrate:diff users --write

Generate a create migration from an existing table:

./myxa migrate:reverse users

This is useful when adopting an existing database into the migration workflow.

Generate from a live table:

./myxa make:model App\\Models\\AuditLog --from-table=audit_logs

Generate from a migration file:

./myxa make:model App\\Models\\AuditLog --from-migration=2026_04_17_120000_create_audit_logs_table.php

Use generated models as a starting point, then review property types, casts, guarded fields, and hidden fields before treating them as final.