Heroku + Steampipe

Heroku is a cloud platform as a service (PaaS) supporting several programming languages.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

List instances in your Heroku account:

select
  name,
  web_url,
  updated_at
from
  heroku_app

+--------+-------------------------------+---------------------+
| name   | web_url                       | updated_at          |
+--------+-------------------------------+---------------------+
| my-app | https://my-app.herokuapp.com/ | 2021-08-28 18:44:51 |
+--------+-------------------------------+---------------------+

Documentation

• Table definitions & examples →

Get started

Install

Download and install the latest Heroku plugin:

steampipe plugin install heroku

Credentials

No credentials are required.

Configuration

Installing the latest heroku plugin will create a config file (~/.steampipe/config/heroku.spc) with a single connection named heroku:

connection "heroku" {
  plugin  = "heroku"
  email   = "ryan@dundermifflin.com"
  api_key = "34c12972-9d18-421c-3ae5-5293ae1507be"
}

• email - Email address of the Heroku user.
• api_key - API key (or password) of the Heroku user.

Get involved

• Open source: https://github.com/turbot/steampipe-plugin-heroku
• Community: Slack Channel