OpenSource-Hub
S

Shaper

SHA-256
1.1k stars·Developer Tools·SHA-256 checksum verified

Open-source SQL-driven data dashboards powered by DuckDB. Write SQL to build analytics, embed dashboards, and automate reports.

Smart Download

Download Download Version

v0.19.1 · 123.8 MB

Write SQL to generate dashboards instantly. Open-source, DuckDB-powered, one-command Docker setup.

Core Features

  • SQL-first: create charts with SQL labels (bar, stacked, line, etc.)
  • Powered by DuckDB for fast local querying without heavy ETL
  • White-labeling, JWT row-level security, iframe-free embedding via JS/React SDKs
  • Automated PDF/PNG/CSV/Excel reports with scheduling
  • Git-based workflow, version control, self-hosted or managed private cloud

What It Can't Do

  • First-time users need to learn SQL label syntax (::LABEL, ::BARCHART_STACKED, etc.). Docker run does not persist data by default; use volume mounts in production. Shaper relies on DuckDB, which may not handle extremely large datasets efficiently; consider external databases or partitioning for big data.

Use Cases

  • Quickly build internal business metrics dashboards
  • Embed analytics into customer apps with granular data permissions
  • Automate daily/weekly data reports and email distribution

Shaper is an open-source, self-hosted analytics platform that turns SQL queries into interactive dashboards. It leverages DuckDB for fast local querying and supports multiple data sources. You can create visualizations like bar charts, line charts, and tables simply by writing SQL with special labels. Features include white-labeling, row-level security via JWT, embedding without iframes (JS/React SDKs), and automated PDF/PNG/CSV/Excel report generation. The Git-based workflow enables version control and collaboration. For regulated industries, managed private cloud hosting with compliance support is available. Shaper is designed for teams that want a lightweight, SQL-first alternative to heavy BI tools.

Tags

data-dashboardsqlduckdbanalyticsopen-source

Getting Started

1

Download installer

Click the button above to download the installer for your system

2

Install the software

Double-click the downloaded installer and follow the prompts

3

1. Ensure Docker is installed (or manually set up DuckDB + Node environment)

4

2. Run: docker run --rm -it -p5454:5454 taleshape/shaper

5

3. Open http://localhost:5454/new and start writing SQL to create dashboards

Install Guide
  1. 1. Ensure Docker is installed (or manually set up DuckDB + Node environment)
  2. 2. Run: docker run --rm -it -p5454:5454 taleshape/shaper
  3. 3. Open http://localhost:5454/new and start writing SQL to create dashboards
File Integrity

SHA-256 checksum verified

Checksum extracted from GitHub official Release page

SHA256 Checksum

5d56c262507e985f4bcc86797db98018f8917c6cb8556585fa915e192b2b7d48

This checksum is extracted from the GitHub Release page. Verify file integrity after download.

All SHA-256 checksums on this platform are extracted from the project's official GitHub Release page, without any modification. You can independently verify them on the GitHub Releases page.

Open Source Transparency

View GitHub Source
Environment Guide

Uninstall Info

Stop the Shaper Docker container (docker stop <container-id>), remove the image (docker rmi taleshape/shaper). For manual installation, delete the project directory and database files.

No Extra Dependencies

Ready to use after download. No additional runtime required.

Project Info
LicenseMPL-2.0
Last Updated2026-06-27 10:15:24
GitHub RepositoryOfficial Website

Having issues? Check the FAQ below

3 FAQs

Similar Projects