PostgreSQL Credential - Database Connection

What is a PostgreSQL Credential

A PostgreSQL credential allows your workflows to execute SQL queries, read and write data in a PostgreSQL database. It is used with SQL query nodes.

---

Configuration Fields

Field	Description	Example
Host	Database server address	db.example.com or localhost
User	Database username	postgres
Password	User password	my_password
Database	Database name	my_database
Port	Connection port (default: 5432)	5432
SSL	Enable SSL encryption for the connection	true

---

How to Get Connection Details

Local Database

Host: localhost or 127.0.0.1
Port: 5432
User: postgres (or your user)
Password: the password you set when installing PostgreSQL
Database: your database name

Cloud Services

Amazon RDS:

1. Go to AWS Console > RDS > Your instance
2. Copy the Endpoint (this is the Host)
3. Default port is 5432
4. Use the username and password you set when creating the instance

Supabase:

1. Go to your project on supabase.com
2. Navigate to Settings > Database
3. Copy the direct connection details

Railway / Render / Heroku:

1. Go to the database section of your project
2. Look for the connection string or individual details
3. Copy host, user, password, database, and port

---

SSL

• Cloud services: Generally require SSL enabled (true)
• Local database: Generally doesn’t need SSL (false)
• For connections with custom SSL certificates, use the PostgreSQL SSL credential

---

Troubleshooting

Connection Error

• Verify the host and port are correct
• Make sure the database accepts remote connections (check pg_hba.conf)
• Check that the firewall allows connections to port 5432

Authentication Failed

• Verify username and password
• Make sure the user has permissions on the specified database

SSL Required

• Enable the SSL option in the credential
• Some cloud providers require SSL mandatorily