Yeah, that's pretty much how it works. The frontend is anything that supports PostgreSQL as a database. Right now we use Tableau but we also used to have a custom WebUI on top of this service, it was very functional-inspired.
Unfortunately Ville is on vacation right now, otherwise he'd be glad to dive more into the details of how that piece worked.