helicalinsight/helicalinsight

What it solves

Helical Insight is an open-source Business Intelligence (BI) and reporting platform designed to provide enterprise-grade analytics and reporting without the cost of proprietary software. It solves the need for a unified system that can handle interactive dashboards, professional paginated reports, and AI-driven data exploration within a single embeddable package.

How it works

The platform operates as a full-stack application consisting of a Java-based backend (Spring, Hibernate) and a React frontend. It connects to a vast array of data sources via JDBC, REST APIs, and native connectors. A specialized Python-based component called "Instant BI" leverages LangChain and LangGraph to provide AI capabilities, allowing users to interact with their data using natural language.

Who it’s for

It is built for organizations and developers who need to embed analytics into their own SaaS platforms, customer portals, or enterprise applications, as well as those requiring professional-grade financial or regulatory reporting (pixel-perfect reports).

Highlights

• AI-Powered Analytics: Natural language querying, automatic SQL generation, and report summarization with agentic capabilities and "bring your own LLM" options.
• Embedded BI: Full support for white-labeling and seamless embedding of chatbots and dashboards into external web applications.
• Pixel-Perfect Reporting: Ability to create professional, printer-friendly paginated reports for invoices and financial statements.
• Enterprise Security: Robust data isolation with row-wise, column-wise, and table-wise security, supporting SSO via JWT, Okta, and Keycloak.
• Broad Connectivity: Native support for a wide range of databases including Snowflake, BigQuery, PostgreSQL, MongoDB, and various cloud storage options.