Metabase

Metabase is the most widely adopted open-source BI platform: a free, self-hostable tool that lets technical and business users query data, build visualizations, and share dashboards. Its visual question builder lets non-technical users explore with clicks instead of SQL, while analysts get a clean SQL editor.

Unlike most BI vendors, Metabase ships AI natively across every edition including open source: Metabot handles natural-language querying, SQL generation and debugging, and one-click summaries, with an official MCP server and AI-assisted SQL/Python in Data Studio. Governance controls like token limits and usage auditing come on Pro/Enterprise. The company states it doesn't charge extra for AI or gate it behind premium tiers, and teams can bring their own model provider key.

Pricing: open source is free and unlimited (self-hosted); Starter cloud is ~$85-90/month for 5 users; Pro ~$500-517/month for 10 users; Enterprise custom (~$15,000-20,000/year). Caveats: no built-in transformation layer (model upstream with dbt), row/column-level security sits in paid tiers, and self-hosting carries real operational cost (one analysis estimated $16,000-36,000/year all-in). Embedding via signed tokens and the modular SDK is a common SaaS use case.

Self-host via Docker/JAR (free, unlimited users) or sign up for Metabase Cloud. Connect your database; business users explore with the visual question builder while analysts write SQL. Enable Metabot for natural-language querying; bring your own LLM key or use Metabase's hosted AI service.