PostgreSQL

Create your PostgreSQL connection.

You can create your PostgreSQL connection from either your team's dashboard or directly inside a spreadsheet. From the Dashboard, navigate to the Connections menu item. Or from inside a spreadsheet, press / and then Manage connections.

Connection details

To connect to your PostgreSQL database, you'll need to enter the parameters in the Team connections modal:

Connection name

You can name your connection however you'd like. This is the display name for your connection across Quadratic and your team.

example: Sales Database

Host name

This is the connection host, the direct connection to your database. It can be an IP address or URL. You might see a connection string that looks something like this:

postgres://default:[e-mail]:5432

The hostname is the IP address or URL. From the above connection string, this would be the host, which you would add to the Hostname field:

postgres-hostname.com

Port number

This is the connection port; you might see it at the end of your hostname after the colon. It is typically a four-digit number. From the above example, add this number to the Port field. 5432 is the default port number for Postgres.

5432

Database name

This is the name of the database you want to connect to. Your database can have multiple tables - be sure to use the database name and not the name of a table. Example database name:

postgres_db

Username

This is an authentication detail that depends on your database account username. Some common defaults include admin or default. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example:

admin

Password

This is the password you use to connect to your database. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example:

1234abcd

IP allow-list

Databases behind a firewall may require you to whitelist Quadratic IP addresses, which are: 44.240.255.40 54.68.134.35

* These IP addresses do not apply to self-hosted instances

If you need help setting up your data sources, contact us. Some extra resources and instructions vary depending on where your database lives.

AWS, Azure, GCP

Once you've made your connection, you can use it directly in spreadsheets to read data to your spreadsheets. Learn how here.