hyp migrate_en.md

hyp migrate — Database Migration Tools

Scan Go Model structs (bun ORM tags), compare with snapshots, auto-generate up/down SQL migrations.

Usage

hyp migrate diff                    # PostgreSQL migration
hyp migrate diff --dialect mysql    # MySQL migration
hyp migrate diff -o db/migrations/  # Custom output directory
hyp migrate snapshot                # Save current schema snapshot

Subcommands

diff

Compare current models with snapshot, generate SQL migration files.

Flag	Description	Default
-d, --dialect	SQL dialect: postgres or mysql	postgres
-o, --output	Output directory	migrations/
-s, --snapshot	Snapshot file path	.hyp/schema_snapshot.json

Detected change types: AddTable, DropTable, AddColumn, DropColumn, AlterColumn

Supported bun tags: pk, autoincrement, notnull, unique, type, default

snapshot

Save current model schema as baseline for future diffs.

Flag	Description	Default
-s, --snapshot	Snapshot file path	.hyp/schema_snapshot.json

Workflow

# 1. Define/modify model structs (with bun tags)
# 2. Generate migration
hyp migrate diff
# 3. Review generated SQL
# 4. Apply SQL to database
# 5. Snapshot auto-updated after diff

Related Commands

• hyp generate model — Generate model with bun tags

Detailed Documentation

• migrate.md