Omnibus installation - Accesing PostgreSQL DB for dashboard

I have GitLab running self-hosted with the Omnibus packages. I’m using mostly the default settings, so the DB access is done through sockets, not TCP/IP.

I’d like to connect [Metabase])(https://www.metabase.com) to GitLab’s database in order to create some dashboards displaying aggregated health data of our company’s project (how many of the projects have CI configured, how many MRs are being rejected, etc.)

Is there anyone doing something like that? Is it possible to create an additional postgres user with read-only access to the DB, to prevent Metabase from damaging the data?
What’s the recommended path to do it?

I briefly considered doing this through the API, but did not find a way to gather the data I need.

I meet the same problem! Any help? @pgb

I’ve worked around this by taking a DB snapshot from our daily backup and uploading it to a DB mirror somewhere else.

You get a day old data, but it’s safer as nothing is touching Gitlab’s DB

Thanks!
Why don’t you use the RESTFull API of GitLab?It is more safe and more easy.
I am trying to use superset with GitLab’s API.
@pgb

Because Metabase only supports SQL sources. When / if they add REST API support as data sources, I’ll take a look again.

I get it!