drizzle-migration

To generate and apply Drizzle migrations, run Drizzle Kit to produce SQL files from your TypeScript schema, review the SQL for safety, execute bun run db:migrate with DATABASE_URL, and verify the database state via Drizzle Studio.

The safest way to review Drizzle Kit SQL is to inspect the generated migration files directly to confirm intended changes and prevent accidental table drops or incorrect foreign keys before executing bun run db:migrate.

PostgreSQL database schema drift occurs when TypeScript schema files change but the corresponding Drizzle migrations are not generated and applied, requiring you to run Drizzle Kit to reconcile the database state.

Yes, you can use Bun to execute Drizzle database migrations for PostgreSQL by running bun run db:migrate with the DATABASE_URL environment variable set to apply pending SQL changes.

You verify database changes after applying a Drizzle migration by using Drizzle Studio to confirm that tables, indexes, and constraints in the target PostgreSQL database match the expected results.

Yes, Drizzle Kit supports SQLite schema migrations, allowing you to generate SQL from TypeScript schema files to reconcile database state for both PostgreSQL and SQLite targets.