Help Needed to Recover Deleted Tables in Supabase

Hi everyone,

I connected my Supabase database to Prisma recently and accidentally ran npx prisma migrate dev without defining any models in my schema.prisma file. As a result, all my existing tables in Supabase were deleted.

I’d like to know:

Is there a way to restore the deleted tables in Supabase?
Are there any automated backups in Supabase that I can use to recover my data?
Can I retrieve the SQL queries for the original table creation from the SQL history or logs?
Here are the details:

What happened: Prisma migration deleted all tables in my Supabase database.
What I need: A way to recover the original schema and data.
Any guidance or tips would be greatly appreciated. Thanks in advance!

Best regards
Was this page helpful?