// the find
frappe/insights
Open Source Business Intelligence Tool
This is a business intelligence app built on the Frappe framework, so it installs into a bench site or a Docker stack and inherits Frappe's users, roles and permissions. It covers SQL-free query building, automatic chart suggestions and drag-and-drop dashboards over MySQL, PostgreSQL, DuckDB and BigQuery. It suits teams already running ERPNext or another Frappe app who want reporting next to their data without adding Metabase or Superset to the stack.
Ibis is the stated SQL layer, so the query model is written once against a dataframe API instead of per-dialect string building across four engines. The nightly compatibility matrix installs each Frappe branch and runs the tests on the Python and Node versions that branch supports, which catches breakage against new Frappe releases before users do. The docs/adr folder records individual design decisions as titled records, such as type-independent chart config and charts rendering through frappe-ui, which makes the codebase easier to enter. Suggesting a chart type from the shape of the result is a sensible default for the non-technical users the README describes.
Setup is heavy: it needs a full bench or Docker stack, and local development adds a separate yarn dev server and hosts-file edits, so trying it on a single CSV takes real time before the first chart. The production guide tells you to enable server scripts site-wide with one command and gives no reason or tradeoff. Server scripts execute code, so that choice deserves a sentence of justification, not just a step. The install instructions run bench get-app without naming a branch, while the compatibility table pairs three branches with different Frappe and Python versions, so someone on an older Frappe can easily pick the wrong one. The README lists four supported databases and says more are planned, yet the frontend tree has connect dialogs for ClickHouse and MariaDB, so either the docs are stale or those integrations are unfinished, and a reader cannot tell which.