drizzle-migrations

Set up Drizzle ORM migrations by configuring drizzle.config.ts with your Neon PostgreSQL connection, defining your schema in schema.ts, then running drizzle-kit generate to create migration files. Review the generated SQL in the drizzle/ directory before applying migrations with push for development or migrate for production.

Drizzle migrations follow a three-step workflow: modify your schema.ts file, run drizzle-kit generate to produce SQL migration files, then apply them using push in development environments or migrate in production. This keeps your database schema in sync with your TypeScript type definitions.

Yes, Drizzle ORM migrations work with Neon PostgreSQL for complete schema management. You define tables and relations in schema.ts, generate migrations automatically, review the SQL output, and apply changes to development or production environments while maintaining type safety.

Review the generated SQL files in drizzle/ before applying migrations to catch errors early. Common issues include schema mismatches between schema.ts and the database or incomplete relation definitions. Always test migrations in development before deploying to production.

Drizzle ORM supports standard PostgreSQL patterns for common tables and relational structures. Define schemas in schema.ts using type-safe helpers and relation scaffolding, then generate migrations that handle foreign keys, constraints, and table modifications automatically.