Connect your Heroku Postgres database to VexiData for natural language querying and dashboard creation. Connection takes about 2 minutes.

Connect Heroku to VexiData

Click to play video

Prerequisites

A VexiData account (free tier available)Create account
A Heroku account with a Postgres add-onHeroku Dashboard
Access to your Heroku dashboard or CLI

Connection Steps#

Access Heroku Dashboard

Open Postgres Add-on

1. Go to the Resources tab

2. Click on your Heroku Postgres add-on to open the datastore dashboard

Get Connection Credentials

1. In the Heroku Data dashboard, go to Settings

2. Click View Credentials

3. Copy the following details:

• Host: Your database host (e.g., ec2-xxx.compute-1.amazonaws.com)

• Port: 5432

• Database: Your database name

• User: Your database username

• Password: Your database password

Connect in VexiData

In VexiData, go to Data Sources from the menu, then select PostgreSQL under the Add New Data Source section.

text

Display Name:    My Heroku Database
Host:            ec2-xxx.compute-1.amazonaws.com
Port:            5432
Database:        your_database_name
Username:        your_username
Password:        your_database_password

Test and Save

Click Test & Save Connection. Once successful, you can start querying your Heroku data!

Rotating Credentials

Heroku may rotate database credentials periodically. If your connection stops working, check for updated credentials in the Heroku dashboard.

Search Documentation