Can't connect to PostgrSQL hosted on Supabase

[Dima_Semensky]

Cloud n8n and cloud Supabase

Trying to connect getting this error:
connect ENETUNREACH 2600:1f1c:f9:4d11:4496:9ade:e99:2c50:5432 - Local (:::0)

I’m able to connect to this database from other places like Google Looker studio.

Any thoughts?

[solomon]

Hey @Dima_Semensky

To connect to Supabase’s Postgres database, please follow these instructions:

1. Click the connect button on the top of your Supabase dashboard:
   

2. Scroll down to “Transaction pooler” and click “view parameters”
   

   

3. Paste all that information into a new Postgres credential, in n8n
   

   

4. To find your database password, go back to Supabase in Project Settings > Database
   

   
   
   
   

5. Click “Reset Password” to be able to copy the password and paste that into the n8n credential.
   

   

6. Create a new Postres node in your workflow and select the credential. Now you have the “Upsert” option for you database
   

   

.

If my reply answers your question, please remember to mark it as a solution.