© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•9mo ago•
4 replies
paske

weird __drizzle_migrations row id (move from `drizzle-kit push` to `drizzle-kit migrate`)

tl;dr: how is the starting id defined when running
drizzle-kit migrate
drizzle-kit migrate
? i though it was the migration filename id but it doesn't seem to be.

i had to forego the described challenge in the title. seemed trivial, but i found a few pitfalls in the dx.

i tried to manually create the rows in the drizzle table but the it's unclear how the index is defined. i had 10 migrations: locally, the id started in
25
25
. in my remote db, it started in
4
4
.

i worked my way around it by setting
SELECT 1;
SELECT 1;
temporarily in my migration files so the
drizzle-kit migrate
drizzle-kit migrate
command would fill the
__drizzle_migrations
__drizzle_migrations
table; although the hash doesn't match the contents it doesn't matter because the command uses the index.
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Drizzle-kit migrate
Drizzle TeamDTDrizzle Team / help
2y ago
drizzle-kit push from JS
Drizzle TeamDTDrizzle Team / help
2y ago
drizzle-kit push
Drizzle TeamDTDrizzle Team / help
5mo ago
Drizzle Kit Push & Generate gives weird error
Drizzle TeamDTDrizzle Team / help
3y ago