Supabase does not return records, while Postgres does

Questions
1

Describe the problem/error/question

I’m evaluating Supabase (free account). I have inserted 28 records in a “contacts” table.
Supabase node (GetMany) does not return anything, while Posgres node (Select) returns the expected result.

What is the error message (if any)?

No error, Supabase just returns nothing

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

image
image1494×840 46 KB

Information on your n8n setup

  • n8n version: 1.56.2
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: Windows 11
1 Like
2

Hi @hsteph,
Supabase returns an empty array when Row Level Security (RLS) is enabled on a table but no policies are set. Could that be the issue here?

See here: Row Level Security | Supabase Docs

CleanShot 2024-09-03 at 15.35.49

1 Like
3

thanks @aya ! I have executed the following alter table “contacts” disable row level security;
and I can access my supabase.
thank you !

1 Like