n8n + PostgreSQL Tutorial

How to Use n8n with PostgreSQL for Database Automation

Learn how to connect n8n to PostgreSQL, run queries, insert and update rows, and automate database workflows with triggers and notifications.

If you want to automate database tasks, combining n8n with PostgreSQL is a strong setup. PostgreSQL stores your structured data, while n8n handles the workflow logic around it.

💡 Example: when a form is submitted, n8n can save the lead to PostgreSQL, notify your team on Telegram, and send an email automatically.

What You’ll Learn

• How to connect PostgreSQL to n8n
• How to run SELECT queries
• How to INSERT new rows
• How to UPDATE existing records
• How to DELETE rows safely
• How to use PostgreSQL Trigger in n8n

Why Use n8n with PostgreSQL?

PostgreSQL is a powerful relational database used for apps, dashboards, internal systems, and business workflows. n8n makes it easier to automate what happens before and after your database actions.

• Save leads or orders automatically
• Read customer or system data on demand
• Update statuses after payments or approvals
• Trigger automations when rows change
• Connect database events to email, Telegram, APIs, and CRMs

Step 1: Prepare Your PostgreSQL Database

Before connecting n8n, make sure your PostgreSQL server is ready and you have these connection details:

• Host
• Port
• Database name
• Username
• Password

It is best to create a dedicated database user for n8n instead of using your main admin account.

⚠️ Security tip: only give the n8n database user the permissions it needs.

Step 2: Add Postgres Credentials in n8n

n8n has official Postgres credentials support. Create a new Postgres credential and enter your database connection settings.

1. Open Credentials in n8n
2. Create a new Postgres credential
3. Enter host, port, database, username, and password
4. Save and test the connection

After that, you can use the Postgres node inside your workflows.

Step 3: Read Data with SELECT

To read data from PostgreSQL, use SELECT.

SELECT id, full_name, email
FROM customers
ORDER BY id DESC;

This is useful for reading customers, orders, attendance logs, payments, and other records.

Step 4: Insert New Rows

To save new data, use INSERT.

INSERT INTO customers (full_name, email, phone)
VALUES ('John Doe', 'john@example.com', '09171234567');

This works well for form entries, lead capture, registrations, chatbot logs, and order records.

Step 5: Update Existing Records

To change existing records, use UPDATE.

UPDATE customers
SET phone = '09998887777'
WHERE id = 1;

This is useful for updating payment status, approval state, timestamps, or workflow progress.

Step 6: Delete Rows Carefully

To remove data, use DELETE. Always include a clear WHERE condition.

DELETE FROM customers
WHERE id = 1;

Warning: if you run DELETE without a WHERE clause, you can remove all rows from the table.

Step 7: Use Dynamic Data from Previous Nodes

One of the best parts of n8n is using data from earlier nodes inside your Postgres workflow.

Example expression:

{{ $json.email }}

This lets you insert, search, or update rows using form values, webhook data, chatbot output, or API responses.

Step 8: Use Postgres Trigger for Event-Based Automation

n8n also has a Postgres Trigger node that can respond to database events. According to n8n’s docs, it supports reacting to insert, update, and delete events.

Postgres Trigger
   ↓
IF
   ↓
Telegram / Gmail / HTTP Request / Google Sheets

This is useful when you want instant automation whenever a row changes in your database.

Example n8n + PostgreSQL Workflow

Webhook
   ↓
Set
   ↓
Postgres (INSERT lead)
   ↓
Postgres (SELECT saved record)
   ↓
Telegram
   ↓
Gmail

In this workflow:

• A webhook receives incoming data
• A Set node formats the fields

• The Postgres node inserts the record
• Another Postgres step reads the row
• Telegram and Gmail notify your team

Real Use Cases

Lead capture systems

Order and invoice tracking

Attendance and RFID systems

Internal dashboards and CRMs

Best Practices

• Use a separate PostgreSQL user for n8n
• Test SELECT first before running UPDATE or DELETE
• Log important outputs during development
• Keep your SQL simple and readable
• Use UTC and ISO 8601 dates when possible

Common Errors and Fixes

1. Connection failed
Check host, port, username, password, and whether your PostgreSQL server accepts external connections.

2. Access denied
Your database user may not have the needed privileges.

3. Query returned nothing
Review your table name, filters, and incoming data.

4. Wrong data inserted
Check your n8n expressions and field mapping.

5. Array or date issues
n8n’s Postgres common issues page recommends careful parameter handling, UTC for dates, and ISO 8601 formatting to avoid timezone confusion.

Watch My Automation Videos on YouTube

I share n8n workflows, automation tutorials, and AI system ideas on my YouTube channel.

▶ Visit My YouTube Channel

FAQ

Can I use n8n to insert data into PostgreSQL automatically?
Yes. n8n’s Postgres node supports inserting and updating rows, and it can also execute queries.

Can n8n react when PostgreSQL data changes?
Yes. n8n has a Postgres Trigger node for insert, update, and delete events.

Can I use PostgreSQL with Telegram, Gmail, or Google Sheets in the same workflow?
Yes. That is one of the main strengths of n8n.

---

SEO Title

n8n PostgreSQL Tutorial: How to Automate Database Workflows

Meta Description

Learn how to use n8n with PostgreSQL to automate queries, inserts, updates, deletes, and trigger-based workflows.