An easy-to-use, self-hosted SQL reporting application for creating interactive business intelligence dashboards.
Poli is an open-source business intelligence server built for SQL enthusiasts. It allows users to create interactive reports and dashboards by writing SQL queries directly against their databases, eliminating the need for complex ETL processes. The tool focuses on simplicity, flexibility, and self-hosting, enabling faster data analysis and business insights.
Data analysts, BI developers, and SQL-savvy professionals who need a lightweight, customizable reporting tool they can deploy and control internally.
Developers choose Poli for its SQL-first approach, ease of self-hosting, and flexibility in styling and database connectivity, offering a free, open-source alternative to commercial BI platforms.
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
With a single JAR file and embedded SQLite database, Poli deploys in minutes on any platform with Java, avoiding complex infrastructure setup.
It allows direct SQL query writing and refinement without generated SQL or ETLs, giving analysts full control over data transformation.
Supports any JDBC-driven database like PostgreSQL, Oracle, and MySQL, enabling connectivity to diverse data sources out of the box.
Features pixel-perfect positioning and drag-and-drop for charts and filters, allowing highly tailored interactive reports.
As version 0.12.2 indicates, Poli is still in active development, which may lead to breaking changes or missing features compared to mature BI tools.
While customizable, it lacks the extensive pre-built chart types and components found in commercial alternatives like Power BI or Tableau.
Requires a Java environment for deployment, which can be a barrier for teams not using Java-based infrastructure or preferring container-native solutions.
Poli is an open-source alternative to the following products:
Tableau is a business intelligence and data visualization software that helps people see and understand their data through interactive dashboards, reports, and charts.
Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Looker is a business intelligence and data analytics platform that enables organizations to explore, analyze, and share real-time business insights through a web-based interface.