Migrations

Migrations help you apply changes to your database schema in a controlled and trackable way.
Whenever you update your schema using Drizzle, migrations make sure those changes are reflected in your actual database.

Instead of editing your database manually, you generate a migration file and run it — ensuring your schema is always in sync across environments.

Generating migrations

Whenever you make changes to your database schema, you need to generate a migration file, you can do this by running the following command:

pnpm db:generate

This will generate migrations files in the server/database/migrations directory.

Applying migrations

These files are not applied automatically, you need to apply them manually.

"db:migrate": "drizzle-kit migrate",
"db:push": "drizzle-kit push",

Here drizzle-kit migrate applies SQL migrations generated by drizzle-kit generate, while drizzle-kit push directly applies schema changes to the database without generating migration files, making it suitable for rapid prototyping and local development.

NuxtHub Migrations

Migrations in NuxtHub are applied automatically, you don't need to worry about it. Read more about NuxtHub Migrations here.