Noteable

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.

Now, select PostgreSQL

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.

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.

That's all!