Categories
Developer Tools Analytics Dashboard Business Intelligence Data Data Visualization Reporting SQLStars
Forks
Watchers
Developer links
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.
Benefits
- Unlimited Users at Zero License Cost
- BI platforms typically price per viewer as well as per creator. Self-hosted Metabase Open Source has no user, dashboard, or database limits, so the whole company can explore data.
- Data Stays in Your Database
- Metabase queries your databases live rather than ingesting copies, so there is no second data store to secure, sync, or pay for, and results are always current.
- Self-Service That Actually Works
- The visual query builder and automatic drill-through menus let non-technical staff answer their own questions, cutting the ad-hoc query queue that lands on the data team.
- Five-Minute Setup
- A single JAR or Docker container with an embedded application database gets a working BI instance running before most tools finish their installer.
Features
- Visual Query Builder
- Compose questions with filters, joins, aggregations, and custom expressions without SQL, then drill through results to follow-up questions.
- Native SQL Editor
- Full SQL access per database with snippets, variables, and parameterized templates that turn queries into reusable, filterable reports.
- Interactive Dashboards
- Combine questions with cross-filtering, auto-refresh, fullscreen display, custom click behaviors, and tabs for organizing related views.
- Dashboard Subscriptions and Alerts
- Schedule dashboards to email or Slack, and set alerts that trigger when a metric crosses a threshold.
- 20+ Data Sources
- PostgreSQL, MySQL, MongoDB, SQL Server, BigQuery, Snowflake, Redshift, ClickHouse, and more, queried in place.
- Models, Metrics, and Collections
- Curate official datasets and metric definitions, organize content into collections with permissions, and edit table metadata to guide self-service.