Grafana + Steampipe

Grafana is a cloud hosting company that provides virtual private servers and other infrastructure services.

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

List dashboards in your Grafana account:

select
  id,
  title,
  url
from
  grafana_dashboard

+----+--------------+---------------------------+
| id | title        | url                       |
+----+--------------+---------------------------+
| 3  | my dashboard | /d/Y4EbrQV7k/my-dashboard |
+----+--------------+---------------------------+

Documentation

• Table definitions & examples →

Get started

Install

Download and install the latest Grafana plugin:

steampipe plugin install grafana

Configuration

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

connection "grafana" {
  plugin = "grafana"

  # URL of the Grafana installation
  url = "http://localhost:3000"

  # Authentication - API key
  auth = "eyJrIjoidGQ3VlMwVjlFVVc1TVNncjVWNGVYZnNDcaZIQkp2U2giLCJuIjoidGVzdDIsImlkIjoxfQ=="

  # Alternate authentication - username and password
  # auth = "admin:admin"
}

• url (required) - Root URL of a Grafana server. May alternatively be set via the GRAFANA_URL environment variable.
• auth (required) - API token or basic auth username:password. May alternatively be set via the GRAFANA_AUTH environment variable.
• ca_cert - Certificate CA bundle to use to verify the Grafana server's certificate. May alternatively be set via the GRAFANA_CA_CERT environment variable.
• insecure_skip_verify - Skip TLS certificate verification. May alternatively be set via the GRAFANA_INSECURE_SKIP_VERIFY environment variable.
• org_id - The organization id to operate on within grafana. May alternatively be set via the GRAFANA_ORG_ID environment variable.
• tls_cert - Client TLS certificate file to use to authenticate to the Grafana server. May alternatively be set via the GRAFANA_TLS_CERT environment variable.
• tls_key - Client TLS key file to use to authenticate to the Grafana server. May alternatively be set via the GRAFANA_TLS_KEY environment variable.

Get involved

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