same way you'd insert data into postgres.
I'd assume that most anyone building a system like this at scale has to solve these problems; does everyone roll their own?
Timescale builds connector and entire workflow to run Prometheus on top of TimescaleDB and support Grafana in flexible way: https://github.com/timescale/timescale-prometheus