I'm thinking of something similar to a static site generator. You define s set of queries towards Postgres and visuals with code, check it into git, build it periodically. You can serve the pages publicly or keep them internal. All based on FOSS.