Supabase node only lists tables under the public schema

[mixuci]

Hi. I recently connected my Supabase database, but I encountered an issue with the n8n module. It only displays the tables under the public schema, and I couldn’t find any information on setting up other schemas. Can you please confirm if support for other schemas is currently available?

[EmeraldHerald]

Hi @mixuci

While I’m not familiar with Supabase at all, it looks like this is a limitation of Supabase by default. Have you tried to expose the schema in the Supabase settings?

[mixuci]

Yes, I tried adding the schema to the exposed schema list in the API settings, but it didn’t work (((

[EmeraldHerald]

@mixuci Can you try these additional steps as well? I’m not too sure if this will work, but:

CREATE SCHEMA Foo;

GRANT USAGE 
ON SCHEMA Foo 
TO postgres, anon, authenticated, service_role, dashboard_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA Foo
GRANT ALL ON TABLES TO postgres, anon, authenticated, service_role, dashboard_user;

And then also:

GRANT SELECT, INSERT, UPDATE, DELETE 
ON ALL TABLES IN SCHEMA foo 
TO postgres, authenticated, service_role, dashboard_user, anon;

GRANT USAGE, SELECT 
ON ALL SEQUENCES IN SCHEMA foo 
TO postgres, authenticated, service_role, dashboard_user, anon;

[mixuci]

I successfully established a connection to the Supabase database using the Postgres node, effectively resolving all of my issues. Thank you very much for your assistance.