What is Frappe Insights used for?

Frappe Insights is an open-source business intelligence tool with a no-SQL query builder, charts, dashboards and support for MySQL, PostgreSQL, DuckDB and BigQuery. It is a good fit for building reports on top of ERPNext data, creating dashboards without writing SQL and combining data from several databases.

Is Frappe Insights open source?

Yes. Frappe Insights is open source under the AGPL-3.0 licence. Its source code is on GitHub at frappe/insights and is written mainly in Python.

Is Frappe Insights free?

Yes. Frappe Insights is open source, so the software itself is free to use.

Can I self-host Frappe Insights?

Yes. Frappe Insights can be self-hosted on your own server or infrastructure.

What is Frappe Insights an alternative to?

Frappe Insights is an open-source alternative to Tableau, ThoughtSpot, Sigma and Power BI. Other open-source alternatives to Tableau include Superset, Metabase and Lightdash.

Is Frappe Insights actively maintained?

Yes. The most recent commit to Frappe Insights was on 1 October 2026, and the latest release is v3.14.2, published on 29 September 2026. The project has 1k stars on GitHub.

Frappe Insights: open-source alternative to Tableau

About Frappe Insights

Frappe Insights is an open-source business intelligence tool that aims to make data analysis and reporting accessible to both technical and non-technical users. It grew out of the experience of working with Frappe Framework applications, where building structured data was easy but extracting reports usually required SQL knowledge.

You can connect multiple sources, including databases, files and spreadsheets, and use a step-by-step query builder to select tables, add joins, apply filters and calculations without writing SQL. Results can be visualized with various charts, with the tool suggesting a fitting chart, and dashboards are assembled by drag and drop with dashboard filters. Supported databases include MySQL, PostgreSQL, DuckDB and BigQuery. A SQL editor is also available.

Insights is built on the Frappe Framework, Frappe UI with Vue, and the Ibis library for composing SQL with dataframe APIs. It is written in Python, licensed under AGPL-3.0, and can be self-hosted, with a live demo and documentation. It suits ERPNext and Frappe users as well as teams wanting a lightweight BI tool.

Key features

Query builder that needs no SQL
Connections to multiple data sources
Chart suggestions and visualizations
Drag-and-drop dashboards with filters
MySQL, PostgreSQL, DuckDB, and BigQuery support
SQL editor for advanced users

Good fit for

→Building reports on top of ERPNext data
→Creating dashboards without writing SQL
→Combining data from several databases

Built with: Python; MySQL; Vue
Tags: business-intelligence; dashboards; data-visualization; frappe; duckdb; query-builder; python; analytics; self-hosted

Frappe Insights: questions and answers

What is Frappe Insights used for?: Frappe Insights is an open-source business intelligence tool with a no-SQL query builder, charts, dashboards and support for MySQL, PostgreSQL, DuckDB and BigQuery. It is a good fit for building reports on top of ERPNext data, creating dashboards without writing SQL and combining data from several databases.
Is Frappe Insights open source?: Yes. Frappe Insights is open source under the AGPL-3.0 licence. Its source code is on GitHub at frappe/insights and is written mainly in Python.
Is Frappe Insights free?: Yes. Frappe Insights is open source, so the software itself is free to use.
Can I self-host Frappe Insights?: Yes. Frappe Insights can be self-hosted on your own server or infrastructure.
What is Frappe Insights an alternative to?: Frappe Insights is an open-source alternative to Tableau, ThoughtSpot, Sigma and Power BI. Other open-source alternatives to Tableau include Superset, Metabase and Lightdash.
Is Frappe Insights actively maintained?: Yes. The most recent commit to Frappe Insights was on 1 October 2026, and the latest release is v3.14.2, published on 29 September 2026. The project has 1k stars on GitHub.