shaperVisualize and share your data. All in SQL. Powered by DuckDB.

shaper

Shaper is an open-source, SQL-driven dashboard platform powered by DuckDB that enables anyone to visualize and share data without leaving SQL. Built with Go and designed for self-hosting, it combines simplicity with powerful analytics capabilities through an intuitive SQL-first interface.

Key Features

• SQL-First Visualization: Build dashboards entirely through SQL queries using special casting operators for chart types and axes
• DuckDB Powered: Leverage DuckDB's performance for querying across multiple data sources with a unified SQL interface
• Multi-Format Export: Generate PDF, PNG, CSV, and Excel reports with automated scheduling and alerts
• White-Label Embedding: Embed dashboards in applications via JS and React SDKs with row-level security through JWT tokens
• Git-Based Workflow: Version control your dashboards and queries natively within the platform
• Self-Hosted: Complete control with open-source deployment and optional managed hosting available

Use Cases

• Business Analytics: Create real-time dashboards and reports for monitoring key business metrics
• Data Exploration: Query and visualize complex datasets quickly using familiar SQL syntax
• Embedded Analytics: Integrate branded analytics directly into SaaS applications and customer portals
• Automated Reporting: Schedule and distribute reports automatically to stakeholders
• Data Sharing: Create shareable, password-protected links for collaborative data analysis

Who Is It For

Shaper is ideal for data engineers, analytics professionals, and product teams who want to build sophisticated dashboards and embedded analytics without mastering frontend frameworks. It's perfect for organizations seeking open-source alternatives to commercial BI tools while maintaining full control over their infrastructure and data.