Open Report › AI data analysis
Ask your data in plain words
Type a question about your data, in any language, and Open Report answers with the figures and the chart that shows them.
Ad-hoc analysis without SQL
- Ask “which region grew the most this year?” and read the answer, then ask the next question.
- The AI writes the query on your semantic model, so a revenue figure means the same thing in every answer.
- Each answer can show its chart, its table, or a comparison with last year.
- Keep an answer: add it to a report in one click, or ask for a whole report and the AI builds it page by page.
On your databases and files
PostgreSQL, MySQL, SQL Server, Azure SQL, Oracle, Snowflake, BigQuery, Databricks, ClickHouse and Redshift, or a CSV or Excel file dropped into the chat.
With the rules you already set
- Row-level security applies to the AI as to any reader: it only sees the rows that user may see.
- The administrator decides what the AI may read: field names only, cached aggregates, or query results.
- Plug in the model you want, including a local one, so the questions never leave your servers.
Where a number comes from
Ask the AI where a figure comes from: it answers from the lineage stored in OpenMetadata, column by column, back to the source tables.
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 waiting for someone to build a report.
Is it natural language to SQL?
Yes, but on a semantic model rather than on raw tables: the AI picks dimensions and measures defined once, so joins and calculations stay correct.
Which languages can I ask in?
Any language the AI model you plug in understands. Open Report never reads your question with keyword lists.
Is it free?
Yes. The self-hosted edition is free and open source under the GNU AGPL-3.0, AI assistant included. You bring the AI model, or a free local one.
See also AI report generator · Self-hosted AI analytics · vs Power BI