Prisma
prisma.io › home › reset › reset › reset
prisma migrate reset | Reset Database & Reapply Migrations | Prisma Documentation
The prisma migrate reset command resets your database and re-applies all migrations. For use in development environments only. This command is not supported on MongoDB. Use db push instead.
GitHub
github.com › prisma › prisma › issues › 11261
`prisma db reset` that resets the database, pushes the schema, and runs the seed function · Issue #11261 · prisma/prisma
January 19, 2022 - I looked at npx prisma db push --force-reset which does steps 1 and 2, but it doesn't run the seed function.
Author prisma
node.js - Make a change to the database with Prisma.js without having to reset the whole thing - Stack Overflow
The database is reset when: ... You call prisma migrate dev and Prisma Migrate detects drift in the database or a migration history conflict · I'm not sure why Prisma thinks that your change is breaking, but there is probably no other way to make schema change without data loss. To recreate your database data consider using seeding script · If you are prototyping, consider using the db push command... More on stackoverflow.com
Configuration to disallow database reset
Some configuration on the connection or something should exist to prevent this behaviour. If in the datasource there's a preserveDB or preventDBReset or something like it, prisma should never suggest to reset db when running any command besides prisma reset db and even then it should ask more ... More on github.com
15
October 13, 2023Easy workflow to reset all data
Problem There currently doesn't seem to be a way to easily reset a database. Suggested solution Provide a way to reset the database (via CLI, SDK, Studio). This should delete the database, re-c... More on github.com
27
October 13, 2019Add a `prisma.$reset()` function as shortcut to running `prisma migrate reset`
Problem prisma migrate reset is used heavily for testing. I want a prisma.$reset() function added to prisma client as super easy shortcut to reset the database. Suggested solution I've added th... More on github.com
9
January 21, 202102:11
Using the Prisma DB Pull Command - YouTube
08:45
Let's learn Prisma ORM: migrate in detail (seeding, down migration, ...
06:36
Prisma vs Drizzle: Using Prisma and Drizzle Migrate - YouTube
Mastering Prisma Migrations Made EASY
01:11:02
Deep dive into database workflows with Prisma - Alex Ruheni I Prisma ...
Medium
medium.com › @ayiaware › how-to-reset-your-postgresql-database-using-prisma-in-early-development-b36831b0f32b
How to Reset Your PostgreSQL Database Using Prisma in Early Development | by Daniel Ayia | Medium
September 14, 2025 - Reset the database to match the current schema. To simplify the reset process, you can create a custom script: "reset-db": "rm -rf prisma/migrations && npx prisma migrate dev --name init && npx prisma migrate reset --force"
Prisma
prisma.io › home › development and production › development and production › development and production › development and production
Development and production | Prisma Documentation
The migrate dev command will prompt you to reset the database in the following scenarios: Migration history conflicts caused by modified or missing migrations · The database schema has drifted away from the end-state of the migration history ...
GitHub
github.com › prisma › prisma › discussions › 23042
I need to reset my DB because my migrations are unhappy. Will I lose my authentication though? · prisma/prisma · Discussion #23042
run reset db command · user authentication tables are preserved · // Add your schema.prisma · // Add any relevant Prisma Client queries here · OS: Database: Node.js version: Run prisma -v to see your Prisma version and paste it · 1 · You ...
Author prisma
Prisma
prisma.io › home › prisma cli reference › prisma cli reference › prisma cli reference
Prisma CLI reference | Prisma Documentation
Drops the database/schema if possible, or performs a soft reset if the environment does not allow deleting databases/schemas · Creates a new database/schema with the same name if the database/schema was dropped ... This command is not supported on MongoDB. Use db push instead.
Basedash
basedash.com › home › blog › how to reset and seed a prisma database
How to reset and seed a Prisma database | Basedash
January 31, 2025 - With Prisma’s streamlined CLI and the seeding setup, you can make sure your development environment is always in a consistent state. Remember to exercise caution when resetting databases, especially in production environments, to avoid any unintended data loss.
Top answer 1 of 5
8
Go into your schema and make the change:
NormalizedName String @unique @db.VarChar(64)
NormalizedName String? @unique @db.VarChar(64)
Then create a draft migration:
$ npx prisma migrate dev --name migration-name --create-only
Then edit the migration in SQL (this allow null values ie optional)
ALTER TABLE myTable ALTER COLUMN myColumn {DataType} NULL;
OR Postgres
ALTER TABLE myTable ALTER COLUMN myColumn DROP NOT NULL;
etc.
Then apply the modified SQL:
$ npx prisma migrate dev
I hope this works for you :)
2 of 5
4
In a development environment, Prisma Migrate sometimes prompts you to reset the database. Resetting drops and recreates the database, which results in data loss. The database is reset when:
- You call
prisma migrate resetexplicitly - You call
prisma migrate devand Prisma Migrate detects drift in the database or a migration history conflict
I'm not sure why Prisma thinks that your change is breaking, but there is probably no other way to make schema change without data loss.
To recreate your database data consider using seeding script
If you are prototyping, consider using the db push command, although it will still result in data reset if Prisma considers that the change is breaking.
GitHub
github.com › prisma › prisma › issues › 21483
Configuration to disallow database reset · Issue #21483 · prisma/prisma
October 13, 2023 - If in the datasource there's a preserveDB or preventDBReset or something like it, prisma should never suggest to reset db when running any command besides prisma reset db and even then it should ask more ...
Author prisma
Fig
fig.io › manual › prisma › migrate › reset
prisma migrate reset | Fig
Reset your database and apply all migrations, all data will be lost
Prisma
prisma.io › home › troubleshooting › troubleshooting › troubleshooting › troubleshooting
Troubleshooting | Prisma Documentation
Database schema drift occurs when ... ... The database schema was changed without using migrations - for example, by using prisma db push or manually changing the database schema....
Dani Lucaci
danilucaci.com › blog › reset-and-seed-prisma-database
How to reset and seed a prisma.io database - Dani Lucaci
July 26, 2019 - If you already have inserted data in the database, and you want to make breaking changes to the schema, it is sometimes easier to just reset it entirely than trying to delete items one by one. Using the Prisma CLI it’s easy to do by running in the terminal:
GitHub
github.com › prisma › prisma › issues › 742
Easy workflow to reset all data · Issue #742 · prisma/prisma
October 13, 2019 - Problem There currently doesn't seem to be a way to easily reset a database. Suggested solution Provide a way to reset the database (via CLI, SDK, Studio). This should delete the database, re-create it from the schema and finally seed it...
Author prisma
Build with Matija
buildwithmatija.com › blog › solving-database-drift-in-postgresql-17-with-prisma-without-losing-data
Solving Database Drift in PostgreSQL 17 With Prisma Without Losing Data | Build with Matija
January 13, 2025 - Accidentally used prisma db push ... to reset your database? ... When working with Prisma, database migrations are a critical part of maintaining a consistent schema. However, during development, you might prefer a quicker approach and use the ...
GitHub
github.com › prisma › prisma › issues › 5230
Add a `prisma.$reset()` function as shortcut to running `prisma migrate reset` · Issue #5230 · prisma/prisma
January 21, 2021 - I've added this to our Blitz adapter and it's super nice in Jest tests: beforeEach(async () => { await db.$reset() }) Optionally this command could be disabled/fail if process.env.NODE_ENV === 'production' None ·
Author prisma
MCP Servers
mcpservers.org › home › agent skills library › prisma-cli-migrate-reset
prisma-cli-migrate-reset | Agent Skills Library
Complete reference for Prisma CLI commands, options, and workflows across setup, migrations, and database operations. Covers 20+ commands organized by priority: setup ( init ), generation ( generate ), development ( dev ), database operations ( db pull/push/seed/execute ), and migrations ( migrate dev/deploy/reset/status/diff/resolve ) Includes Prisma 7.x changes: new prisma.config.ts configuration file, removed flags ( --skip-generate , --skip-seed , --schema , --url ), and explicit...
Author prisma
Codú
codu.co › home › niall maher › how to reset and seed a prisma project
How to Reset and Seed a Prisma Project | by Niall Maher | Codú
February 19, 2024 - If you're okay with starting from scratch, prisma migrate reset will clean your database and reapply all your migrations from the top. This command is pretty much the "turn it off and on again" approach, wiping all data in your dev database.
GitHub
github.com › prisma › prisma › discussions › 19185
`prisma migrate dev` prompts me to reset my database, but I just baselined. · prisma/prisma · Discussion #19185
We need to reset the MySQL database "db_name" at "db_host:3306" Do you want to continue? All data will be lost. » (y/N) ... Confirmed the user has the correct permissions. Setting up an explicit shadow db connection url (didn't seem to make any difference). Change line endings on the init migration file before running npx prisma migrate resolve --applied 0_init (I am on a Windows and I thought maybe line endings was messing up the hash when appliying the migration or something)
Author prisma
Medium
medium.com › israeli-tech-radar › prisma-orm-are-you-seriously-offering-to-reset-my-production-db-really-aa99756099e2
Prisma ORM: Are You Seriously Suggesting I Reset My Production DB?! | by Nir Alfasi | Israeli Tech Radar | Medium
June 29, 2025 - Prisma ORM: Are You Seriously Suggesting I Reset My Production DB?! If you want to learn how to recover your DB after hitting a schema drift issue or any other scenario where Prisma threatens to …
Prisma
prisma.io › home › limitations and known issues › limitations and known issues › limitations and known issues › limitations and known issues
Limitations and known issues | Prisma Documentation
The prisma migrate dev and prisma migrate reset commands are designed to be used in development only, and should not affect production data.