---
title: Infoveave Postgres Integration
description: Learn how to connect PostgreSQL in Infoveave to query open-source relational data for scalable dashboards, reports, and data pipelines.
---

import { Aside, Steps } from '@astrojs/starlight/components';

# Postgres

Postgres connection helps you connect to a **Postgres database** and run queries directly from Infoveave.



## Adding a Postgres Connection

To create a new Postgres connection:
<Steps>
1. Go to the **Database** section.
2. Select **Postgres** from the available connectors.
3. Fill in the required connection details in the **New Postgres Connection** form.
</Steps>


## Connection Parameters

When setting up a Postgres connection, you need to provide the following details:

| Field        | Description |
|--------------|-------------|
| **Name**     | A unique name to identify your connection. |
| **Port**     | Port number for Postgres (default is `5432`). |
| **Server**   | The Postgres server endpoint. |
| **Username** | Your Postgres database username. |
| **Password**   | The corresponding password for the username. |
| **Database**   | The Postgres database you want to connect to. |
| **Schema**   | The schema inside the database to be used (optional). |



## Steps to Validate and Save
<Steps>
1. After filling in the details, click **Validate** to verify the connection.  
2. If validation succeeds, click **Save** to store the connection.  
3. You can now use Postgres as a datasource in your Infoveave workspace.  
</Steps>


## Example Use Case

With a Postgres connection configured, you can:

- Query and manage Postgres databases efficiently.  
- Use advanced SQL features including JSON support, full-text search, and geospatial queries.  
- Integrate Postgres data into Infoboards for dashboards, reports, and insights.