supports Postgres & supports both Python and SQL shells, plus provides excellent data visualization. Connecting to 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, 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.

1690 1890

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 as your datasource, and just start writing SQL.

758 2278

That's all!