Frappe Insights

Open Source Business Intelligence Tool

!GitHub release (latest by date)

Frappe Insights

Motivation

Key Features

• 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.

• 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.

• 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.

• Database Support: Frappe Insights currently supports MySQL, PostgreSQL, DuckDB, and BigQuery databases. More database integrations are planned for the future.

Under the Hood

• Frappe Framework: A full-stack web application framework.

• Frappe UI: A Vue-based UI library, to provide a modern user interface.

• Ibis: A powerful library to compose SQL queries with dataframe APIs.

• eCharts: An interactive charting and data visualization library.

Production Setup

Managed Hosting

You can try Frappe Cloud, a simple, user-friendly and sophisticated open-source 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.

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

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.

Development Setup

Docker

You need Docker, docker-compose and git setup on your machine. Refer Docker documentation. After that, follow below steps:

1. Setup folder and download the required files

mkdir frappe-insights
    cd frappe-insights
# Download the docker-compose file
    wget -O docker-compose.yml https://raw.githubusercontent.com/frappe/insights/develop/docker/docker-compose.yml
# Download the setup script
    wget -O init.sh https://raw.githubusercontent.com/frappe/insights/develop/docker/init.sh

1. Run the container and daemonize it

docker compose up -d

1. The site http://insights.localhost:8000/insights should now be available. The default credentials are:

1. If you need to stop the containers after use and persist the data

docker compose stop

1. If you need to stop the containers cleanup entire setup after trying it out

docker compose down

Local

To setup the repository locally follow the steps mentioned below:

1. Setup bench by following the Installation Steps and start the server

bench start

1. In a separate terminal window, cd into frappe-bench directory and run the following commands:

bench get-app insights
    bench new-site insights.test --install-app insights
    bench --site insights.test add-to-hosts
    bench --site insights.test browse --user Administrator

1. Now, open a new terminal session and cd into frappe-bench/apps/insights, and run the following commands:

yarn
    yarn dev

1. Now, you can access the site on vite dev server at http://insights.test:8080

Compatibility Matrix

A nightly workflow installs each branch and runs the test suite. It verifies these combinations:

| Insights Branch | Frappe Framework | Node | Python | |-----------------|------------------------|--------|------------| | main | version-15 | 20 | 3.10 | | version-3 | version-15, version-16 | 20, 24 | 3.10, 3.14 | | develop | version-15, version-16 | 20, 24 | 3.10, 3.14 |

Note: the Node column lists the versions CI runs, not the minimum. Each branch declares its own minimum in frontend/package.json: >=16.0.0 on main, >=18 on version-3, >=20.19.0 on develop.

Learn and connect

• Telegram Public Group
• Discuss Forum
• Documentation
• YouTube