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

# PostgreSQL

> Connecting a PostgresSQL Data Source

To integrate a PostgreSQL database into your Typper BI environment, follow the comprehensive steps below:

<Steps>
  <Step title="Choose the Data Source Type">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_01.png)

    1. Navigate to the 'Add Data Source' page in your Typper BI dashboard.
    2. Under the 'Databases' section, select the 'MongoDB' option.
  </Step>

  <Step title="Add Data Source Connection Details">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_02.png)

    Provide the necessary connection details in the form fields:

    2. URL: Enter the full database URL in the format postgresql://username:password\@hostname:port/database?options.
    3. Data Source Name: Assign a unique name for easy identification of your database within Typper BI.
    4. Typper BI IP Address: Ensure that the Typper BI's IP address is whitelisted in your firewall settings to establish a successful connection.

    ```bash
    34.16.94.3
    ```
  </Step>

  <Step title="Select the Schemas to Use">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_04.png)

    1. Once the database connection is successful, you'll be prompted to select the schemas you wish to use.
    2. Choose the relevant schemas that contain the data needed for your analytics.
  </Step>

  <Step title="Schemas Verification">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_03.png)

    Typper BI will load and verify the tables from the selected schemas.
    You might have to wait a few moments while the system processes the tables.
  </Step>

  <Step title="Confirm the Tables and Columns">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_06.png)

    1. After schemas are loaded, select the tables and specific columns you need for your reports.
    2. You can add descriptions to each table to provide context for our AI.
  </Step>

  <Step title="Finalize Adding Your Data Source">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_05.png)

    1. Review all the details and ensure that everything is correctly set up.
    2. Click 'Add Data Source' to complete the process.
  </Step>
</Steps>