Docs
The Postgres door
On Paid, the whole thing answers as a Postgres database, so your BI tool connects the normal way.
Metabase, Power BI, Tableau, Looker Studio, Excel: anything that speaks Postgres. On the Paid plan Overscore opens a door: a host, a port, a user called warehouse and a password shown once. Point the tool at it and every table, model and worklist is there, read-only.
What to know
- Read-only by construction. A BI tool can't change anything.
- The same names as the app:
shopify.order,stripe.charge, your models under their dish. - Queries run on your own machine, so a heavy dashboard in Metabase doesn't slow anyone else down.
- The password is shown once, on the Settings screen, and can be rotated there.