Metabase
Business intelligenceLet your team ask questions of company data without writing SQL.
Metabase is built for the people in a company who need numbers from the database but do not write SQL. An admin connects the data once, and colleagues explore it by clicking, save what they find as charts and dashboards, and share it by link, email or Slack. Analysts who prefer SQL can write it directly in the same tool.
- Build questions with a point-and-click query builder, or write SQL in the built-in editor.
- Connect PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake, MongoDB and other officially supported databases.
- Self-host with Docker or the JAR file under the AGPL, with PostgreSQL or MySQL for the app database.
What people use it for
Let sales and ops answer their own data questions
Connect your PostgreSQL or MySQL database as an admin, then have colleagues pick a table in the query builder, add filters and a summary, and save the chart. Those who know SQL can switch to the SQL editor for harder queries.
Build a weekly KPI dashboard
Save several questions to one dashboard, add filter widgets that apply to all of them, and set an email or Slack subscription to deliver it on a schedule. The dashboard can also auto-refresh on a wall screen.
Get warned when a number moves
Save a question such as daily failed payments, choose Create an alert, and pick a trigger such as any result or crossing a goal line. Metabase checks it on your schedule and notifies you by email or Slack.