Free and Open Source Data Analytics Tool for your Frappe Apps
Alternatives To Insights
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Directus21,7905017 hours ago55September 22, 2022226otherTypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Vue Apexcharts1,202
3 months ago2November 25, 2021175mitVue
📊 Vue.js component for ApexCharts
Vue Data Board1,166
a year ago15Vue
A Data Analysis Board in Vue.
3 months ago3mitVue
🎲 数据大屏可视化编辑器
Carbon Charts735674 days ago390June 30, 2022177apache-2.0TypeScript
:bar_chart: :chart_with_upwards_trend:⠀Robust dataviz framework implemented using D3 & typescript
Datav Vue508
4 months ago9mitVue
A Powerful Data Visualization Tool. Uses TypeScript And Vue3. Scenario-specific templates. User-friendly interfaces. 一款数据可视化应用搭建工具
4 days ago4apache-2.0Vue
No-code in the front, Python in the back. An open-source framework for creating data apps.
Flowy Vue36015 months ago12July 08, 202037mitVue
Vue Flowy makes creating flowchart or hierarchy chart functionality an easy task. Build automation software, mind mapping tools, organisation charts, or simple programming platforms in minutes by implementing the library into your project.
Python Articles287
4 years ago
Monthly Series - Top 10 Python Articles
3 years ago88mitJavaScript
Tracking the growth of COVID-19 Cases worldwide
Alternatives To Insights
Select To Compare

Alternative Project Comparisons
Frappe Insights logo

Simple. Crafted. Powerful. Data Analysis.

GitHub issues GitHub license GitHub release (latest by date) codecov unittests

Hero Image


Frappe Insights is an open-source project designed to simplify data analysis and reporting from databases. Built upon the Frappe Framework, Frappe Insights aims to provide an intuitive interface that enables users to effortlessly generate complex reports and gain valuable insights from their data.


The inspiration behind Frappe Insights was the need to simplify data analysis for the apps built upon Frappe Framework. While the framework provides robust tools for managing structured data using DocTypes, analyzing and visualizing that data often requires developer expertise. Frappe Insights aims to bridge this gap by offering a user-friendly solution that empowers non-technical users to perform data analysis tasks without relying on developers.

Key Features

Query Builder: Frappe Insights offers a user-friendly query builder interface that allows users to create database queries without the need for extensive SQL knowledge. The interface provides a step-by-step approach for building queries, empowering users to easily select tables, apply filters, perform calculations, and more.

Visualizations and Dashboards: Once a query is created, Frappe Insights enables users to visualize the results using a variety of charts and graphs. Users can easily create custom dashboards by combining multiple visualizations to gain a comprehensive view of their data.

Connectivity: Frappe Insights currently supports integration with MySQL databases, allowing users to connect to their existing databases and work directly with their data. More database integrations are planned for the future.

Under the Hood

Frappe Framework: Frappe Insights is built upon the Frappe Framework, a full-stack web application framework written in Python and Javascript. The framework provides a robust foundation for building web applications, including a database abstraction layer, user authentication, and a REST API.

Frappe UI: Frappe Insights uses the Frappe UI, a Vue-based UI library, to provide a modern and responsive user interface. The Frappe UI library provides a variety of components that can be used to build single-page applications on top of the Frappe Framework.

SQLAlchemy: Frappe Insights uses SQLAlchemy, a Python SQL toolkit and Object Relational Mapper, to interact with the database. SQLAlchemy provides a powerful and flexible interface for working with databases, allowing Frappe Insights to support multiple database integrations.

eCharts: Frappe Insights uses eCharts, a powerful open-source charting and visualization library, to render charts and graphs. eCharts provides a variety of chart types and customization options, allowing Frappe Insights to provide a rich and interactive data visualization experience.

Pandas: Frappe Insights uses Pandas, a Python data analysis library, to perform data analysis tasks. Pandas provides a variety of data structures and functions for working with structured data, allowing Frappe Insights to provide powerful data analysis capabilities.



You need Docker, docker-compose and git setup on your machine. Refer Docker documentation. After that, run the following commands:

git clone
cd insights/docker
docker-compose up

Wait for sometime until the setup script creates a site. After that you can Open the URL http://insights.test:8000/insights in your browser, you should see the app running should show up.


To setup the repository locally follow the steps mentioned below:

  1. Install bench and setup a frappe-bench directory by following the Installation Steps
  2. Start the server by running bench start
  3. In a separate terminal window, create a new site by running bench new-site insights.test
  4. Map your site to localhost with the command bench --site insights.test add-to-hosts
  5. Get the Insights app. Run bench get-app
  6. Run bench --site insights.test install-app insights.
  7. Now open the URL http://insights.test:8000/insights in your browser, you should see the app running

Contributions and Community

There are many ways you can contribute even if you don't code:

  1. You can start by giving a star to this repository!
  2. If you find any issues, even if it is a typo, you can raise an issue to inform us.
  3. You can join our telegram group and share your thoughts.


GNU Affero General Public License v3.0

Popular Data Visualization Projects
Popular Vue Projects
Popular User Interface Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Data Visualization
Data Analytics
Business Intelligence