Check out our step-by-step video showing how to connect your PostgreSQL database to Chartio:

If your PostgreSQL database is hosted on Heroku or Amazon RDS, please follow the respective instructions for connecting your instance.

1. Create a PostgreSQL read-only user

The Chartio connection form requires a read-only username and password, which you’ll need to create on your PostgreSQL database before you submit the connection form.

2. Allow Chartio’s IP address

Follow the instructions in the PostgreSQL section of our documentation for how to allow Chartio’s IP address.

3. Connect PostgreSQL to Chartio

You’ll need to provide the following information in Chartio’s PostgreSQL connection form to connect your PostgreSQL database to Chartio:

  • Hostname or IP: where your database is hosted
  • Port: default port number for PostgreSQL is 5432
  • Username: username of the PostgreSQL read-only user you created previously
  • User Password: password of the PostgreSQL read-only user you created
  • Database Name: name of your PostgreSQL database

Query comment

To provide more context to where queries to your data source are coming from, Chartio includes metadata to any queries we send; it looks similar to the following:

{
	"reason":"chart_editor",
	"user_email":"support@chartio.com",
	"datasource_id":123456,
	"dashboard_slug":"my-dashboard",
	"chart_id":1234567,
	"datasource_alias":"my data source",
	"organization_id":12345,
	"dataset_id":1231231,
	"is_manual":false,
	"dataset_name":"Dataset 1",
	"dashboard_id":456456
}