Need help: All data suddenly disappeared from all tables despite no reset or destructive action

[jlpt-server-storage]

I’m reporting a critical issue:
All data in all tables of my Supabase project suddenly disappeared, even though the project was still active and functioning normally.

---

📌 Project Details:

• Plan: Free
• Connected backend: Strapi (no destructive DB logic)

---

🧾 What happened:

• My project was running normally. I did not delete or reset the database.
• No one in the team initiated a destructive action.
• No scheduled scripts exist that could remove data.
• After a normal request from the frontend returned empty results, I checked the database in the dashboard and found that:
  • All tables are still there (schema intact).
  • All data is gone from every table.
  • RLS is disabled.
• I checked the PostgreSQL logs and found no DELETE, DROP, or TRUNCATE commands.

---

❓ What I need:

• Can you confirm what could have caused this data loss?
• Is there any way to recover the data from Supabase’s internal backups?
• Can this happen to active projects on Free plan without warning?

---

This is a severe incident. I’m happy to upgrade my plan if needed to restore the data, but I need confirmation on whether it’s possible and what happened.

Thanks for looking into this.

[GaryAustin1]

You need to contact support if you want someone to look at your project.
No Supabase does not delete your data and there is no known issue with that happening.
You can look at the the Audit logs to potentially see what happened.

Users have upgraded to Pro and have available the last 7 days of daily backups even while the plan was free. That is a $25 minimum commit.

[is-qeads]

It happened to me too. I had the db seeded and was able to use the data and then next morning I didnt have the data anymore. I am using the free plan as I am testing it

[wamaithaNyamu]

Just experienced this today as well. No backend logic had been changed. @jlpt-server-storage how did you solve this?

[stubbsyy]

Same here

[jdeykin]

This also just happened to me. Everything was there last night, and now everything is gone

[GaryAustin1]

Do you use an AI for code development? I've seen a couple of users say an AI is running supabase db reset --linked which wipes all data...

Otherwise getting a backup or contacting support are your options.

[jdeykin]

That seems to be 100% correct. Wasn’t doing a db reset, but for some reason Cursor decided to add code to the regression suite that dropped every table. Luckily was just testing stuff, but wow … that’s a new one.

…

On Thu, Jul 17, 2025 at 8:03 PM GaryAustin1 ***@***.***> wrote: Do you use an AI for code development? I've seen a couple of users say an AI is running supabase db reset --linked which wipes all data... Otherwise getting a backup or contacting support are your options. — Reply to this email directly, view it on GitHub <#34773 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACLZC4VXNHCTEIJ633LOB7D3JA2UPAVCNFSM6AAAAAB2RVO3XOVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGNZZHEZTKNA> . You are receiving this because you commented.Message ID: ***@***.***>

[synsyst]

Yeah happened to me too - test script written by agent injected a drop all tables, didn't tell me, a thing of relative importance I'd think hehe

[julien-zgh]

it just happened to me. I was working normally on my project when suddenly after a small refresh no data on the web. Restarted the server still same issue. Went into supabase table and found that there is nothing in them 9 tables are now empty.
Did anyone find any solution how to get data back?

Table did not get dropped, but emptied. It's like I have just created the tables.
did you find a solution?

[stubbsyy]

Adding SQLite for a local database for tests seems to have fixed this for me.

[julien-zgh]

it just happened to me. I was working normally on my project when suddenly after a small refresh no data on the web. Restarted the server still same issue. Went into supabase table and found that there is nothing in them 9 tables are now empty.
Did anyone find any solution how to get data back?

[stubbsyy]

See my reply above. When I was using an ai agent it seemed it created tests that would delete my database. Have it use SQLite for local tests.

[wamaithaNyamu]

@julien-zgh my tables reappeared later. In my case I was not even using any AI agents accessing the db. Also make sure you're checking the tables in the right schema on supabase.

[julien-zgh]

made sure that i am checking tables in right schema
and same thing i am not using any ai agents that are accessing the db

[stubbsyy]

See my reply above. When I was using an ai agent it seemed it created tests that would delete my database. Have it use SQLite for local tests.

[julien-zgh]

I emailed the support team and got the following

Is it guaranteed that support team will respond if I have purchased a plan?

[stubbsyy]

See my reply above. When I was using an ai agent it seemed it created tests that would delete my database. Have it use SQLite for local tests.

[DeprecatedLuar]

I just lost about 3gb of data of my SaaS project after it got paused.

Just restored it to move some important stuff that I couldn't afford to lose into my self hosted postgres and literally all tables vanished.

Funny enough my project got paused even though my system constantly reads and writes to it

I messaged the support but I don't have high hopes, probably never touching supabase ever again after this, I literally lost over 10 months of work

Not even the tables were preserved, only my custom triggers and automations

[stubbsyy]

See my reply above. When I was using an ai agent it seemed it created tests that would delete my database. Have it use SQLite for local tests.

[DeprecatedLuar]

I did not have an AI agent writing to the database, it had actual production data and is literally empty now.

[stubbsyy]

Are you using an ai agent at all?

[DeprecatedLuar]

Nope, It's all mechanical automation and no queries for deletion

[Balta123]

Are you using an ai agent at all?

Can we recover Migration with backups?

[leonatopl]

I'm not the only one. Supabase is not a reliable solution. I see how many people are in the same situation I am.

[LoordhuJeyakumar]

Hit something similar a while back a restore that looked fine but wasn't, and no way to know until it actually mattered. I'm building a small tool that backs up Supabase projects and then actually restores them on a schedule to prove the backup is good, instead of just assuming a scheduled backup means you're safe. Still early. If that's something you'd want to try once it's ready, happy to add you to an early access list no pitch, just trying to figure out if this is worth building for people who've actually hit this.