The bit.io Developer Hub

Welcome to the bit.io developer hub. You'll find comprehensive guides and documentation to help you start working with bit.io as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Connecting via SQL Clients

Once you've gotten a connection password through our website (see here for instructions on how to get a connection), you're ready to start connecting to bit.io through your preferred Postgres client. Below we've provided guides to for several of the clients we support.

psql

Once you get a connection password from our webpage, you can connect to bit.io through psql. You can either provide the url postgresql://your_connection_name:[email protected]:

or provide the host (db.bit.io), port (5432), and password (your connection password) to psql:


Tableau

You can connect to Tableau via JDBC by selecting Other Databases (JDBC) and providing the url jdbc:postgresql://db.bit.io:5432/bitdotio as shown below:


DataGrip

To connect to DataGrip via JDBC, you just need to provide to provide the host (db.bit.io), port (5432), and password (your connection token), as shown below:


PopSQL

Create a new connection in PopSQL. Then, fill in the fields using the information provided by the "Connect" button on any https://bit.io repo page.

The only fields that are necessary to copy are hostname and password. "Port" can remain the default (5432). Both "database" and "username" can be anything, they're irrelevant.


Postico

Create a new connection in PopSQL. Then, fill in the fields using the information provided by the "Connect" button on any https://bit.io repo page.

Only "Host" and "Password" are required. The other fields can remain blank.

Updated 2 months ago


Connecting via SQL Clients


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.