> For the complete documentation index, see [llms.txt](https://docs.stacksync.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.stacksync.com/connectors/postgres/authorize-postgres/retool.md).

# Retool

Authenticate your Retool app and sync data with Stacksync

### 1. Access your dashboard

### 2. Click on "Database"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-ee776c4b5b34fb48841c8db0a44eca5f10a26030%2Fimage%20(52).png?alt=media" alt=""><figcaption><p>Click on "Database"</p></figcaption></figure>

### 3. Reveal Database Options

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-8c907b755ceeaaa564b4413da918bd75d9bf5700%2Fimage%20(53).png?alt=media" alt=""><figcaption><p>Click and reveal options</p></figcaption></figure>

### 4. Click "Connection"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-22358d10df8aaeee99c43690965e524eca47684a%2Fimage%20(54).png?alt=media" alt=""><figcaption><p>Click "Connection"</p></figcaption></figure>

### 5. Reveal Postgres Connection URL

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-7b1675da7ed9d60a300df8054c5f8821063c4f4b%2Fimage%20(55).png?alt=media" alt=""><figcaption><p>Reveal the Connection URL</p></figcaption></figure>

### 6. Copy connection URL

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-30d6efbbfd7142e06edd6ba2b13c94ad5eaa0192%2Fimage%20(56).png?alt=media" alt=""><figcaption><p>Copy the connection URL</p></figcaption></figure>

### 7. Get credentials from connection URL

{% hint style="info" %}
Retool doesn't give you the port info to connect Postgres via connection URL.
{% endhint %}

From your connection URL. Manually get the data needed to fill the connection form that will be shown in Step 9.

* **Database Type**
* **Host**
* **Port**
* **Username**
* **Password**
* **Database**
* **Schema**

### 6. Click on "Connections"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-905cce03731b73545478fba32b21af2aa56a1e7c%2Fimage%20(57).png?alt=media" alt=""><figcaption><p>Go to "Connections" on Stacksync</p></figcaption></figure>

### 7. Click on "Create New Connection"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-216dfc3c9b451f87b4e19edb907112078f59d9a0%2Fimage%20(60).png?alt=media" alt=""><figcaption></figcaption></figure>

### 8. Click "Postgres"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-eb8d23727f0dbce3c698311dff2a8a3e63dea5ea%2Fimage%20(61).png?alt=media" alt=""><figcaption></figcaption></figure>

### 9. Fill the connection form

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-a2f641739ab2e63f27ac4fb0a8661c080e34f192%2Fimage%20(62).png?alt=media" alt=""><figcaption><p>Fill the connection form with all the data from step 7</p></figcaption></figure>
