# shzlw/poli

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.

Repository: https://github.com/shzlw/poli
Canonical: https://ross.abutalabs.com/products/poli
Homepage: https://shzlw.github.io/poli
Language: Java
License: MIT
License Family: permissive
Topics: business-intelligence, sql, dashboard, data-visualization, sql-editor, jdbc, bigdata, reporting, spring-boot, reactjs
Last push: 2023-01-06T21:00:47+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 2836, "days_push": 1335, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1973, forks 335 (observed 2026-08-28T04:06:01.057357+00:00)

## What it is
Poli is a self-hosted business intelligence server for writing SQL queries and building interactive dashboards and reports. It connects to any JDBC-compatible database and provides a SQL editor, drag-and-drop chart building, and user access management.

## Use cases
- build sql dashboards for business reporting
- self-hosted bi tool alternative to tableau
- run adhoc sql queries with charts
- create canned reports from database snapshots
- share sql reports with role-based access control
- connect to postgres mysql oracle via jdbc for analytics

## When to choose
- you prefer writing raw SQL over generated queries or ETL
- you want a lightweight single-JAR self-hosted BI server
- you need to connect to many different JDBC databases
- you want interactive dashboards with dynamic SQL filters

## When to avoid
- you need drag-and-drop analytics for non-technical users who won't write SQL
- you require active development and recent updates (last release early 2023)
- you need advanced BI features like semantic layers or embedded analytics at scale

## Facets
- artifact type: application
- maturity: maintenance
- function: data-visualization, search-engine, auth, internationalization
- domain: data-visualization, analytics, databases, self-hosted, big-data
- platform: self-hosted, jvm, cross-platform
- tags: business-intelligence, sql-editor, dashboarding, reporting, jdbc, spring-boot, reactjs, adhoc-analysis, docker, web-server

## Member repositories
- shzlw/poli (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:01.057357+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:05:00.069247+00:00, confidence not recorded.
  - readme: https://github.com/shzlw/poli (fetched 2026-08-28T04:06:01.057357+00:00, sha 0046fd7bc74d)
  - homepage: https://shzlw.github.io/poli (fetched 2026-08-29T10:44:14.907308+00:00, sha 6ab734d9a0e8)
- Data as of 2026-08-30T08:39:29.467469+00:00.