n8n Node Guide: PostgreSQL

Description

Storage & Databases node in n8n.

What It Does

Run SQL against a PostgreSQL database.

When To Use It

Relational data, transactional systems, the source of truth.

Key Parameters

Query, connection credential, parameters

Common Mistakes

Use parameterized queries ($1, $2) – never concatenate user input into SQL.

Example

SELECT * FROM orders WHERE status = $1 -> process each order.

FAQ

Is this node included in n8n Community Edition?

Yes – PostgreSQL ships with the free Community Edition. No paid license needed.

For writes, wrap multiple statements in a transaction node.?

Where does it fit in a workflow?

PostgreSQL works with any other node – connect it after a trigger or data node, and feed its output into the next step. Standard n8n data flow: trigger -> transform -> act.

Is support included?

Yes – message the seller through the store and I will help you wire this node.