Metabase

Metabase is an open-source business intelligence and analytics platform for querying databases, building dashboards, sharing reports, and embedding analytics into applications. It supports both a visual query builder for self-service analysis and a native SQL editor for analysts who want direct query control.

1. Analytics workflow: users can join, filter, summarize, and visualize data through the graphical query builder or write native SQL. Saved questions, models, metrics, and dashboards provide reusable analytical building blocks, while curated metrics can define shared calculations for wider self-service use.
2. AI assistance: Metabot answers natural-language questions about connected data, creates query-builder charts, generates and edits SQL, fixes query errors, and analyzes existing visualizations. It operates within the data and content permissions available to the person using it, and administrators can control AI access and usage.
3. Implementation checks: buyers should assess database connectivity and credentials, semantic modeling, group permissions, row and column security, SSO, embedding requirements, hosting responsibility, and AI-provider configuration. Self-hosted organizations using Metabot must currently supply their own supported AI-provider credentials.
4. Commercial considerations: Metabase offers a free self-hosted Open Source edition alongside Starter, Pro, and Enterprise plans. AI capabilities are now available across all plans, while features such as row and column security, SAML/JWT/OIDC SSO, authenticated modular embedding, tenant isolation, usage analytics, and more advanced administration are concentrated in Pro and Enterprise.

Metabase is particularly relevant to teams that want approachable self-service analytics without removing SQL access, while retaining the option to self-host, build a governed semantic layer, or embed analytics into customer-facing applications.