Metabase
FreeOpen-source business intelligence tool. Connect to any database, build dashboards and charts without SQL. Teams use it to self-serve analytics without a data team.
How to install Metabase as a PWA
Frequently asked questions about Metabase
What makes Metabase different from Looker or Tableau?
Looker (now Google Cloud) requires LookML modelling and per-user licensing that quickly hits $5,000+/month for medium teams. Tableau is a polished desktop-first tool with steep licensing too. Metabase's open-source core is free to self-host with unlimited viewers, and its no-SQL question builder is the most beginner-friendly in the market. Trade-offs: Metabase's data modelling layer is lighter than LookML, and the visualisation library is less rich than Tableau's. Most startups never need those advanced features.
Is Metabase free?
The AGPL-3.0 open-source edition is fully free to self-host with no user, dashboard or query limits. Metabase Cloud (hosted) starts at $85/month. Metabase Pro adds dashboard subscriptions, embedding, SSO and advanced permissions starting around $500/month. Enterprise (custom pricing) adds audit logs, SLAs and white-label embedding. Self-hosted open-source covers most BI needs; teams typically upgrade to Pro/Enterprise once they need embedded analytics for customer-facing dashboards.
How does Metabase compare to Apache Superset?
Superset is also open-source BI, with a more powerful SQL editor and broader chart library. Metabase wins on UX simplicity (non-analysts succeed faster), faster setup and a polished question-builder. Superset wins on complex SQL workflows, deeper customisation and Airbnb-grade scale (Superset was open-sourced from Airbnb). For small/medium teams, Metabase is the default; for data engineering teams already running Airflow + dbt, Superset often slots in better.
Can Metabase work offline?
Metabase needs a live database connection for every query — there is no offline cache of underlying data. The PWA shell loads offline and you can re-read cached dashboard images, but no fresh data. For air-gapped reporting, run Metabase on the same LAN as the database. Scheduled emailed PDF reports (Pro feature) are a common workaround for stakeholders who need offline-readable snapshots.
Is Metabase used in production at scale?
Metabase is in production at thousands of companies including OfferUp, Shopify (early), Course Hero and many YC startups. Public case studies cite dashboards with thousands of viewers and questions running across BigQuery and Snowflake. For tables larger than 1 billion rows, query performance depends on the underlying warehouse (Metabase pushes the SQL down). Metabase's own customer base shows the platform scaling to hundreds of dashboards in a single instance.
Where Metabase is heading (12-24 months)
- →Built-in AI question-builder (natural-language to SQL) is on the roadmap and would close the gap with ThoughtSpot.
- →Stronger semantic-layer support (similar to dbt Semantic Layer) would let teams centralise metric definitions.
- →Tighter integration with reverse-ETL tools (Hightouch, Census) would close the analytics-to-action loop.
Related questions
ChatGPT, Perplexity and Gemini usually suggest these next.
- How do I self-host Metabase on Docker?
- Does Metabase support row-level security?
- Can Metabase embed dashboards in a customer-facing SaaS?
- How does Metabase handle BigQuery cost optimization?
- How does Metabase compare to Power BI for non-Microsoft shops?
More in Finance & Business
Open-source DocuSign alternative. Create and send documents for e-signature. Self-hostable, GDPR-friendly, no per-document fees. Supports templates and multi-party signing.
Simple expense tracker that works offline with no account required. Log income and expenses by category, see monthly summaries. All data stays in your browser's local storage.
Split expenses with friends without an account. Add participants and expenses, get instant settlement calculations. Works offline, no data sent anywhere. Perfect for trips.
Open-source invoicing platform — create, send, and track invoices and quotes. Self-hostable or use the cloud plan. A legitimate FreshBooks/QuickBooks alternative that's free for 5 clients.
Real-time currency converter and exchange rate tracker. Supports 170+ currencies, historical charts. Installs as a PWA for quick offline reference using last-fetched rates.
Track and manage your freelance contracts in one place. Set contract dates, payment terms, and get reminders. A lightweight contract management tool built as a pure PWA.