PostgreSQL
Read and add business data in your PostgreSQL database from a workflow.
Last updated
Read and add business data in your PostgreSQL database from a workflow.
Use the PostgreSQL node when your workflow needs data from a PostgreSQL database.
This node helps you:
find records from a selected table
add new rows from workflow data
Teams often use this node to:
look up customer or subscription information
save a new lead or request into an internal system
combine workflow data with records from a product database
The Action field gives you 2 options:
Query data from table — find or retrieve data from a selected table
Add data to table — create a new record in the table
Choose the PostgreSQL connection your workspace should use.
If you do not see the right connection, open Manage and add it in Workspace → Integrations.
Choose the table that contains the business data you want to use.
Examples include customers, subscriptions, orders, or requests.
Pick whether the workflow should read data or add data.
Choose Query data from table when you need to search or retrieve information.
This action includes SQL Generate Method with 2 options:
Use AI — describe what you want in plain language
Manual enter SQL — write the SQL query yourself
Choose Use AI if you want a faster setup and do not want to write SQL.
In Input, describe the result you want.
Examples:
Find active subscriptions for this customer
Get the latest order for this email
Show open requests from this month
Diaflow uses that instruction to generate the SQL query for you.
Choose Manual enter SQL if your team already has a specific query.
Enter the SQL in the code editor.
Use this option when you need exact control over filters, joins, or sorting.
Choose Add data to table when your workflow needs to save a new record.
This is useful after:
a form submission
a registration flow
a data collection or AI extraction step
Make sure the values you send match the columns in the selected table.
Select resource — chooses the PostgreSQL connection
Table — chooses the table the node will use
Action — decides whether the node reads or adds data
SQL Generate Method — appears for query actions and lets you use AI or manual SQL
Input — plain-language instruction for AI-generated queries
Code editor — SQL entry area for manual queries
Start with Query data from table to confirm the connection works.
Use a simple table first, such as customers or subscriptions.
If you are not sure what to write, use Use AI before manual SQL.
Check the Result tab after each test run.
If you are unsure which table or fields to use, ask your database owner or technical team first.
Last updated