noteable.io supports Postgres & supports both Python and SQL shells, plus provides excellent data visualization. Connecting to bit.io is easy!

First, click on the Data Connections icon on the left, then + to add a new connection.

580580

Now, select PostgreSQL

16861686

Fill out the fields - host is db.bit.io, port is 5432, SSL should be set to require. You can get your username, password, and DB name from the Connect tab on your database page.

16901690 18901890

Save and done!

To use this connection, create a SQL cell in any notebook. Then, using the drop down next to SQL in the cell, pick bit.io as your datasource, and just start writing SQL.

758758 22782278

That's all!