Can I run sql queries on my server (for reporting purposes)

Help
,
1

Like for example, select count(1) from db.table1;

2

Hi :v:

Currently we don’t support queries, but using our API you can access all the charts.

3

Hi, @driggsss.

We have no generic SQL collector.

But you can write a custom python collector for your use case. There is MySQLService which can be used to execute arbitrary SQL queries. Still, you will need to implement queries result processing, creating charts, etc.

But it is not that hard as it may sound. Check this example, it is exactly your use case (I wrote it back in 2017, but I expect it to be working).