Connect to Turbot pipes from pgAdmin
pgAdmin is an open-source administration and development platform for PostgreSQL databases.
Steampipe provides a single interface to all your cloud, code, logs and more. Because it's built on Postgres, Steampipe provides an endpoint that any Postgres-compatible client -- including pgAdmin -- can connect to.
The Connect tab for your workspace provides the details you need to connect pgAdmin to Turbot pipes.
Once Turbot pipes is successfully connected, you can explore the tables provided by the Steampipe plugins, run queries and build reports.
Similarly, you can also connect pgAdmin to Steampipe CLI. To do that, run
steampipe service start --show-password and use the displayed connection details.
Steampipe service is running:Database:Host(s): localhost, 127.0.0.1, 192.168.29.204Port: 9193Database: steampipeUser: steampipePassword: 99**_****_**8cConnection string: postgres://steampipe:99**_****_**8c@localhost:9193/steampipe
pgAdmin is free and available to use on the desktop.
To create a connection choose
Register - Server under Object. Then add the connection details and keep the SSL mode as
Once you've connected to Turbot pipes, you can access the plugins and its tables from the object explorer.
Here we select the
hackernews_top table from the Hacker News Plugin. pgAdmin displays the table's schema and previews the data which can be exported into a CSV file.
Create a chart with custom query
Here we will focus on creating a chart to analyze Tesla's hourly price history using the Finance Plugin. To begin, click
Query Tool, paste this query in the command palette, then click
selecttimestamp,closefromfinance_quote_hourlywheresymbol = 'TSLA'order bytimestamp desc
pgAdmin previews the data in the table form. Now click on the
Graph Visualiser icon to open the visualize data form and select Type as
Stacked Bar Chart. Update the X asxis with
close and Y axis with
Generate to display the chart with the data.
With pgAdmin and Turbot pipes you can:
View tables in your Turbot pipes workspace
Write custom queries to preview data from the tables in your Turbot pipes workspace
Create charts driven by your custom queries