I work for VividCortex[0] and this looks similar to what we're doing for MySQL. It's not an open-source service but you may get some ideas of what can be done.

[0] https://vividcortex.com/

I was going to ask the same question