Metabase
The open source dashboard tool for asking questions of your own database
Alternative toTableauLookerPower BI
Metabase connects to your databases and lets people build charts and dashboards without writing SQL, the work teams often buy Tableau, Looker or Power BI for. The open source edition is AGPL-3.0, while an enterprise edition and the hosted cloud are commercial.
Best for when
- your team keeps asking a developer for numbers from the database
- you want dashboards on top of PostgreSQL or MySQL without a BI budget
- you want analytics that stay inside your own infrastructure
Watch out for
- the default H2 application database is not for production, so use PostgreSQL from the start
- SSO, row level permissions and audit logs are paid features
- it has no deep modelling layer like Looker and fewer chart types than Tableau
Install
Run with Docker
docker run -d -p 3000:3000 --name metabase metabase/metabaseCharts for people who do not write SQL
Point Metabase at PostgreSQL, MySQL, BigQuery, Snowflake or many other sources, and anyone on the team can filter, group and chart a table through a visual query builder. Analysts can drop into SQL when they need to, and the results become dashboards, scheduled reports and alerts.
Compared with Tableau or Power BI it is much simpler to set up: one Java application, usually run with Docker, and a first dashboard can exist the same afternoon. That simplicity is the point, and it suits startups and small teams far better than a heavy BI suite.
Where it stops and what you pay
Metabase is not a full modelling layer like Looker's LookML, and its visualisations are simpler than Tableau's. Several features organisations ask for, such as SAML single sign on, row level permissions, white labelling and audit logs, are in the paid editions.
Self hosting is easy to start but has a classic trap: by default it stores its own settings and dashboards in a local H2 file, which can be lost or corrupted. For real use, point it at a PostgreSQL application database from day one, and give it a read only database user so dashboards cannot change your data.
On the same shelf
Odoo
The open source business suite for accounting, sales, stock and more
Alternative to SAP · NetSuite · QuickBooks
Twenty
The open source CRM for teams who want Salesforce power without the lock-in
Alternative to Salesforce · HubSpot CRM
Documenso
The open source DocuSign alternative for sending documents to sign
Alternative to DocuSign