> For the complete documentation index, see [llms.txt](https://docs.diaflow.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.diaflow.io/workflow-builder/nodes/database/postgresql.md).

# PostgreSQL

## What this node helps you do

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

<figure><img src="/files/k3WJMOtbobvV1ojEaIKG" alt=""><figcaption></figcaption></figure>

### Common business examples

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

## Available actions

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

<figure><img src="/files/sKfd7P4HJGWyNhqO3pKk" alt=""><figcaption></figcaption></figure>

## Basic setup

### 1. Select resource

Choose the PostgreSQL connection your workspace should use.

If you do not see the right connection, open **Manage** and add it in **Workspace → Integrations**.

### 2. Select table

Choose the table that contains the business data you want to use.

Examples include `customers`, `subscriptions`, `orders`, or `requests`.

### 3. Choose the action

Pick whether the workflow should read data or add data.

## Query data from table

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

### Use AI

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.

### Manual enter SQL

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.

## Add data to table

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.

## Field reference

* **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

## Tips for first-time users

* 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.

{% hint style="info" %}
If you are unsure which table or fields to use, ask your database owner or technical team first.
{% endhint %}