{"repo":"justwatchcom/sql_exporter","free":true,"listed":false,"github":"https://github.com/justwatchcom/sql_exporter","clone":"git clone https://github.com/justwatchcom/sql_exporter.git","description":"Flexible SQL Exporter for Prometheus.","language":"Go","stars":501,"topics":["prometheus","prometheus-exporter","sql","postgresql","kubernetes","snowflake","clickhouse","athena","mysql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Prometheus SQL Exporter This repository contains a service that runs user-defined SQL queries at flexible intervals and exports the resulting metrics via HTTP for Prometheus consumption. Status ====== Actively used with PostgreSQL in production. We'd like to eventually support all databases for which stable Go database drivers are available. Contributions welcome. Currently supported: - Postgres - ClickHouse - AWS Athena - MS-SQL - MySQL - Snowflake - Vertica - Materialize - CloudSQL What does it look like? ======================= Getting Started =============== Create a config.yml and run the service: Running in Docker: Manual scrape configs snippet: Flags ----- Name Description -------- ------------ version Print version information web.listen-address Address to listen on for web interface and telemetry web.telemetry-path Path under which to expose metrics config.file SQL Exporter configuration file name Environment Variables --------------------- Name Description -------- ------------ CONFIG Location of Configuration File (yaml) Usage ===== We recommend to deploy and run the SQL exporter in Kubernetes. Kubernetes ---------- See examples/kubernetes. Grafana ------- See examples/grafana. Prometheus ---------- Example recording and alerting rules are available in examples/prometheus. Configuration ------------- When writing queries for this exporter please keep in mind that Prometheus data model assigns exactly one float to a metric, possibly further identified by a set of ze","default_branch":null,"files":null,"tree":[],"storefront":"/r/justwatchcom","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/justwatchcom/sql_exporter/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}