Buildkite + Steampipe

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

Buildkite is a platform for running fast, secure, and scalable continuous integration pipelines on your own infrastructure.

Example query:

select
  number,
  state,
  branch,
  blocked
from
  buildkite_build
where
  blocked
  and created_at > now() - interval '1 day';

+--------+-----------+--------+---------+
| number | state     | branch | blocked |
+--------+-----------+--------+---------+
| 1      | scheduled | master | true    |
+--------+-----------+--------+---------+

Documentation

• Table definitions & examples →

Get started

Install

Download and install the latest Buildkite plugin:

steampipe plugin install buildkite

Configuration

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

connection "buildkite" {
  plugin = "buildkite"
  token  = "f7c8ce159f8e65f8f9abf0e655aa1b1afa5cef0c"
}

• token - Buildkite API token.

Environment variables are also available as an alternate configuration method:

• BUILDKITE_TOKEN

Permissions

The token should be assigned read permissions:

• read_agents
• read_artifacts
• read_build_logs
• read_builds
• read_job_env
• read_organizations
• read_pipelines
• read_teams
• read_user

Get involved

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