---
title: "PostgreSQL Connector | Lansweeper Platform"
slug: "postgresql-connector"
description: "Use the PostgreSQL connector in Lansweeper Flow Builder to query a PostgreSQL relational database from your automated workflows."
status: "update"
updated: 2026-07-17T16:08:06Z
published: 2026-07-17T16:08:06Z
canonical: "docs.lansweeper.com/postgresql-connector"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lansweeper.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL Connector

Note on third‑party tools

              

We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.

[PostgreSQL](https://www.postgresql.org/) is a popular relational database system. This component allows you to query a PostgreSQL database.

## Connections

### On-Premise Connection

Authenticate requests to a PostgreSQL server.

Create a new PostgreSQL connection and enter the connection details for the PostgreSQL server.

#### Configure the Connection

- Enter the **Host**, the hostname or IP address of the PostgreSQL server (e.g., `192.168.0.1`).
- Enter the **Port** of the PostgreSQL server (default: `5432`).
- Enter the **Database** name to connect to.
- Optionally enter a **Username** and **Password** to authenticate to the PostgreSQL server.
- Set **Require SSL** to require an SSL connection to the PostgreSQL server.
- Optionally set a **Connection Timeout** in milliseconds to wait before timing out (default: `5000`).

| Input | Comments | Default |
| --- | --- | --- |
| Host | The hostname or IP address of the PostgreSQL server. |  |
| Port | The port of the PostgreSQL server. | 5432 |
| Database | The name of the database to connect to. |  |
| Username | The username used to authenticate to the PostgreSQL server. |  |
| Password | The password used to authenticate to the PostgreSQL server. |  |
| Require SSL | When true, requires an SSL connection to the PostgreSQL server. | false |
| Connection Timeout | The amount of time (in milliseconds) to wait for a connection to be established before timing out. Default is 5000ms. | 5000 |

## Triggers

### New and Updated Records

Checks for new and updated records in a table on a configured schedule.

| Input | Comments | Default |
| --- | --- | --- |
| Connection | The PostgreSQL connection to use. |  |
| Table Name | The name of the table to monitor for new and updated records. |  |
| Cursor Field | The column used to track new results. If the table has an auto incrementing integer ID, that ID can be used. If it has a 'created at' or 'updated at' timestamp, those can be used. Each time this trigger runs, it checks for records with values greater than the largest value from the last run. | updated_at |
| Cast Timestamps to Strings | When true, timestamp values are cast to strings to retain precision. PostgreSQL tracks microseconds, but JavaScript dates are measured in milliseconds, so precision can be lost when fetching TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ fields. Enable this when the cursor field is a timestamp. | true |

## Actions

### Query

Performs a query on a PostgreSQL database.

| Input | Comments | Default |
| --- | --- | --- |
| Connection | The PostgreSQL connection to use. |  |
| Query Field | The SQL statement to execute against the database. Use named parameters (i.e. ${name}) or index variables (i.e. $1) to safely interpolate values. |  |
| Named Parameters | Optional named parameters to insert into a query. |  |
| Parameters Object or Array | Optional parameters to insert into a query. This should be a key-value object if you are using named inputs (i.e. ${name}), or an array if using index variables (i.e. $2) in your query. Values from this object will be merged with Named Parameters inputs if you are using named variables. |  |