Shaper

Shaper lets users create analytics dashboards by writing plain SQL, using DuckDB as the execution engine. The platform supports dynamic charts, filters, annotations, and conditional sections, and can query across external sources such as Postgres, S3, and Google Sheets via DuckDB extensions. Dashboards can be embedded directly into applications with JavaScript or React SDKs, and access can be restricted with per‑user JWT tokens.

The tool is open source (MPL‑2.0), self‑hostable, and runs from a single Docker container, making it suitable for teams that want to keep data and infrastructure under their control. It includes features for automated reporting—PDF, PNG, CSV, and Excel exports, scheduled alerts, and password‑protected shareable links—along with row‑level security and white‑label styling.

Shaper also provides a Git‑based workflow for versioning dashboards, and it can serve as a minimal data platform that stores data in DuckDB, runs scheduled SQL tasks, and offers an HTTP API for real‑time ingestion. It targets developers and analysts familiar with SQL who need a lightweight, embeddable dashboard solution without a separate analytics stack.