This documentation is for a legacy version of Next.js and Supabase. For the latest version, please visit the Next.js and Supabase V2 documentation
DocumentationNext.js and Supabase

How to reset your local Database

Learn how to reset the seed data in your Supabase Database

Resetting the DB can be useful when updating the schema of your database using the SQL schema files instead of the Supabase Studio UI.

To reflect the new changes, and/or resetting the database to the local seed, run the following command:

npm run supabase:db:reset

The database is now in the same state as when you started your Supabase server.

Important: users created during the session will be reset, which means your application may be in a conflicting state. Log out or delete the cookies to restart from scratch.