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.

The Connect in your workspace provides the Postgres connection string. Important: this string includes your password, which is masked for security in the web console. Use the Copy to copy it so you can paste it into your tool's configuration screen.

Individual users can access the database with their credentials. This information is available under the Connect tab after logging into Turbot Pipes, enabling secure, personalized access.

Examples of Postgres-Compatable 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

ToolDescription
Azure Data StudioAzure Data Studio is a cross-platform database tool for data professionals.
DataGripDataGrip is a professional SQL IDE by JetBrains, designed for database developers.
DBeaverDBeaver is a free, multi-platform database tool for developers and database administrators.
dbtdbt is a transformation tool that enables data analysts and engineers to transform data in their warehouses.
DeepnoteDeepnote is a data science notebook for collaborative projects.
DuckDBDuckDB is an in-memory SQL OLAP Database Management System.
GitpodGitpod streamlines developer workflows with prebuilt, collaborative development environments.
HeidiSQLHeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server, and PostgreSQL.
JupyterJupyter Notebook is an open-source web application for data science and scientific computing.
NavicatNavicat offers a series of graphical database management and development software.
pgAdminpgAdmin is a popular open-source administration and development platform for PostgreSQL.
pgclipgcli is a command-line interface with enhanced features for Postgres.
psqlpsql is the standard command-line tool for interacting with PostgreSQL databases.
RazorSQLRazorSQL is an SQL query tool, database browser, and SQL editor for various databases.
RStudioRStudio is an IDE that uses the R language to enable users to explore, query, and visualize data.
Steampipe CLISteampipe CLI is a command-line interface for managing and interacting with Turbot Pipes.
TablePlusTablePlus is a modern, native, and friendly GUI tool for relational databases.
Visual Studio CodeVisual Studio Code is a streamlined code editor with support for development operations.

BI Tools

ToolDescription
Apache SupersetApache Superset is an open-source business intelligence web application.
GrafanaGrafana provides open-source tools for monitoring and observability.
LookerLooker is a business intelligence software and big data analytics platform.
MetabaseMetabase is an open-source way for everyone in a company to ask questions and learn from data.
PowerBIPowerBI offers a suite of business analytics tools to analyze data and share insights.
SigmaSigma is a BI and analytics application that connects to cloud data warehouses.
TableauTableau helps people see and understand data through interactive visual analytics.

SDKs

ToolDescription
GolangGo is an open-source programming language for building simple, reliable, and efficient software.
JavaScriptJavaScript is a versatile programming language, one of the core technologies of the World Wide Web.
PythonPython is a popular programming language known for its simplicity and versatility.
RR is a programming language and environment for statistical computing and graphics.

More information about using https://turbot.com/pipes/blog/2024/01/turbot-pipes-as-software-component