Frappe Insights

Frappe Framework made building custom apps easy and getting information back out of them hard, and Insights was written to close that gap. It is a fully open source business intelligence tool aimed at making analysis and reporting reachable for people who do not write SQL, not only for the ones who do.

Queries are built step by step through an interface that lets you select tables, add joins, apply filters and perform calculations. Underneath, Ibis composes the SQL through a dataframe API, Frappe UI supplies the Vue-based interface, eCharts draws the results, and the Frappe Framework carries the full stack.

The tool comes down to a handful of pieces.

• Multiple sources: data from several databases, files and spreadsheets lands in one place so interconnected data can be analyzed together.
• Query builder: a step-by-step interface builds queries without any SQL knowledge.
• Visualizations: results render as charts, with the best chart for a given result set suggested automatically.
• Dashboards: a drag-and-drop layout, with filters that apply across every chart on it.
• Database support: MySQL, PostgreSQL, DuckDB and BigQuery today, with more integrations planned.

Production setup runs an easy install script that deploys a Docker stack for a given site name and domain, after which server scripts are enabled with one bench command and the admin password is written to a local file. Development uses Docker Compose with an init script. Frappe Cloud offers managed hosting for teams who would rather not operate it, and a live demo is available before committing to either path.