Connect to Turbot Pipes with pgcli

Since your Turbot Pipes workspace is just a PostgreSQL database, you can use pgcli to query your workspace database.

You can get the information needed to connect to your Turbot Pipes database instance from the Query tab for your workspace. On the Query tab, click the info button at the top of the query window to show the connection information. You can get the pgcli command from the Terminal tab:

Note that the connection string includes your password. It is masked in the web console display, but you can hover over the command and click the clipboard icon to copy it so you can paste it into your terminal.