Connecting via TablePlus

TablePlus is a SQL client that offers intuitive GUI tools for manipulating relational databases in addition to a sophisticated SQL query editor. You can download the application from the TablePlus home page.

Connecting to bit.io from TablePlus

After you've installed and opened TablePlus, you'll see a screen that looks like this:

14241424

Right click in the area on the right or click "Create a new connection" at the bottom. There are two ways to create the connection at this point.

  1. Select "Import from URL" and paste in your PostgreSQL Connection String. This can be found by signing in to bit.io, clicking "Connect" on the upper lefthand side of the page, and copying the PostgreSQL Connection String.
13841384

or

  1. Fill in the details manually. Select PostgreSQL and click "Create." Copy the connection details as shown in the "Connect" menu on the bit.io repo page.
14241424

The corresponding fields for setting up the connection are depicted below:

23322332

Once you've established the connection, you're good to go! You can select a repository from the menu on the bottom left, and view a list of tables on the left sidebar. Double-clicking a table opens it in the main workspace. From there, you can click on individual rows and edit their values in the right sidebar, or double-click on a specific cell and edit it directly.

29502950

Did this page help you?