Skip to content
Back to search

insights

Open Source Business Intelligence Tool

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today

Check it deeper on your machine

It has changed since its scan on 11 Nov 2026.

As a Claude Code plugin, install it and then ask Claude Code:

/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/frappe/insights with scanskillsafety

Or from a terminal, clone it and run it:

git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/frappe/insights'

It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.

Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/frappe--insights/badge.svg)](/listings/frappe--insights)

HTML

<a href="/listings/frappe--insights"><img src="/api/listings/frappe--insights/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

Managed Hosting

You can try [Frappe Cloud](https://frappecloud.com), a simple, user-friendly and sophisticated [open-source](https://github.com/frappe/press) platform to host Frappe applications with peace of mind.

It takes care of installation, setup, upgrades, monitoring, maintenance and support of your Frappe deployments. It is a fully featured developer platform with an ability to manage and control multiple Frappe deployments.

<div> <a href="https://frappecloud.com/insights/signup" target="_blank"> <picture> <source media="(prefers-color-scheme: dark)" srcset="https://frappe.io/files/try-on-fc-white.png"> </picture> </a> </div>

Self Hosting

Follow these steps to set up Frappe Insights in production:

**Step 1**: Download the easy install script

wget https://frappe.io/easy-install.py

**Step 2**: Run the deployment command

python3 ./easy-install.py deploy \
    --project=insights_prod_setup \
    --email=your_email.example.com \
    --image=ghcr.io/frappe/insights \
    --version=stable \
    --app=insights \
    --sitename subdomain.domain.tld

Replace the following parameters with your values: - `your_email.example.com`: Your email address - `subdomain.domain.tld`: Your domain name where Insights will be hosted

**Step 3**: Enable Server Scripts

docker compose -p insights_prod_setup exec backend bench set-config -g server_script_enabled 1

**Step 4**: Access the site

Open the site in your browser at `https://subdomain.domain.tld/` and login with the administrator credentials. You will find the admin password logged in the console after the deployment command is finished. Or you can find it in the `insights_prod_setup-passwords.txt` file created after the deployment.

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 203 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

  1. <div align="center" markdown="1">
  2. <img src=".github/new-logo.svg" alt="Frappe Insights logo" height="80"/>
  3. <h1>Frappe Insights</h1>
  4. **Open Source Business Intelligence Tool**
  5. ![GitHub release (latest by date)](https://img.shields.io/github/v/release/frappe/insights)
  6. [![codecov](https://codecov.io/github/frappe/insights/branch/develop/graph/badge.svg?token=8ZXHCY4G9U)](https://codecov.io/github/frappe/insights)
  7. </div>
  8. <div align="center">
  9. <img src=".github/hero-image.png?v=6" alt="Hero Image" width="1402" />
  10. </div>
  11. <br />
  12. <div align="center">
  13. <a href="https://insightsdemo.frappe.cloud">Live Demo</a>
  14. -
  15. <a href="https://frappe.io/insights">Website</a>
  16. -
  17. <a href="https://docs.frappe.io/insights">Documentation</a>
  18. </div>
  19. ## Frappe Insights
  20. Insights is a 100% open-source BI tool designed to make data analysis and reporting more accessible to technical as well as non-technical users.
  21. <details>
  22. <summary>Screenshots</summary>
  23. ![Query Builder](.github/query-builder.png)
  24. ![Query Builder](.github/join-editor.png)
  25. ![Chart Builder](.github/chart-builder.png)
  26. </details>
  27. ### Motivation
  28. Building custom apps or creating structured data has been very easy with Frappe Framework. However, extracting information from these apps was not a very good experience. Users needed to know how to write SQL queries to create reports to gain valuable information from the data. So I wanted to improve the experience of building these reports and dashboards for everyone in our team.
  29. ### Key Features
  30. - **Connect Multiple Sources**: You can integrate data from multiple databases, files and spreadsheets. Getting all your data into one place helps you analyse interconnected data.
  31. - **Query Builder**: You can use the query builder to create queries without any SQL knowledge. The interface provides a step-by-step approach for building queries, allowing users to easily select tables, add joins, apply filters, perform calculations, and more.
  32. - **Visualizations and Dashboards**: You can visualize the query results using a variety of charts and graphs. Frappe Insights also suggests the best chart for a given result set. You can create dashboards using a drag-and-drop interface and add filters on the dashboard to apply to the charts.
  33. - **Database Support**: Frappe Insights currently supports MySQL, PostgreSQL, DuckDB, and BigQuery databases. More database integrations are planned for the future.
  34. ### Under the Hood
  35. - [**Frappe Framework**](https://github.com/frappe/frappe): A full-stack web application framework.
  36. - [**Frappe UI**](https://github.com/frappe/frappe-ui): A Vue-based UI library, to provide a modern user interface.
  37. - [**Ibis**](https://github.com/ibis-project/ibis): A powerful library to compose SQL queries with dataframe APIs.
  38. - [**eCharts**](https://github.com/apache/echarts): An interactive charting and data visualization library.
  39. ## Production Setup
  40. ### Managed Hosting
  41. You can try [Frappe Cloud](https://frappecloud.com), a simple, user-friendly and sophisticated [open-source](https://github.com/frappe/press) platform to host Frappe applications with peace of mind.
  42. It takes care of installation, setup, upgrades, monitoring, maintenance and support of your Frappe deployments. It is a fully featured developer platform with an ability to manage and control multiple Frappe deployments.
  43. <div>
  44. <a href="https://frappecloud.com/insights/signup" target="_blank">
  45. <picture>
  46. <source media="(prefers-color-scheme: dark)" srcset="https://frappe.io/files/try-on-fc-white.png">
  47. <img src="https://frappe.io/files/try-on-fc-black.png" alt="Try on Frappe Cloud" height="28" />
  48. </picture>
  49. </a>
  50. </div>
  51. ### Self Hosting
  52. Follow these steps to set up Frappe Insights in production:
  53. **Step 1**: Download the easy install script
  54. ```bash
  55. wget https://frappe.io/easy-install.py
  56. ```
  57. **Step 2**: Run the deployment command
  58. ```bash
  59. python3 ./easy-install.py deploy \
  60. --project=insights_prod_setup \
  61. --email=your_email.example.com \
  62. --image=ghcr.io/frappe/insights \
  63. --version=stable \
  64. --app=insights \
  65. --sitename subdomain.domain.tld
  66. ```
  67. Replace the following parameters with your values:
  68. - `your_email.example.com`: Your email address
  69. - `subdomain.domain.tld`: Your domain name where Insights will be hosted
  70. **Step 3**: Enable Server Scripts
  71. ```bash
  72. docker compose -p insights_prod_setup exec backend bench set-config -g server_script_enabled 1
  73. ```
  74. **Step 4**: Access the site
  75. Open the site in your browser at `https://subdomain.domain.tld/` and login with the administrator credentials. You will find the admin password logged in the console after the deployment command is finished. Or you can find it in the `insights_prod_setup-passwords.txt` file created after the deployment.
  76. ## Development Setup
  77. ### Docker
  78. You need Docker, docker-compose and git setup on your machine. Refer [Docker documentation](https://docs.docker.com/). After that, follow below steps:
  79. 1. Setup folder and download the required files
  80. ````
  81. mkdir frappe-insights
  82. cd frappe-insights
  83. # Download the docker-compose file
  84. wget -O docker-compose.yml https://raw.githubusercontent.com/frappe/insights/develop/docker/docker-compose.yml
  85. # Download the setup script
  86. wget -O init.sh https://raw.githubusercontent.com/frappe/insights/develop/docker/init.sh
  87. ````
  88. 2. Run the container and daemonize it
  89. ````
  90. docker compose up -d
  91. ````
  92. 3. The site [http://insights.localhost:8000/insights](http://insights.localhost:8000/insights) should now be available. The default credentials are:
  93. - Username: Administrator
  94. - Password: admin
  95. 4. If you need to stop the containers after use and persist the data
  96. ````
  97. docker compose stop
  98. ````
  99. 5. If you need to stop the containers cleanup entire setup after trying it out
  100. ````
  101. docker compose down
  102. ````
  103. ### Local
  104. To setup the repository locally follow the steps mentioned below:
  105. 1. Setup bench by following the [Installation Steps](https://frappeframework.com/docs/user/en/installation) and start the server
  106. ```
  107. bench start
  108. ```
  109. 2. In a separate terminal window, cd into `frappe-bench` directory and run the following commands:
  110. ```sh
  111. bench get-app insights
  112. bench new-site insights.test --install-app insights
  113. bench --site insights.test add-to-hosts
  114. bench --site insights.test browse --user Administrator
  115. ```
  116. 3. Now, open a new terminal session and cd into `frappe-bench/apps/insights`, and run the following commands:
  117. ```
  118. yarn
  119. yarn dev
  120. ```
  121. 4. Now, you can access the site on vite dev server at `http://insights.test:8080`
  122. ## Compatibility Matrix
  123. A [nightly workflow](.github/workflows/compat-matrix.yml) installs each branch and runs the test suite, on the Node and Python each Frappe branch supports. Pull requests into version-3 run it too. It verifies these combinations:
  124. | Insights Branch | Frappe Framework | Node | Python |
  125. |-----------------|------------------------|--------|------------|
  126. | main | version-15 | 18 | 3.10 |
  127. | version-3 | version-15, version-16 | 18, 24 | 3.10, 3.14 |
  128. | develop | develop | 24 | 3.14 |
  129. ## Learn and connect
  130. - [Telegram Public Group](https://t.me/frappeinsights)
  131. - [Discuss Forum](https://discuss.frappe.io/c/insights/74)
  132. - [Documentation](https://docs.frappe.io/insights)
  133. - [YouTube](https://www.youtube.com/@frappetech)
  134. <br>
  135. <br>
  136. <div align="center" style="padding-top: 0.75rem;">
  137. <a href="https://frappe.io" target="_blank">
  138. <picture>
  139. <source media="(prefers-color-scheme: dark)" srcset="https://frappe.io/files/Frappe-white.png">
  140. <img src="https://frappe.io/files/Frappe-black.png" alt="Frappe Technologies" height="28"/>
  141. </picture>
  142. </a>
  143. </div>

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.