Repolode
Submit
taleshape-com

taleshape-com/shaper

Open-source, self-hosted dashboards, reports and embedded analytics built by writing SQL on top of DuckDB.

Open-source alternative to:TableauLooker

View on GitHubWebsite
Stars
1,272
Forks
52
Open issues
27
Last commit
18 hours ago

What is it?

Shaper lets you build data dashboards by writing SQL queries, with chart types and labels set through SQL type annotations such as XAXIS, CATEGORY and BARCHART_STACKED. Dashboards are defined as SQL files and can be managed through a Git-based workflow. It can query across multiple data sources.

Beyond internal dashboards, Shaper covers customer-facing analytics: white-labeling, row-level security via JWT tokens, and embedding into apps through JavaScript and React SDKs without an iframe. It also generates reports as PDF, PNG, CSV and Excel, with scheduled alerts and password-protected share links.

It can be run quickly with Docker on port 5454. The project is licensed under MPL-2.0, and the maintainers also offer managed hosting for teams that do not want to operate it themselves.

Key features

  • 01Build dashboards and charts by writing SQL queries
  • 02Git-based workflow for managing dashboards
  • 03Query across multiple data sources
  • 04Row-level security via JWT tokens
  • 05Embed analytics via JavaScript and React SDKs without iframes
  • 06Export reports as PDF, PNG, CSV and Excel with scheduled alerts

Use cases

  • Building internal KPI dashboards directly from SQL
  • Sharing customer-facing analytics embedded in a SaaS product
  • Generating scheduled PDF or Excel reports from a data warehouse

Quick start

  1. 1

    Run Shaper with Docker

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

    Open the new dashboard page in your browser

Things to know

  • Managed hosting and expert support are paid options from the vendor, while self-hosting leaves security, compliance and maintenance to you.
  • Production deployment requires following the separate deployment and hardening guide.

In collections

Databases & SQL toolsData science courses & tools

Topics

#duckdb#sql#dashboards#data-visualization#analytics#embedded-analytics#reporting#data

FAQ

What is shaper?
Open-source, self-hosted dashboards, reports and embedded analytics built by writing SQL on top of DuckDB. Shaper lets you build data dashboards by writing SQL queries, with chart types and labels set through SQL type annotations such as XAXIS, CATEGORY and BARCHART_STACKED. Dashboards are defined as SQL files and can be managed through a Git-based workflow. It can query across multiple data sources.
Is shaper free to use? What license does it have?
shaper is open source under the MPL-2.0 license. Check the license terms before using it in commercial products.
Is shaper still maintained?
Actively maintained. The last commit to shaper was on Nov 6, 2026.
What can I use shaper for?
Building internal KPI dashboards directly from SQL Sharing customer-facing analytics embedded in a SaaS product Generating scheduled PDF or Excel reports from a data warehouse
How do I install shaper?
Run Shaper with Docker: docker run --rm -it -p5454:5454 taleshape/shaper Open the new dashboard page in your browser
Where can I get shaper?
The source code and installation instructions are on GitHub: https://github.com/taleshape-com/shaper

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects