Skip to content
aiarabicdev

Search

Search every tool...

Open source alternatives
Free tierAGPL-3.0, with an enterprise edition under a commercial licenseClojureSelf hostable

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/metabase

Charts 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.

Last checked: .md