Shaper

Create interactive analytics dashboards with SQL and embed them in your product while keeping full control of your data. Shaper is an open-source platform for customer-facing analytics, built around SQL so data teams can use skills they already have.

• SQL-driven development: Build dashboards entirely in SQL without learning a new framework
• Full data control: Keep your data in your own infrastructure and avoid vendor lock-in
• DuckDB engine: Query across data sources with embedded DuckDB
• Embedding without iframes: Use the JavaScript and React SDKs, with row-level security through JWT tokens
• Multiple output formats: Generate PDF, PNG, CSV, and Excel exports, plus scheduled alerts and reports

Shaper fits embedded analytics projects where you show data directly inside your application. Teams quoted on its site say they can quickly visualize and share data with customers while keeping ownership of their data pipeline.

Common uses include internal research tools, customer-facing dashboards, and automated reporting systems.