Have Prometheus send a SQL Query

Question

I'm trying to use Prometheus to monitor my MySQL database but can't seem to find an area to add SQL queries. For example, I'd like to run a SQL query which returns a value and then add that value to the graph/send an alert. Is there a way to have Prometheus send SQL queries and retrieve the output?

Thank you

score 5 · Accepted Answer · answered Mar 23 '17 at 16:36

5

https://github.com/chop-dbhi/prometheus-sql will allow queries to be run against any SQL database that can then be scraped as metrics.

answered Mar 23 '17 at 16:36

brian-brazil

31,678
6
93
86

Great, thank you. And thanks for Prometheus, nice tool! – iso123 Mar 23 '17 at 16:54
Just noticed that SQLAgent requires Docker. Is there a way to run this without it? – iso123 Mar 23 '17 at 16:57
@brian-brazil , Can you help me on how to use sql-agent without using Docker? – saurav Jul 03 '18 at 14:32

Have Prometheus send a SQL Query

1 Answers1

Linked