Urgent Help Needed: Lost Data After Foreign Key Changes (No Manual Backup)
I’m in a bit of a panic with my Supabase project and could really use some help. I’m not a developer and built my app using AI tools, so I don’t have much technical experience.
I applied several foreign key constraints across different tables in the database, and after that, things started going wrong. A lot of data stopped showing up, and several parts of my app are broken. For example, the bus listings no longer appear, and the accounts payable section has disappeared from the frontend.
The problem began right after these changes, and I have no idea how to fix it. I’ve never manually backed up my database, so I don’t have a recent backup to restore from.
Is there any way to restore my database to a previous state or undo the changes I made? Any advice or solutions would be greatly appreciated, as I’m really stuck here and don’t want to lose everything.
Thank you so much for your help!
1 Reply
if you are on a pro plan then you can get backups going database -> backups in supabase
if you are in a free plan i believe you can get 7 days worth of backups going to the pro plan but free plans do not have access to backups