Open-source, self-hosted dashboards, reports and embedded analytics built by writing SQL on top of DuckDB.
helicalinsight/helicalinsight
Self-hosted, open source embedded BI platform with AI chat analytics, paginated reports, interactive dashboards, SSO and multi-tenancy.
Open-source alternative to:Tableau
Power BI
Crystal Reports
- Stars
- 1,112
- Forks
- 785
- Open issues
- 57
- Last commit
- 10 days ago
What is it?
Helical Insight is an open source business intelligence platform aimed at organizations that need reporting, dashboards and embedded analytics in one product. Users can ask questions in natural language, have SQL generated automatically, and use an AI assistant that can bring their own LLM.
The platform covers paginated, print-ready reports for invoices, financial statements and regulatory filings, along with interactive dashboards that support drill-down, drill-through, filters and KPI widgets. Reports and dashboards can be exported to PDF, Excel, CSV, Word, HTML, JSON and XML, and scheduled for email delivery or bursting to recipients.
For security and deployment, it offers row-, column- and table-level access control based on the logged-in user, SSO via JWT, Okta, Keycloak and OAuth, and multi-tenancy with data isolation. It connects to a wide range of databases and file sources through native connectors and JDBC, and runs on Docker, Kubernetes or on-premises servers with a Docker Compose quick start.
Key features
- 01Natural-language analytics with automatic SQL generation and optional bring-your-own LLM
- 02Paginated pixel-perfect reports for print and export
- 03Interactive dashboards with drill-down, drill-through and filters
- 04Row, column and table-level security with SSO via JWT, Okta, Keycloak and OAuth
- 05Multi-tenancy with data isolation in a single deployment
- 06Scheduled report delivery by email and REST APIs for automation
Use cases
- Building reporting and dashboards inside a SaaS product for customers
- Replacing legacy reporting tools with a self-hosted, print-ready report designer
- Giving business users a chat interface to query company data
- Distributing scheduled, personalized reports to departments or clients
Quick start
- 1
Install Docker and Docker Compose
- 2
Download the latest Docker package (ZIP) and unzip it
- 3
Copy the example settings file
cp .env.example .env - 4
Start the services, then open https://localhost/hi-ee (login hiadmin / hiadmin)
docker compose up -d
Things to know
- First startup is slow, taking several minutes, because it builds and downloads images.
- Default logins are hiadmin/hiadmin and must be changed outside local or demo use.
- Advanced features like AI analytics may need an LLM you provide.
In collections
Topics
FAQ
- What is helicalinsight?
- Self-hosted, open source embedded BI platform with AI chat analytics, paginated reports, interactive dashboards, SSO and multi-tenancy. Helical Insight is an open source business intelligence platform aimed at organizations that need reporting, dashboards and embedded analytics in one product. Users can ask questions in natural language, have SQL generated automatically, and use an AI assistant that can bring their own LLM.
- Is helicalinsight free to use? What license does it have?
- helicalinsight is open source under the AGPL-3.0 license. Check the license terms before using it in commercial products.
- Is helicalinsight still maintained?
- Actively maintained. The last commit to helicalinsight was on Oct 28, 2026.
- What can I use helicalinsight for?
- Building reporting and dashboards inside a SaaS product for customers Replacing legacy reporting tools with a self-hosted, print-ready report designer Giving business users a chat interface to query company data Distributing scheduled, personalized reports to departments or clients
- How do I install helicalinsight?
- Install Docker and Docker Compose Download the latest Docker package (ZIP) and unzip it Copy the example settings file: cp .env.example .env Start the services, then open https://localhost/hi-ee (login hiadmin / hiadmin): docker compose up -d
- Where can I get helicalinsight?
- The source code and installation instructions are on GitHub: https://github.com/helicalinsight/helicalinsight
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Open-source business intelligence tool that lets anyone in a company ask questions of their data without writing SQL, with dashboards and embedded analytics.
Self-hosted .NET reporting and BI tool that turns SQL and NoSQL sources into reports, pivot tables, charts and scheduled outputs, with ETL tasks.
Free, open-source Java report and BI tool for designing reports, print forms, data-entry forms, big-screen dashboards and AI-generated charts online.
Open-source browser-based BI tool for querying, visualizing, and sharing data from many SQL and NoSQL data sources.
Open-source, code-based BI tool that builds interactive data reports and dashboards from SQL and markdown.