Welcome to Shaper

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

Build analytics dashboards 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:

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.

No lock-in

Shaper is open source and free to use.

Own your Data

Runs in your infrastructure.

Familiar

If you know SQL, you know how to use Shaper.

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.