[bacondude3]

I've used Google Data Studio + Heroku Postgres for a similar purpose. Works great, but I wish there were an OSS alternative to Data Studio.

[acidbaseextract]

Check out https://github.com/metabase/metabase . I'm not clear on their open source vs paid model, but I'm pretty sure you can host it yourself and their core is open source.

[bacondude3]

Looks promising. Thanks!