Supabase Node - Table Dropdown Not Loading Options

Questions
1

Hi everyone!

I’m running into an issue with the Supabase node in n8n (v1.123.67) where the “Table Name or ID” dropdown shows this error:

Error fetching options from Supabase

However, when I manually type the table name into the field, the node executes perfectly and returns data correctly. The API connection works fine when tested.

Has anyone else experienced this? Or knows a fix?

Details:

  • Credential API test: :white_check_mark: passes
  • Manual table entry: :white_check_mark: works great
  • Dropdown loading: :cross_mark: fails on all projects
  • n8n version: 1.123.67
  • Platform: Docker

I can work around it by typing table names manually, but would love to get the dropdown working again if possible.

Thanks in advance! :folded_hands:

2

Hey @Yosr_Oualha, while you wait for a response, here are some things that might help:

Suggested resources

Automatically matched to your question.

Docs:

Forum:

@A_A4, @AstraDave, @Wouter_Nigrini - you’ve helped with similar issues before, can you take a look?

Automatically suggested by n8n’s community bot. It’s a pilot - please share feedback here.

3

Hi @Yosr_Oualha Welcome!
The dropdown is the only part of the node that calls the Data API root, /rest/v1/, to read the OpenAPI schema spec, and Supabase has stopped serving that path to anon and publishable keys, returning “Access to schema is forbidden”. Normal reads against /rest/v1/your_table were deliberately left untouched, which is why typing the table name works and the credential test passes.
Swap the key in your n8n Supabase credential for the service_role key or the new sb_secret_ secret key and the list loads again. Both of those bypass RLS, so every node on that credential will read past your policies.
See this: