> 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/two-way-sync/connectors/postgres/authorize-postgres/heroku.md).

# Heroku

For Heroku, use the "Postgres Heroku" connector.

#### 1. Go to <https://dashboard.heroku.com/apps>

#### 2. Open one of your apps

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

#### 3. Open your database add-on

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

#### 4. Go to settings and view Database credentials

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

#### 5. Copy Connection URI

<figure><img src="/files/782G6RSuT2CaqIbn1Or1" alt=""><figcaption></figcaption></figure>

#### 6. Paste the connection URI into Stacksync to connect your database

<figure><img src="/files/gYk8yIl1tO8kdfb3k8gb" alt=""><figcaption><p>Paste your connection URL to connect your database</p></figcaption></figure>

{% hint style="info" %}
For the Heroku connector, the user is required to have the **Create** privilege on the database.

This privilege can be enabled for the user using the following SQL query:

```sql
GRANT CREATE ON DATABASE database_name TO user_name;
```

{% endhint %}

Finally, click "Authorize App" to connect!

That's it, your Postgres Heroku instance is connected! 🎉