Open Report › Open source AI ad-hoc analysis tools

Open source AI ad-hoc analysis tools, compared

AI ad-hoc analysis means asking your data a one-off question in plain words and getting the answer, without writing SQL or waiting for a report. Five open source projects do it today, in quite different ways. We make one of them, so judge the facts, not the order.

Side by side

 Open ReportMetabaseSupersetWren AIVanna
What it isReporting tool with AIBI tool with AIBI toolAI layer for text-to-SQLPython library
LicenceAGPL-3.0AGPL-3.0 (open source edition)Apache 2.0Apache 2.0 (open core)MIT
AI in the free editionYes: questions, reports and chartsYes: MetabotNo assistant; optional MCP server for an outside AI clientSemantic layer, text-to-SQL and MCP server; the full app is commercialYes, as code you integrate
Answers on a shared modelYes: joins and measures defined onceModels and metricsDatasets and metricsYes: MDL semantic layerTrained on your schema and examples
Reports and dashboardsMulti-page reports, built by hand or by the AIDashboardsDashboardsIn the commercial appNo
Which AI modelYours: Ollama, LM Studio, any OpenAI-compatible serverYour own model key, or Metabase’s managed AIThe AI client you connectOpenAI-compatible endpointsAny model you call from your code

Open Report

Ask in any language and get the answer with its chart, or describe a report and the AI builds it, pages and design included. Row-level security applies to the AI as to any reader, and the administrator chooses what it may read. Young project, version 0.x. How it works.

Metabase

The mature choice: Metabot answers questions and writes SQL in every edition, open source included, with your own model key. Larger community and many more connectors than Open Report. Open Report vs Metabase.

Apache Superset

A strong tool for SQL users, with no assistant of its own: since version 5.0 an optional MCP server lets Claude, ChatGPT or another AI client query it. Open Report vs Superset.

Wren AI

Built around a semantic layer for text-to-SQL, released under Apache 2.0 with an MCP server; the full GenBI application is sold as a cloud or enterprise product.

Vanna

A Python library to add text-to-SQL to your own application, under the MIT licence. Its main repository was archived in March 2026, so plan for maintaining it yourself.

How to choose

Questions

What is AI ad-hoc analysis?

Answering a one-off question about your data by asking it in plain words, instead of writing SQL or building a report first.

Can I run AI ad-hoc analysis without sending data to OpenAI?

Yes. Open Report works with a local model through Ollama or LM Studio, so neither the questions nor the data leave your servers.

Is this comparison neutral?

No comparison written by one of the projects is. We checked each fact against the projects’ own pages in November 2026; tell us on GitHub if something has changed.

See also AI data analysis · Self-hosted AI analytics · vs Metabase