#17 most commondatabaseLovableBolt.newCursorWindsurfv0

Query returns empty [] with no error (but the table has data)

supabase.from('posts').select() returns { data: [], error: null } even though the table has rows.

Got a slightly different error? Paste the exact message and get a fix prompt tailored to it.

Paste your error →

What it means

Your data is there, but the security rules don't let this user see it, so the database quietly answers 'nothing' instead of showing an error.

How to fix it: paste this prompt into your AI builder

Fix prompt for Lovable, Bolt, Cursor, v0, Windsurf
My Supabase query returns an empty array with no error even though rows exist. Check whether RLS is enabled on the table and whether there is a SELECT policy that matches the current user (and that the user is actually logged in when the query runs). Add the correct SELECT policy as a migration (e.g. USING (auth.uid() = user_id), or a public read policy only if the data is meant to be public). Also verify the query filters match column names. Don't disable RLS or change unrelated queries.

If the AI can't fix it: manual steps

  1. Log out and back in, then retry.
  2. In the Supabase Table Editor, check that rows have the user_id of the logged-in user.

Where this happens

Seen in these AI app builders and editors:

LovableBolt.newCursorWindsurfv0

Sources

Related database errors

Still stuck? Paste your full error and UnstuckMyVibe will match it and hand you the exact fix prompt.

Fix my error →