# Supabase node only lists tables under the public schema

**URL:** <https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519>\
**Category:** Questions\
**Tags:** supabase\
**Created:** [May 25, 2023, 12:42pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519 "2023-05-25T12:42:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mixuci](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@mixuci](https://community.n8n.io/u/mixuci)\
**Post date:** [May 25, 2023, 12:42pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/1 "2023-05-25T12:42:46Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [May 25, 2023, 2:16pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/2 "2023-05-25T14:16:01Z")

</div>

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](https://app.supabase.com/project/_a/settings/api)?

---

<div class="post-metadata">

**Author:** ![mixuci](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@mixuci](https://community.n8n.io/u/mixuci)\
**Post date:** [May 25, 2023, 3:57pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/3 "2023-05-25T15:57:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [May 25, 2023, 4:26pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/4 "2023-05-25T16:26:42Z")

</div>

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

```auto
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:

```auto
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;

```

---

<div class="post-metadata">

**Author:** ![mixuci](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@mixuci](https://community.n8n.io/u/mixuci)\
**Post date:** [May 25, 2023, 10:42pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/5 "2023-05-25T22:42:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [August 23, 2023, 10:42pm UTC](https://community.n8n.io/t/supabase-node-only-lists-tables-under-the-public-schema/26519/6 "2023-08-23T22:42:49Z")

</div>

Closed on August 23, 2023, 10:42pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.