Metabase
The most widely deployed open-source BI tool, Metabase is a visualization and query layer that
sits on top of your existing databases without ingesting or copying data. Non-technical users
ask questions through a visual query builder with drill-through menus that answer follow-ups
like "broken down by month" without writing a new query, while analysts use the native SQL
editor with variables and templates for complex work. Questions assemble into interactive
dashboards with filters, auto-refresh, fullscreen mode, and custom click behavior, and
dashboard subscriptions email or Slack scheduled reports to stakeholders. It connects to 20+
data sources including PostgreSQL, MySQL, MongoDB, SQL Server, BigQuery, Snowflake, Redshift,
and ClickHouse - always querying in place, so there is no second data store to secure, sync,
or pay for, and results are always current. Models and metrics let a data team define
official, reusable starting points so self-service stays consistent, collections with
permissions organize content, and alerts fire when a metric crosses a threshold. The practical
effect is cutting the ad-hoc query queue that lands on the data team, since non-technical
staff can answer their own questions. Written in Clojure, licensed AGPL, and shipped as a
single JAR or Docker image with an embedded application database - a working BI instance runs
before most tools finish their installer - the open-source edition has no limits on users,
dashboards, or connected databases, where commercial BI platforms price per viewer as well as
per creator.
Deploy