Migrations

VeloxTS uses Prisma for database migrations.

Development Workflow

Push Schema (Development)

pnpm db:push

Syncs schema to database without creating migration files. Fast for prototyping.

Create Migration (Production)

pnpm prisma migrate dev --name add_users_table

Creates a migration file for the schema change.

CLI Commands

Command	Description
velox migrate status	Show migration status
velox migrate run	Run pending migrations
velox migrate rollback	Rollback last migration
velox migrate fresh	Drop all tables and re-run
velox migrate reset	Rollback all then re-run

Rollback Support

VeloxTS generates down.sql files for rollbacks:

velox make migration add_status_to_orders

Creates:

prisma/migrations/
└── 20240115_add_status_to_orders/
    ├── migration.sql  # Up migration
    └── down.sql       # Rollback migration

Production

# Deploy migrations
pnpm prisma migrate deploy

Next Steps

• Seeding - Test data
• Prisma 7 Setup - Configuration