Connecting to your Turbot Pipes Workspace

Turbot Pipes offers various methods to connect and query your data. Run SQL queries and save snapshot results in the Turbot Pipes UI, use the Query API for programmatic access, or connect via a PostgreSQL-compatible client for leveraging your favorite tools.

Connecting Turbot Pipes via PostgreSQL-Compatible Clients

Your Pipes workspace database is accessible from anywhere, thanks to its public IP address. Connect using the Steampipe CLI or other standard tools and utilities that support Postgres.

You can get the Postgres connection string and other database information 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.

The Database tab will provide general database connection details - the Connection String, Host, Port, Database, Username and Password. Click on any field to copy it to your clipboard. Note that the password is masked on the screen, but clicking it will add the un-redacted text to your clipboard so that you can paste it into your tool's configuration screen. Individual users can access the database with their credentials, and the information in this view is specific to the logged-in user, enabling secure, personalized access.

You can also get specific Steampipe commands from the Steampipe CLI tab:

Or retrieve the psql and pgcli commands from the Terminal tab.

Examples of Postgres-Compatible Clients

Our community leverages a diverse range of PostgreSQL clients to connect to Turbot Pipes. This flexibility accommodates different workflows, whether you prefer traditional SQL IDEs for database management, BI tools for data analysis and visualization, or programming languages and SDKs for custom integrations.

SQL IDEs

BI Tools

SDKs