Supabase app connected but returns empty data

Everything seems to work… until it suddenly doesn’t.

If you're building with tools like Lovable, everything can feel smooth at first.

You see your tables in the dashboard.
You can insert data.
The app looks “connected”.

Then suddenly:

• your app returns empty data
• or users see everything
• or auth just… stops behaving

And it feels like something is randomly broken.

In most cases, it’s not random at all.

What’s actually happening is that your app can reach the database — but it doesn’t have permission to access the data the way you expect.

The most common causes I keep seeing:

• RLS (row-level security) blocking access
• user session not being passed correctly
• mismatch between your user ID and what the database expects
• or the app pointing to a different Supabase project

Quick check you can try:

Log the current user ID in your app and compare it to what’s stored in your table.

If they don’t match → your app will return empty results every time.

This is one of those issues that looks like “Supabase is broken”, but it’s usually just a small mismatch between auth and data.

If you’re stuck on something like this, feel free to share what you’re seeing — these are often fixable once you know where to look.