Database Migrations

Tonnex uses Drizzle Kit for database migrations, with schemas defined as TypeScript in packages/db/src/schema/.

Development Workflow

During development, use db:push for rapid iteration:

# Push schema changes directly (no migration files)
pnpm db:push

Production Workflow

For production, generate and apply migration files:

# 1. Generate migration SQL from schema changes
pnpm db:generate

# 2. Review the generated SQL in packages/db/drizzle/

# 3. Apply migrations
pnpm db:migrate

Drizzle Studio

Inspect your database visually:

pnpm db:studio

Opens at https://local.drizzle.studio.