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, urlfrom grafana_dashboard
+----+--------------+---------------------------+| id | title | url |+----+--------------+---------------------------+| 3 | my dashboard | /d/Y4EbrQV7k/my-dashboard |+----+--------------+---------------------------+
Documentation
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 theGRAFANA_URL
environment variable.auth
(required) - API token or basic auth username:password. May alternatively be set via theGRAFANA_AUTH
environment variable.ca_cert
- Certificate CA bundle to use to verify the Grafana server's certificate. May alternatively be set via theGRAFANA_CA_CERT
environment variable.insecure_skip_verify
- Skip TLS certificate verification. May alternatively be set via theGRAFANA_INSECURE_SKIP_VERIFY
environment variable.org_id
- The organization id to operate on within grafana. May alternatively be set via theGRAFANA_ORG_ID
environment variable.tls_cert
- Client TLS certificate file to use to authenticate to the Grafana server. May alternatively be set via theGRAFANA_TLS_CERT
environment variable.tls_key
- Client TLS key file to use to authenticate to the Grafana server. May alternatively be set via theGRAFANA_TLS_KEY
environment variable.
Get involved
- Open source: https://github.com/turbot/steampipe-plugin-grafana
- Community: Slack Channel