> For the complete documentation index, see [llms.txt](https://docs.getuntitled.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getuntitled.ai/custom-connections/postgres-database.md).

# Postgres Database

{% hint style="info" %}
This is a feature exclusively for enterprise accounts
{% endhint %}

## Database Connection Overview

Untitled offers a premium feature that grants users access to a managed data warehouse, enabling integration at the data layer. All raw visitor data collected via the Untitled ID tag is exposed through a client-specific Postgres database connection, which can be accessed using the credential set available in your portal.

Follow the step-by-step guide below to test your connection to the Untitled Postgres database using a common method, and refer to the accompanying [documentation for schema and table structure](broken://pages/uNPCciDfD1QZMf8aIrlG) details.

## SQL Client Connection Instructions

{% hint style="info" %}
These instructions cover how to connect to the Untitled Postgres database using an open-source SQL client DBeaver. We selected DBeaver for this guide because it’s free **and includes a pre-installed Postgres driver.**

If you prefer to use a different SQL client, check whether it includes support for Postgres. If not, you may need to install an Postgres driver prior to testing your connection credentials as outlined in this guide.
{% endhint %}

### Locate your Untitled Postgres Database Connection Credentials  <a href="#find-your-distilled-database-connection-credentials" id="find-your-distilled-database-connection-credentials"></a>

1. Log in to your Untitled account.
2. Select "Custom Connections" on the left-side navigation menu.
   1. If you do not see this item on your navigation, please contact your customer success manager or <support@getuntitled.ai> to enable it.
3. Your Postgres credentials will be located in the tile component titled "Postgres Warehouse" .

<figure><img src="/files/3TDfdGzo6yKKTGArV8jo" alt=""><figcaption></figcaption></figure>

## Download & Setup DBeaver (Example SQL Client)

1. DBeaver is a free and open source tool used to interact with various databases. To start, [download](https://dbeaver.io/download/) the version of DBeaver corresponding to your operating system. Once downloaded, continue to the next step.
2. Create a new database connection by selecting the plug icon in the top left corner of your screen. Once clicked a new dialog box will appear. Select <kbd>Postgres</kbd> and then click `Next`.

<figure><img src="/files/4pBjrdlXgPQsiSWWV7Av" alt=""><figcaption></figcaption></figure>

3. Using the credentials found in the Custom Connections > Postgres Warehouse page of your Untitled account, enter the following information into the DBeaver Postgres Connection Settings.
   1. Host
   2. Port
   3. Database
   4. Username
   5. Password

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

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

4. You should now see your connection listed in the Database Navigator and can begin writing SQL to query your tables. To test your setup, enter the following in the SQL editor: `SELECT * FROM resolutions.visitors LIMIT 10`  Running this query should return the first 10 rows of data, confirming that your connection is working correctly.

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

Congratulations! You’ve successfully connected to your visitor database using DBeaver. If you have questions about building a replication pipeline from this database, feel free to reach out via the Support Desk—we’re happy to assist with your specific use case.

To review the Postgres Warehouse schema, please proceed to the following [knowledge base article. ](broken://pages/uNPCciDfD1QZMf8aIrlG)

### Manual Export (DBeaver Example)

Once you've successfully connected to the Postgres Database, test the following actions to save your query results locally.&#x20;

#### Write and Execute Query <a href="#write-and-execute-query" id="write-and-execute-query"></a>

1. Write your SQL Query: Write the SQL query in DBeaver to select the data you want to export from the Untitled Postgres database.
2. Execute the Query: Execute the SQL query to retrieve the results from the Untitled Postgres database.

#### Export Query Results <a href="#export-query-results" id="export-query-results"></a>

1. Select Results to Export from the above query steps.
2. Export Results: *Right-click* and select the `export` option. Choose the appropriate format (e.g., CSV, Excel, etc.) and specify the export location.
3. Save Exported File: Save the exported file to the desired location on your local system.

## Connecting the Postgres Database to the Looker Business Intelligence Platform

Google publishes a guide for connecting a Postgres database to Looker here: <https://docs.cloud.google.com/looker/docs/db-config-postgresql>.

## Need Further Support or Have Additional Questions?

Check out our[ <mark style="color:blue;">FAQs</mark> ](/misc/frequently-asked-questions.md)to get some answers, start a chat on our [website](https://getuntitled.ai/), or get connected directly with our team [<mark style="color:blue;">here</mark>](https://getuntitled.ai/contact/).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.getuntitled.ai/custom-connections/postgres-database.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.