I just put something similar together but then on top of Openbao which generates temporary credentials/roles for Postgres. I created a website where people can request access and a specific group of people can approve the approve. After being approved, the database users can request temporary credentials in OpenBao for a specific number of hours.