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

# Connect PostgreSQL

> Connect a PostgreSQL database to Daymark with guided steps

## Overview

This guide expands the PostgreSQL connection flow with visuals.
Use it when connecting a new database for the first time.

***

## Connect a PostgreSQL to Daymark

### Open the Explore Page

From your Daymark workspace, go to **Explore** to start the connection.

<img src="https://mintcdn.com/daymark-189ba31c/Xpjx81zz23V45QQD/images/connect-db-explore.webp?fit=max&auto=format&n=Xpjx81zz23V45QQD&q=85&s=b03e0df90007d331965b6ae9a47ad235" alt="Explore page with Add data source button" width="2926" height="1660" data-path="images/connect-db-explore.webp" />

### Choose PostgreSQL

Click **Add data source** and select **PostgreSQL** from the connector list.

<img src="https://mintcdn.com/daymark-189ba31c/Xpjx81zz23V45QQD/images/connect-db-connector.webp?fit=max&auto=format&n=Xpjx81zz23V45QQD&q=85&s=a8f0bf5a937cd4c0a0e1409ee330a0c5" alt="Data connectors modal with PostgreSQL selected" width="2926" height="1660" data-path="images/connect-db-connector.webp" />

### Enter Connection Details

You can use either a connection string or manual fields.

#### Option 1: Connection string

Paste your PostgreSQL connection string into the **Connection String** field.

#### Option 2: Manual fields

Fill in the form with your database details:

* **Host**
* **Port** (default `5432`)
* **Database name**
* **Username**
* **Password**

Click **Connect Database**.

<img src="https://mintcdn.com/daymark-189ba31c/Xpjx81zz23V45QQD/images/connect-db-form.webp?fit=max&auto=format&n=Xpjx81zz23V45QQD&q=85&s=6ab1c3401c65a62040b4b8ac93f94cb9" alt="PostgreSQL connection form" width="2926" height="1660" data-path="images/connect-db-form.webp" />

### Select Tables and Fields

Choose the tables and columns you want to include:

* Use **Select all** to include every field
* Or choose only the fields relevant to your analysis

Click **Done** to finish.

<img src="https://mintcdn.com/daymark-189ba31c/Xpjx81zz23V45QQD/images/connect-db-fields.webp?fit=max&auto=format&n=Xpjx81zz23V45QQD&q=85&s=6857c5bdf8145f198e0b5a8cd01d05f5" alt="Field selection during PostgreSQL import" width="2926" height="1660" data-path="images/connect-db-fields.webp" />

### Connect and Import

Daymark validates the credentials and starts importing. Once the import is complete successfully, you can start analyzing the data in Daymark.

<img src="https://mintcdn.com/daymark-189ba31c/Xpjx81zz23V45QQD/images/connect-db-import.webp?fit=max&auto=format&n=Xpjx81zz23V45QQD&q=85&s=937d126047e08653110ab978624a9635" alt="Importing data from PostgreSQL" width="2926" height="1660" data-path="images/connect-db-import.webp" />

***

## Connection Complete

Once the import completes successfully, ask your questions on the Explore page to see trends, patterns, and insights from your data in Daymark.
