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:

LIVE_DEMO

Jump right to the Getting Started Guide

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 of dashboards
• 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.

Data Storage

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

Ingest API

• Ingest data in real-time via HTTP or NATS.
• Let Shaper infer the data schema for you.

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 same SQL to DBT or SQLMesh as your data pipelines get more complex.