Connect to Turbot Pipes from HeidiSQL

HeidiSQL is a database tool to query, edit and manage your 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 HeidiSQL -- can connect to.

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.

Once the connection to Turbot Pipes is established and tested, you can access the tables provided by the Steampipe plugins, run queries and build reports.

You can also connect HeidiSQL 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.204
  Port:               9193
  Database:           steampipe
  User:               steampipe
  Password:           99**_****_**8c
  Connection string:  postgres://steampipe:99**_****_**8c@localhost:9193/steampipe

Getting started

HeidiSQL is a program that runs on Windows. In this example we will create a Turbot Pipes connection with HeidiSQL and query the top stories from Hacker News.

To establish a new connection click on New at the bottom left, select PostgreSQL(TCP/IP) and enter the Turbot Pipes connection details, check the Use SSL box under the SSL tab and click Open.

Once you've connected to Turbot Pipes, you can access the Hacker News plugin and its tables from the Database explorer.

Here we select the hackernews_top table. HeidiSQL displays the table's schema and previews the returned data. You can drag the columns to rearrange the data, then save to CSV, HTML, XML, LaTeX, Wiki markup or PHP.

Run your first custom query

HeidiSQL provides a SQL query editor that you may use to write a custom query. For example, we can use this query in the editor to fetch the list of top stories with most comments.

select
  *
from
  hackernews_top
order by
  descendants desc