# PostgreSQL

{% hint style="info" %}
💪 **Difficulty:** advanced

⏳ **Time to complete**: approx: 10-15 min (if your database has a restricted inbound IP security rule, you need to schedule a call with us - we’re working on something better!)
{% endhint %}

## 💬 Description

PostgreSQL is a relational SQL database. You can read more about that on PostgreSQL on the [website ](https://www.postgresql.org/about/)if you are curious.

## 🤑 Use Case

Connecting to a PostgreSQL database is very helpful if you have your own application that pushes data to a database. Such a database usually contains information on your customers and their behavior, but it could contain many important things.

## 🛠️ Setup

This Connector should probably be configured by (or with assistance from) your database responsible - you’re also welcome to [schedule a call.](https://calendly.com/thomas-less/speak-to-less)

{% hint style="danger" %}
If your PostgreSQL (or the server it's hosted on) has restrictive inbound IP rules, you need to [schedule a call ](https://calendly.com/thomas-less/speak-to-less)with us as you cannot access the Less application’s IP currently. We are working on displaying the IP of the Less application inside the web application. 

If your PostgreSQL (or the server its hosted on) has unrestricted IP access, continue below 👇
{% endhint %}

### Step #1: Host IP

Input the Host IP of your PostgreSQL in the Less configuration window. Usually looks something like this: `87.398.80.712`

### Step #2: Host Port

Input the Host Port of your PostgreSQL in the Less configuration window. It’s usually `3306`.

### Step #3: Database Name

Input the Database name of your PostgreSQL in the Less configuration window.

### Step #4: Input Collection(s)

Input the names of the PostgreSQL Collections you want to extract in the Less configuration window. This should be a comma-separated list like `table1,table2,table3`

### Step #5: Username & Password

Input the username and password of a PostgreSQL account with read access. Everything is encrypted in transit and at rest.

###


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://resources.less.tech/less-tech/connectors/connector-guides/postgresql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.