frappe/insights

Health v2 · maintenance only

Adoption not part of the score

1009 stars · 498 forks observed · 2026-09-03

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Frappe Insights is a 100% open-source business intelligence (BI) tool for data analysis and reporting, built on the Frappe Framework. It lets technical and non-technical users connect multiple data sources, build queries visually without SQL, and create charts and dashboards.

Use cases

• build dashboards from my erpnext data without writing sql
• visualize mysql and postgresql data with charts
• connect spreadsheets and databases into one analytics tool
• create reports for non-technical team members
• self-host an open source alternative to tableau or metabase
• run ad-hoc data analysis with a visual query builder
• combine data from multiple sources for business reporting

When to choose

• you use Frappe/ERPNext and want integrated reporting
• you need a self-hosted, open-source BI tool with no license costs
• non-technical users must build queries and dashboards without SQL
• you need to combine multiple databases, files, and spreadsheets in one place

When to avoid

• you need enterprise BI features like row-level security at scale or embedded analytics SDKs
• you require databases beyond MySQL, PostgreSQL, DuckDB, or BigQuery
• you need a lightweight charting library rather than a full BI application
• you are not running or willing to host a Frappe-based web application

Facets

application · maturity active

data-visualization analytics search-engine charts gui analytics data-visualization data-science self-hosted erp self-hosted python cloud business-intelligence bi-tool query-builder dashboards sql-editor duckdb echarts frappe-framework erpnext no-sql-required reporting web-server docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="frappe/insights")