Postgres Credential using Neon

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

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.



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 :smiley:
Thank you so much!


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.