Frappe Insights
What Frappe Insights gives you
Multi-source data
Query your ERPNext database, other MariaDB/Postgres sources and uploaded files side by side.
Visual query builder
Filter, join and summarise data with clicks — SQL available when analysts want it.
Every chart that matters
Bar, line, funnel, pivot and number cards with formatting that keeps dashboards readable.
Dashboards for teams
Compose charts into dashboards, share by role and keep one version of the truth.
Fresh by schedule
Queries refresh on schedule so Monday dashboards never show last month’s numbers.
Explainable results
Drill from any chart back to the query and rows behind it — no black-box KPIs.
Also included
How Frappe Insights works in practice
Connect the ERP database once, and the sales head can answer her own question — revenue by territory, this quarter, only distributors — by clicking a query together in minutes. The result becomes a chart, the chart joins the management dashboard, and the query refreshes on schedule. The alternative most companies live with is a weekly export-to-Excel ritual that is always one edit away from a wrong decision.
BI that lives beside your ERP
Because it speaks the same stack as ERPNext and Frappe Framework, deployment is one bench command, not a BI project. Explore the Frappe ecosystem, our implementation service, or the official Frappe Insights site.
Frequently asked questions
Do users need SQL?
No — the visual builder covers most questions; SQL mode exists for analysts who want full control.
Can it read ERPNext data live?
Yes, it queries the same database, so dashboards reflect transactions as they happen.
Is it really free?
Open source with no per-viewer charges — significant savings against per-seat BI licences.