Skip to content
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
config Add export dialog Oct 5, 2019
db Dev Aug 13, 2019
docs Add export dialog Oct 5, 2019
export-server Add export dialog Oct 5, 2019
src Add export dialog Oct 5, 2019
third-party-license Add endpint to export report to PDF Sep 22, 2019
upgrade Dev Aug 13, 2019
web-app Add export dialog Oct 5, 2019
.gitattributes Init Dec 10, 2018
.gitignore Dev: ignore generated files May 15, 2019
Dockerfile Bump version to 0.10.1 Aug 15, 2019
LICENSE Create LICENSE Apr 10, 2019 Bump version to 0.10.1 Aug 15, 2019
build.bat Dev Jan 7, 2019 Dev Apr 14, 2019 Add build release script Jul 29, 2019
pom.xml Add endpint to export report to PDF Sep 22, 2019
start.bat Bump version to 0.10.1 Aug 15, 2019 Bump version to 0.10.1 Aug 15, 2019


Version license: MIT Download Docker Pulls Build Status codecov

Poli is an easy-to-use SQL reporting application built for SQL lovers!

Why Poli

⚡️ Self-hosted & easy setup

Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes.

💪 Connect to any database supporting JDBC drivers

PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it.

💡 SQL editor & schema viewer

No ETLs, no generated SQL, polish your own SQL query to transform data.

🔥 Rich and flexible styling

Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way.

📑 Interactive Adhoc report

Utilize the power of dynamic SQL with query variables to connect Filters and Charts.

⌛️ Canned report

Capture the snapshot of historical data. Free up space in your own database.

🎅 User management

Three system level role configurations + Group based report access control.

🌎 Internationalization

Custom the language pack and translations just for your audience.

💰 MIT license

Open and free for all usages.

💎 Is that all?

Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

What's New (latest)

poli v0.8.0


Slicer & Charts

poli v0.5.0

Move & Resize

poli component reposition

Color palette switch & export CSV

poli v0.6.0

Quick Installation


java -jar poli-0.10.1.jar


docker run -d -p 6688:6688 --name poli zhonglu/poli:0.10.1

Check installation guide for more details.


Download the latest version of Poli via the github release page.


Poli's documentation and other information can be found at here.


MIT License

Copyright (c) 2019 Zhonglu Wang

You can’t perform that action at this time.