Metabase
Metabase is an open-source business intelligence tool that lets people explore data, build charts, and share dashboards through a simple query builder or raw SQL.
Overview
Metabase is a business intelligence application built to make asking questions of a database approachable for non-SQL users while still giving analysts a full SQL editor when they need it. It's open source, self-hostable (as a single JAR or Docker container), and also available as a managed Metabase Cloud offering. Typical use: connect a warehouse or database, build "Questions" via the point-and-click query builder or native SQL, arrange them into dashboards, and set up scheduled alerts or email/Slack subscriptions.
Core building blocks
- Questions: individual charts or tables, built either through the GUI query builder or a SQL editor.
- Dashboards: collections of Questions with shared filters, laid out for a specific audience.
- Models: curated, reusable views on top of raw tables that give the query builder cleaner columns and pre-applied logic.
- Data permissions: row- and column-level access control per group, useful for exposing self-service analytics without giving everyone raw table access.
Copy code
-- A typical native-SQL question in Metabase
SELECT
date_trunc('week', order_date) AS week,
sum(order_total) AS revenue
FROM orders
GROUP BY 1
ORDER BY 1;
Metabase and DuckDB
MotherDuck maintains an open-source Metabase driver (metabase_duckdb_driver) that adds DuckDB as a native database type inside Metabase. Installed as a plugin JAR on a self-hosted instance, it lets Metabase query local DuckDB files, in-memory databases, DuckLake, and MotherDuck cloud databases directly — connecting to MotherDuck by entering md:<database_name> as the database file and supplying a MotherDuck authentication token. Because custom drivers aren't supported on Metabase Cloud, this integration currently requires a self-hosted Metabase instance.
Related terms
MotherDuck is a cloud-based analytics platform built on top of DuckDB that enables teams to analyze and share data without managing complex infrastructure.
dashboard →A dashboard is a visual display of key metrics, data points, and analytics that provides a quick overview of an organization's performance or a specific…
Business Intelligence (BI) →Business Intelligence (BI) refers to the technologies, applications, and practices used to collect, integrate, analyze, and present business information.
SQL analytics →SQL analytics refers to using SQL queries to analyze data and derive insights, typically working with large datasets stored in databases or data warehouses.
MotherDuck extension →The MotherDuck extension is a component of DuckDB that enables seamless integration with the MotherDuck cloud service.
query →A query is a request made to a database to retrieve, modify, or analyze data.
FAQS
Metabase's open-source edition is free to self-host. Metabase also sells paid Pro and Enterprise plans, plus a managed Metabase Cloud offering, with additional governance and collaboration features.
Yes, via a community driver maintained by MotherDuck that adds DuckDB as a native connection type, including support for connecting to MotherDuck cloud databases. It requires a self-hosted Metabase instance.
No. Metabase's query builder lets you filter, aggregate, and join data without writing SQL, though a full SQL editor is available for more complex questions.
