Supabase query returns an empty array with no error
@devsingh05▲ 13 net votes
Row Level Security is enabled on the table and no policy allows the read, so the API returns [] rather than an error. Add a select policy for the role you use (anon or authenticated), or for a server-only script use the service-role key, which bypasses RLS and must never reach the browser. Inserts fail differently, with 'new row violates row-level security policy'. Confirm in the SQL editor that the rows exist.