I’m having trouble connecting n8n to my Supabase PostgreSQL database. I’ve tried using the connection string and manual configuration with these details:
I’ve also tried different connection methods but nothing works. Has anyone successfully connected n8n to Supabase?
For a direct connection it also mentioned:
postgresql://postgres:[YOUR-PASSWORD]@db.myprojectid.supabase.co:5432/postgres
So basically I want to create a Postgres Account so that I can access my supabase database via agents where I cant use my supabase credentials as login.
@Kiremit, you’re using the incorrect credentials. Supabase provides two sets of credentials: one for their API and another for PostgreSQL. The credentials you’re currently using are for their API, not PostgreSQL.
You can find the PostgreSQL credentials by clicking on Connect, then scrolling down to Transaction Pooler. These are the credentials for your PostgreSQL database, and the password is the same as the one from the previous set of credentials.
I tried that all along before. But no ability to enter the pool_mode. The password I used the same as when setting up the project. entering it without the brackets
@Kiremit, the password is supposed to contain special character due to security reasons. But are you sure that all credentials are correctly filled in?
Supabase doesn’t make use of the default PostgressQL port, so make sure that one is changed to the one you were given.
I mean besides the password there is not really any credentials. The Project ID sure but thats part of the link. I only wonder why the password is part of the link ajnd then has to be entered seperately via N8N again
@Kiremit, the password is included in the link because of something called Connection URI’s. However, you’ll still need to enter each detail separately into n8n. The host goes in the host field, the database in the database field, the user in the user field, and the password remains the same. The port should go in the port field.
Please use the credentials I’ve highlighted in blue:
