Welcome to Shaper

Open Source, SQL-driven Data Dashboards powered by DuckDB.

Visualize data, build interactive dashboards, pdf reports and data exports simply by writing SQL.

SELECT 'Sessions per Week'::LABEL;
SELECT
  date_trunc('week', created_at)::XAXIS,
  category::CATEGORY,
  count()::BARCHART_STACKED,
FROM dataset
GROUP BY ALL ORDER BY ALL;

Get dynamic dashboards you can embed directly into your application, for example:

Jump right to the Getting Started Guide

See Managed Hosting and Support Plans

Features

Dynamic Dashboards

• Dynamic data filters
• Generate chart annotations from your data
• Conditionally show sections

The Full Power of DuckDB

• Query across data sources
• Pre-compute state as temporary tables
• Use any DuckDB extension

Embedded Analytics

• Embed dashboards into your application without iframe.
• JS and React SDKs.
• Generate per-user JWT tokens to restrict access.

Give users access to their data

• Define custom CSV and Excel downloads.
• Generate PDFs
• Share any dashboard as password-protected link.

BI as Code

• Version Control Dashboards with Git
• Use your AI Agent of choice to create dashboards

No lock-in

Shaper is open source and free to use.

Own your Data

Runs in your infrastructure.

Simple Operations

Run a single Docker container.

More than a dashboard builder

Start data projects with a single tool. Bring in additional tools as needed.

Shaper allows you to keep simple things simple and plays well with other tools once your needs grow more complex.

Remote Data

• Query your existing data right where it is.
• Postgres, S3, Google Sheets. There is a DuckDB extension for it.

Data Transform

• Automate loading and transforming data with scheduled tasks defined in plain SQL.
• Move the SQL to DBT or SQLMesh as your data pipelines get more complex.

Data Storage

• Store data directly in DuckDB.
• Build up a dedicated data warehouse or lake as your business grows.

Ingest API

• HTTP API to ingest data in real-time.
• Shaper infers the data schema for you.