# Metabase

> Open source business intelligence and embedded analytics platform that lets teams query, visualize, and explore data without writing code.

Metabase is an open source analytics platform that enables teams to query databases, build dashboards, and share insights without requiring SQL expertise. It supports self-service business intelligence for internal teams as well as embedded analytics for customer-facing reporting. Metabase connects to 20+ databases and data warehouses and can be deployed on your own infrastructure or as a managed cloud service. The platform includes Metabot AI for natural language querying and a new Data Studio workbench for analysts to curate semantic layers and manage data dependencies.

- **Visual Query Builder** — *Build queries with clicks, no SQL required; anyone on the team can explore data and answer their own questions.*
- **SQL Editor** — *Drop into raw SQL for advanced queries, with snippet support and field filters for parameterized queries.*
- **Metabot AI** — *Ask questions in natural language, generate and debug SQL, and get AI-assisted code generation for transforms (available as an add-on).*
- **Interactive Dashboards** — *Create filterable, drillable dashboards with cross-filters, custom click behavior, and scheduled delivery via email or Slack.*
- **Data Studio** — *Analyst workbench for defining measures, segments, SQL/Python transforms, dependency graphs, and a curated semantic layer.*
- **Embedded Analytics** — *Embed charts and dashboards in your product via iframes, Modular Embedding, or the React SDK; supports white-labeling and multi-tenant data isolation.*
- **Granular Permissions** — *Row- and column-level permissions, SSO (SAML, JWT, LDAP, Google), SCIM provisioning, and collection-level access controls.*
- **20+ Data Source Connectors** — *Connect to PostgreSQL, MySQL, BigQuery, Redshift, Snowflake, MongoDB, ClickHouse, Databricks, and many more.*
- **CSV Upload & Built-in Storage** — *Upload CSVs directly or use built-in managed storage without needing a separate ETL pipeline.*
- **Usage Analytics** — *Track which dashboards and questions are being viewed, downloaded, and subscribed to for compliance and governance.*
- **Serialization & Environment Management** — *Export and import instance configurations for staging/production parity and Git-based workflows.*
- **Open Source Core** — *Self-host for free under the AGPL license; upgrade to a paid cloud or commercial plan for managed hosting and advanced features.*

## Features
- Visual query builder (no SQL required)
- SQL editor with snippets and field filters
- Metabot AI for natural language querying
- Interactive dashboards with drill-through
- Data Studio semantic layer workbench
- Embedded analytics with React SDK
- White-label analytics
- Row- and column-level permissions
- SSO (SAML, JWT, LDAP, Google Auth)
- SCIM account provisioning
- 20+ database and data warehouse connectors
- CSV upload and built-in storage
- Usage analytics
- Serialization for environment management
- Scheduled delivery via email and Slack
- Automatic x-ray reports
- Query and model caching
- Multi-tenant data segregation
- Python and SQL transforms
- Dependency graph and diagnostics

## Integrations
PostgreSQL, MySQL, BigQuery, Amazon Redshift, Snowflake, MongoDB, ClickHouse, Databricks, Microsoft SQL Server, Oracle, MariaDB, DuckDB, Druid, Presto, Apache Pinot, Google Sheets, Cube.js, Dremio, Exasol, Materialize, Slack, Google Auth, Okta (SAML), Auth0 (SAML), Keycloak (SAML)

## Platforms
WEB, API, CLI

## Pricing
Open Source, Free tier available

## Version
v0.59.4

## Links
- Website: https://www.metabase.com
- Documentation: https://www.metabase.com/docs/latest/
- Repository: https://github.com/metabase/metabase
- EveryDev.ai: https://www.everydev.ai/tools/metabase