# Shaper

Shaper is an open source, SQL-first data platform for building self-hosted analytics dashboards, embedded customer-facing analytics, and automated reports by writing SQL on top of DuckDB.

Canonical page: https://ourlocalhost.com/app/8750/shaper

## Description

Shaper is an open source, SQL-first data platform for building self-hosted analytics dashboards, embedded customer-facing analytics, and automated reports by writing SQL on top of DuckDB.

## Platform availability

Available on 1 of 10 platforms: Any server.

## Health score

77/100 (Good), based on 4 of 5 factors.
- Maintained: 100 (last commit 2 days ago)
- Popular: 62 (1,281 GitHub stars)
- Easy to install: 25 (1 install platform, install notes)
- Security check: 100 (no serious findings, CI, tests)

## Links

- Official website: https://taleshape.com/shaper/docs
- GitHub: https://github.com/taleshape-com/shaper
- Documentation: https://taleshape.com/shaper/docs/

## Common questions

### What port and page should I use for a minimal Shaper trial in Docker?

The quickstart maps the Shaper container to port 5454 and tells you to open the /new page after running it. Use the command shown in the README as the base setup.

### Can Shaper query data stored outside of its own database?

Yes, it queries existing Postgres, S3, and Google Sheets data from where it is using DuckDB extensions.

### How can I give end users access to embedded dashboards?

Shaper supports embedding through JS and React SDKs without an iframe. You can generate per-user JWT tokens to restrict access to that user's data.

### How are dashboards handled as code?

Shaper uses a Git-based workflow, allowing dashboards to be version controlled in a Git repository.

### Which export formats can Shaper generate for reports?

It can generate PDF, PNG, CSV, and Excel files. It also supports scheduled alerts and reports.

### How can a dashboard be shared with limited access?

You can share any dashboard using a password-protected link.

## Alternatives

- Looker Studio: Data visualization and business intelligence (BI) platform for aggregating, sharing, collaborating, and pulling insights from raw databases…
- Metabase: Metabase is a simple and powerful analytics tool which lets anyone learn and make decisions from their company’s data.
- Microsoft Power BI: Enhance your decision-making by transforming diverse data sources into engaging, interactive visual insights with tools like Power BI Deskt…
- Tableau: Tableau helps the world’s largest organizations unleash the power of their most valuable assets: their data and their people.
- apache-superset: Apache Superset is a modern data exploration and visualization platform.

---
Source: Our Local Host (https://ourlocalhost.com/app/8750/shaper), the self-hosted and open-source app directory.
