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.
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.
Step 2: Add Postgres Credentials in n8n
n8n has official Postgres credentials support. Create a new Postgres credential and enter your database connection settings.
- Open Credentials in n8n
- Create a new Postgres credential
- Enter host, port, database, username, and password
- 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;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 SheetsThis 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
↓
GmailIn 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
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 ChannelFAQ
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.
