> 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

In this page, we'll show you how to add a PostgreSQL source to Dataflake.

From the top navigation bar click on the ![](https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FbCEJQ2HTj8OOiqP0FTW1%2Fimage.png?alt=media\&token=441c66ea-bf56-4263-bae3-7b4899e52c1f) 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="https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FcXcESzmbSrjc0qlN7q0t%2Fconnect.gif?alt=media&amp;token=ef24de1a-ffd4-4ac3-93c8-c7619603f677" alt=""><figcaption></figcaption></figure>