WHAT IS IT?
Metabase is an open source business intelligence platform that makes data accessible to non-technical users. Clojure backend, React/TypeScript frontend, it ships a visual query builder, a native SQL editor and shareable dashboards, all deployable in five minutes through Docker or a JAR.
WHY IS IT INTERESTING?
- No-code query builder: step-by-step interface to filter, aggregate and join tables without writing a single line of SQL. Perfect for marketing, product or ops teams who shouldn't have to queue behind the data team.
- SQL Editor for pros: those who want raw SQL get a full editor with variables, parameters and Mustache templating for dynamic queries.
- Interactive dashboards: global filters, drill-down, full-screen and auto-refresh. Users can share, schedule or subscribe colleagues to results.
- Embedded analytics: signed iframes or an official SDK to embed charts and dashboards into a SaaS app, with fine-grained role-based security.
- Alerts and subscriptions: automatically push tables or charts to email/Slack whenever a threshold is crossed.
- Quick setup: a single JAR or container, native support for 20+ databases (PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, MongoDB...) plus community-built drivers.
USE CASES
- Give business teams access to data without making everyone learn SQL.
- Build an internal reporting portal shared across leadership, product and finance.
- Embed customer-facing dashboards inside a SaaS application to offer analytics without building it from scratch.
- Set up data alerts (KPI drops, anomalies, business thresholds) to react fast without watching dashboards all day.