Postgres Connection Setup Help? (supabase)

Hi all,

Apologies for a low-level noob type question, but I’m having trouble setting up a connection to Supabase and the documentation is non-existent. Does anyone have a step by step guide of what needs to go where to make a connection work? My assumption was that “host” meant the restful API endpoint shown in my Supabase console. I tried both port 8081 as well as 6543 and get the same getaddrinfo ENOTFOUND error.

Can anyone help with some documentation of how to actually setup the connection?

1 Like

Welcome to the Make community!

According to Supabase documentation, they implemented RESTful API using PostgREST.

The Supabase guide for API keys can be found here Understanding API Keys | Supabase Docs

You probably didn’t grant access to your database correctly.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like

Have you considered using REST API of Supabase, or do you need to run SQL queries?

FYI, for Postgres module host should be taken from Settings → Database, not from Settings → API:

See above valid path sample. From there, you should take “connection string”.

Hope that helps,