Too 🤪 to connect Supabase

[MangoMarkets]

Describe the problem/error/question

I am having issues connecting Supabase to n8n. I did it once before, so I must have had the ability to pull it off, but Supabase had an update to the API this week, and I wonder if that is the reason.

What is the error message (if any)?

“Couldn’t connect with these settings

Unsupported protocol postgresql:”

Information on your n8n setup

• n8n version: Version 1.110.1 Cloud

For the Supabase Host Name I put in a string with this structure: postgresql://postgres:[email protected]:5432/postgres

For the Service Role Secret I used the one from the legacy api keys window in Supabase.

Any way to fix this with the current Supabase node?

[barn4k]

hello @MangoMarkets

Your Host value should match the template https://<project_ref>.supabase.co

Check the docs: REST API | Supabase Docs

[Wouter_Nigrini]

If you’re suing the Supabase node, then you need to find the api url and NOT the database connection string. In supabase go to “Project Settings → Data API”

It’ll look something like this:

[MangoMarkets]

Much appreciated. Solved