Migration Strategies
Pack:
drizzle-ormParent skill: Drizzle ORM Migrations and Drizzle Kit Source:drizzle-orm/drizzle-orm-migrations-and-drizzle-kit/references/migration-strategies.md
Read this when
Section titled “Read this when”- deciding between
push, generated SQL migrations, introspection, or export - setting up
drizzle.config.ts - handling team migration conflicts
Strategy selection
Section titled “Strategy selection”generate+migrate: best when you want SQL files, reviewability, and durable team history.push: best for fast local iteration or environments where you intentionally skip migration files.pull: best when an existing database is the source of truth and you want Drizzle schema from introspection.export: best when Drizzle defines schema but another tool executes or manages migrations.
Team workflow cues
Section titled “Team workflow cues”- Use
checkto detect migration-history consistency problems across branches. - Keep separate config files for separate DBs or stages.
- Keep schema exports complete so Drizzle Kit sees the whole intended model.
Beta/v1 upgrade notes
Section titled “Beta/v1 upgrade notes”drizzle-kit upupgrades older snapshot formats.- The v1 upgrade guide explicitly calls out the new migration-folder structure and validator import moves.
- The upgrade docs also note that MySQL schemas/databases are no longer handled by Drizzle Kit in the migration flow.
Source map
Section titled “Source map”https://orm.drizzle.team/docs/migrationshttps://orm.drizzle.team/docs/kit-overviewhttps://orm.drizzle.team/docs/drizzle-config-filehttps://orm.drizzle.team/docs/kit-migrations-for-teamshttps://orm.drizzle.team/docs/kit-web-mobilehttps://orm.drizzle.team/docs/upgrade-v1