frappe/insights

What is it?

Key features

• 01Connects to databases, files and spreadsheets in one place.
• 02No-code query builder with table selection, joins, filters and calculations.
• 03Suggests a suitable chart type for each query result.
• 04Drag-and-drop dashboards with shared filters across charts.
• 05Supports MySQL, PostgreSQL, DuckDB and BigQuery.

Use cases

• Letting non-technical staff build reports on data stored in an ERPNext or Frappe app.
• Combining exports from spreadsheets with database tables for ad hoc analysis.
• Building shared business dashboards with filters that cover multiple charts.

Quick start

1. 1

   Download the docker-compose file

   wget -O docker-compose.yml https://raw.githubusercontent.com/frappe/insights/develop/docker/docker-compose.yml
2. 2

   Start the containers in the background

   docker compose up -d
3. 3

   Open http://insights.localhost:8000/insights and log in as Administrator with password admin

Things to know

• !Licensed under AGPL-3.0, a copyleft license that requires sharing modified source code when offered over a network.
• !Supports only MySQL, PostgreSQL, DuckDB and BigQuery as data sources for now.
• !The quick Docker setup requires Docker and docker compose installed on your machine.

Topics

FAQ

What is insights?

Open-source business intelligence tool from Frappe for building queries, charts and dashboards without writing SQL. Frappe Insights is a business intelligence tool aimed at both technical and non-technical users who need to analyse data and produce reports. It connects to multiple data sources, including databases, files and spreadsheets, so that data from different places can be combined in one workspace.

Is insights free to use? What license does it have?

insights is open source under the AGPL-3.0 license. Check the license terms before using it in commercial products.

Is insights still maintained?

Actively maintained. The last commit to insights was on Oct 20, 2026.

What can I use insights for?

Letting non-technical staff build reports on data stored in an ERPNext or Frappe app. Combining exports from spreadsheets with database tables for ad hoc analysis. Building shared business dashboards with filters that cover multiple charts.

How do I install insights?

Download the docker-compose file: wget -O docker-compose.yml https://raw.githubusercontent.com/frappe/insights/develop/docker/docker-compose.yml Start the containers in the background: docker compose up -d Open http://insights.localhost:8000/insights and log in as Administrator with password admin

Where can I get insights?

The source code and installation instructions are on GitHub: https://github.com/frappe/insights