Can this be queried with Grafana or some other visualization tool?
We internally use Grafana through a REST interface to a timescale backend. (And in fact, that's how we visualize the Prometheus data we store in Timescale: https://github.com/timescale/pg_prometheus )
But, Grafana Labs is still working on a native Postgres connector (MySQL released earlier this year). They promise us soon :)