# PostgreSQL

## Configure PostgreSQL connection

#### Accessing the PostgreSQL Connector

* Navigate to the **Connectors Page** from the main menu.
* Select **Add Storage** and choose **PostgreSQL** from the list of available connectors.

#### Connection Settings

* **Connection name.** Enter a unique name for this connection
* **Host.** Specify the hostname or IP address of your PostgreSQL server.
* **Port.** Enter the port number your PostgreSQL server is listening on. The default port for PostgreSQL is `5432`.
* **Username.** Enter the username that will be used to connect to your PostgreSQL database.
* **Password.** Enter the password associated with the provided username.
* **Database.** Provide the name of the database you wish to connect to within your PostgreSQL server.
* **Schema (optional).** Enter the schema name here if you need to set a specific schema as default. You can leave this field blank or select another schema in the Source node in the Flow Designer.&#x20;

#### Test and Save

* **Test connection.** Click this button to verify that the connection settings are correct. If successful, you will see a confirmation message. If there are issues, you will receive an error message detailing what needs to be corrected.
* **Save and Test.** This button allows you to save your settings and immediately test the connection. If the connection test is successful, the connector will be saved and ready for use.


---

# 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://docs.tomat.ai/integrations/connectors/data-storages/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.
