Connect to Turbot Pipes from RazorSQL

RazorSQL is a SQL IDE to query, edit, browse 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 RazorSQL -- 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 RazorSQL 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

RazorSQL is available to use on the desktop; there's a 30 day free trial. In this example we will create a Turbot Pipes connection with RazorSQL and query the best stories from Hacker News.

To establish a new connection click on Connect to a Database, select PostgreSQL and click Continue. Enter the Turbot Pipes connection details, and click Connect.

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

Here we select the hackernews_best table. RazorSQL displays the table's schema and previews the data.

Run your first custom query

RazorSQL provides a SQL editor that you may use to write custom queries. However, it requires the Schema name and the Database name to be prefixed before the table name. Here is a query to fetch new stories by score.

select
  *
from
  <DatabaseName>.hackernews.hackernews_new
order by
  score desc