Connectors

Databases & Data Warehouses

Postgres

Relational database: query, insert, update, and react to changing rows
Postgres documentationAPI checked August 18, 2026
Signs in with
Connection details
Runs on
Cloud or On-Prem Worker
Operations
13
Ready-made triggers
0

Connect Postgres

  1. In Neblex open Connect › Connections and click New Connection.
  2. Search for Postgres and give the connection a clear name.
  3. Fill in the fields. Secret values are encrypted and never shown again.
  4. Click Test, then Create Connection.
If the system is only reachable inside your network, choose an On-Prem Worker under Test from and run the flow on that Worker. See On-Prem Workers.
FieldWhat to enter
Connection setupRequired
HostRequired
PortOptionalExample: 5432
DatabaseRequired
UserRequired
PasswordOptionalSecret
Use TLSOptionalTurning this off sends traffic and credentials without transport encryption. Use plaintext only for a customer-controlled endpoint that explicitly requires it.
Server CA certificate (PEM)OptionalOptional private CA added to the bundled WebPKI roots for verify-full TLS. Leave blank for a publicly trusted server certificate. Fresh-host RAG setup fills this automatically.
Connection stringRequiredSecretPaste a postgres:// or postgresql:// connection string.

Use it in a flow

  1. Open a flow, open the node library and search for Postgres.
  2. Drag it onto the canvas and choose an Operation and your connection.
  3. Map the operation's fields from earlier steps, or click Map with Matt.
  4. Use Test this step to see what it returns, then save.

To start a flow from Postgres without a ready-made trigger: a Poll for changes trigger on Postgres with your own query passes on new or changed records.

Operations

13 operations in 1 groups. Each one is a step you can add to a flow.

SQL13
Delete rows (mapped)deleteDelete the row matching the key columns of each record.
Execute commandcommandExecute the PostgreSQL DML, DDL, DO, or CALL entered in the statement editor.
Execute queryqueryExecute the PostgreSQL SQL entered in the statement editor with bound :name parameters.
Get server timeserverTimeReturn the current database timestamp.
Get server versionserverVersionReturn the complete PostgreSQL server version.
Get table row estimatetableRowCountReturn PostgreSQL catalog row estimates for every visible table matching the supplied name.
Insert rows (mapped)insertInsert one row per record into a table you pick, mapping each column from the record.
List table columnslistColumnsList columns for every visible table matching the supplied name.
List tableslistTablesList user-visible tables and views with their schemas and types.
Select rows (mapped)selectRead rows from a table you pick: choose the columns to return, filter by the column values you map, order and limit.
Test PostgreSQLpingRun a minimal query and return ok=1.
Update rows (mapped)updateUpdate the row matching the key columns of each record, setting the other mapped columns.
Upsert rows (mapped)upsertInsert one row per record, or update the existing row when the key columns already match.