Metabase

Metabase is an open-source business intelligence tool that lets non-technical users explore data without writing SQL. Connect it to a database, and a product manager or operations lead can build charts, filter records, and set up automated reports by clicking through a visual interface. For technical users who prefer SQL, a full editor sits alongside the visual query builder.

The open-source version is free to self-host with no user limits. It supports over 20 data sources including PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, and MongoDB. Dashboards can be set up to deliver scheduled email or Slack digests, and individual charts can be embedded in other applications. An AI SQL generation feature helps draft and explain queries for users who are partway between clicking and writing.

The cloud option starts at $100/month plus $6 per user per month. For most self-hosters, a Docker deployment sidesteps this entirely.

A few constraints are worth knowing. The AGPL-3.0 licence means embedding Metabase charts into a commercial SaaS product for your own customers requires a paid commercial licence. Features like row-level data permissions (sandboxing), SAML SSO, and audit logs are available only on paid plans regardless of whether you self-host or use the cloud. For teams that only need dashboards and data exploration internally, the open-source version covers most use cases.

With 47.5k GitHub stars, Metabase has one of the largest communities of any self-hosted BI tool, which translates to good documentation, active forums, and a wide range of tutorials.

Metabase: Pros & Cons