> For the complete documentation index, see [llms.txt](https://doc.dataflake.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.dataflake.co/data-sources/postgresql.md).

# PostgreSQL

From the top navigation bar click on the ![](/files/zw6JvJWMtfhKoFHuDj6a) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **PostgreSQL** from the Connection type.

Enter your connection string. 

1. **Hostname:** where your database is hosted 

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}

2. **Port:** 

* The port the database server uses
* For example, the default port number for PostgreSQL is 5432 

3. **Database:** name of your database 
4. **User:** username of the Database you want to connect 
5. **Password:** password of the Database you wish to connect

Click **Next** then Click the **Complete** button to establish your Connection.

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