Poli
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
Install / Use
/learn @shzlw/PoliREADME
Poli（魄力）
Poli is an easy-to-use SQL reporting application built for SQL lovers!
Why Poli
:zap: Self-hosted & easy setup
Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes.
:muscle: Connect to any database supporting JDBC drivers
PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it.
:bulb: SQL editor & schema viewer
No ETLs, no generated SQL, polish your own SQL query to transform data.
:fire: Rich and flexible styling
Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way.
:bookmark_tabs: Interactive Adhoc report
Utilize the power of dynamic SQL with query variables to connect Filters and Charts.
:hourglass: Canned report
Capture the snapshot of historical data. Free up space in your own database.
:santa: User management
Three system level role configurations + Group based report access control.
:earth_americas: Internationalization
Custom the language pack and translations just for your audience.
:moneybag: MIT license
Open and free for all usages.
:gem: Is that all?
Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.
What's New (latest)
Gallery
Slicer & Charts
Move & Resize
Color palette switch & export CSV
Quick Installation
Windows/Linux
java -jar poli-0.12.2.jar
Docker
docker run -d -p 6688:6688 --name poli zhonglu/poli:0.12.2
Check installation guide for more details.
Download
Download the latest version of Poli via the github release page.
Documentation
Poli's documentation and other information can be found at here.
Run on GCP
License
MIT License
Copyright (c) Zhonglu Wang
Related Skills
oracle
338.7kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
338.7kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
83.6kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
83.6kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
