Google Looker
Modern BI platform for governed data modeling and dashboards
Open-Source Projects
Discover top open-source software, updated regularly with real-world adoption signals.
Discover top open-source software, updated regularly with real-world adoption signals.
Self-hosted SQL reporting platform with drag-and-drop visualizations
Poli lets SQL enthusiasts create interactive reports and dashboards quickly. Connect to any JDBC database, edit queries, design pixel-perfect charts, and manage users—all from a single JAR.
Poli is a lightweight web‑based reporting server aimed at developers and analysts who are comfortable writing SQL. By connecting to any JDBC‑compatible database, users can craft ad‑hoc queries, apply variables for dynamic filtering, and instantly visualize results in charts or tables. The built‑in editor shows schema details, so no separate ETL step is required.
The application runs from a single JAR file backed by an embedded SQLite database, or via the official Docker image, allowing a full setup in minutes on Windows, Linux, or cloud platforms such as GCP. Role‑based access control and group permissions let administrators restrict report visibility, while language packs provide internationalization. Drag‑and‑drop layout tools give pixel‑perfect positioning, and features like auto‑refresh, drill‑through, and CSV export are available out of the box. Because Poli is released under the MIT license, it can be freely modified or embedded into internal portals.
When teams consider Poli, these hosted platforms usually appear on the same shortlist.
Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.
Ad‑hoc sales analysis
Business analysts write custom SQL to slice sales data, apply filters, and export CSV instantly.
Scheduled financial snapshot
Canned reports generate nightly PDFs of key financial metrics, freeing database space.
Embedded dashboard in internal portal
Developers embed Poli charts via iframe, providing real‑time KPI visualizations to employees.
Multi‑regional reporting
International teams switch language packs and color themes, delivering localized dashboards.
Poli runs on Java 11 or newer; the JAR includes all necessary dependencies.
Yes, an official Docker image is provided and can be started with a single `docker run` command.
Poli offers three system‑level roles and group‑based permissions to restrict report visibility per user or group.
Charts can be exported to CSV, and reports can be downloaded as PDF or image files.
Documentation is available on the project website and GitHub repository; issues can be opened on GitHub for assistance.
Project at a glance
DormantLast synced 4 days ago
