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

# Connections

Connections hold information about the database that you have connected to Trulyp. You only have to do this once for every database connection you would like to use for Trulyp, be that for using [Analytics](/trulyp/analytics/analytics.md), or for making WriteBackExtreme [Schemas](/trulyp/writebackextreme/schemas.md). The username and password of a connection are stored safely and encrypted in our back-end.

### Connecting with a database.

Connecting to a database consists of three steps:

1. Filling in the connection label, description and color to define the appearance of the connection throughout trulyp
2. Choosing the driver for the type of database that you are connecting with
3. Filling in the connection details to connect to the type of database

Access to connections is restricted to admins or to users with the connection manager role.

<figure><img src="https://2312557015-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbWxEBax8PKTjFYRLWgi%2Fuploads%2FuvRhqlIz01jKJIFwDbc6%2FData_Connections.png?alt=media&amp;token=ea0fa400-a05d-4cc3-bf21-19b0b1f324e2" alt=""><figcaption></figcaption></figure>

To create a new connection, click the "Create new connection" button in the top right.

### Entering Database information

First, enter the label for the connection, and then pick your desired Database driver. For this example, we will use PostgreSQL.

<figure><img src="https://2312557015-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbWxEBax8PKTjFYRLWgi%2Fuploads%2FPqe6JOCRIG3Pi0kMrdcn%2Fimage.png?alt=media&amp;token=8116537f-fe15-47b1-8d4e-00d6f3495ab1" alt=""><figcaption></figcaption></figure>

For PostgreSQL, we will need at least a **host, port, username, password and database**. Optionally, you can also specify a schema. After filling in all the information, you can press the "Test connection" button to confirm that the connection can successfully be made.

#### Group visibility

<figure><img src="https://2312557015-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbWxEBax8PKTjFYRLWgi%2Fuploads%2FjOZ93E9iXxNDWFeD1QRn%2Fimage.png?alt=media&amp;token=816fe0f9-aed1-4b3e-b5bc-b301f152201d" alt=""><figcaption></figcaption></figure>

Under **Authorized Teams**, select one or more teams.

* **Everyone** – All users can use this Connection.
* **Specific team(s)** – Only members of the selected team(s) can access the provider.

Finally, press "Create connection" to save your new connection.


---

# 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.infotopics.com/trulyp/data/database-connections.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.
