Postgres Credential using Neon

[silsen]

Describe the problem/error/question

I want to connect to a Postgres database on Neon, but can’t figure out how I have to input the information from the connection details. The connection details from Neon are just in one singular URL string, but for the credential on n8n I have to input the single parameters (user, password …). So I don’t know what to put inside the “Host” field for example. The URL also ends with “…/[Name of database]” but I’m not how to use that because in the credential the db name has its own field.
Any help would be appreciated!

Information on your n8n setup

• n8n version:1.14.2
• Database (default: SQLite):SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):npm
• Operating system:Debian / Raspberry Pi OS

[nico-kow]

Hey @silsen,

I just created a neon database to showcase how to get the credentials.

I was not able to get a successful connection with my user based on my email.

I created a new user in the neon admin panel:

copied the name and the password to the n8n credentials like this:

You need to set the ssl to require to make it work.

Cheers.

[silsen]

Oh I see! So for the host I just have to use the part after the username and without the database name. I almost had it like this, removed the username from the “Host” URL and it worked
Thank you so much!