Connecting via SQL Clients

Once you've gotten a connection password through our website, 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 connect easily using the Connection String from the Connect tab of your database page. Connect with psql <your_connection_string_here>

Alternately, you can provide the hostname, port, username, database name, and password to connect with psql. All of these details are available from the Connect tab.

PopSQL

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

Beekeeper Studio

Select "Postgres" from "Select a connection type..." in the new connection menu. Copy the connection details from the "Connect" menu

Postico

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

Tableau Desktop (see below for Tableau Online)

You can connect to Tableau via JDBC by selecting PostgreSQL in the "Connect to a Server" menu and filling in the details from your database page's Connect menu.