# taleshape-com/shaper

Visualize and share your data. All in SQL. Powered by DuckDB.

Repository: https://github.com/taleshape-com/shaper
Canonical: https://ross.abutalabs.com/products/shaper
Homepage: https://taleshape.com
Language: Go
License: MPL-2.0
License Family: copyleft
Topics: analytics, dashboards, data, duckdb
Last push: 2026-08-26T09:26:05+00:00

## Health v2 (maintenance only)
Score: 82/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 86, longevity 35
- inputs: {"age_days": 496, "days_push": 7, "days_rel": 12, "gap_med": 1, "n_releases_24m": 122}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1239, forks 49 (observed 2026-08-28T04:04:06.051309+00:00)

## What it is
Shaper is an open-source, SQL-first data visualization application powered by DuckDB that lets users build dashboards, reports, and data exports by writing SQL queries. It supports embedded analytics via JS/React SDKs, JWT-based row-level security, scheduled PDF/PNG/CSV/Excel reports, and a Git-based workflow where dashboards are defined as code.

## Use cases
- build analytics dashboards by writing SQL queries
- embed customer-facing analytics into my product without iframes
- generate scheduled PDF and Excel reports from data
- query data across Postgres, S3, and Google Sheets with DuckDB
- self-host a lightweight BI tool in a single Docker container
- version-control dashboards as SQL code in Git
- share password-protected dashboard links with customers
- restrict dashboard data per user with row-level security

## When to choose
- you want SQL-first dashboards without a heavy traditional BI tool
- you need embedded, white-labeled analytics in your own product
- you want dashboards as auditable code in Git with no vendor lock-in
- you prefer self-hosting and keeping data in your own infrastructure
- you need automated report generation and scheduled alerts

## When to avoid
- you need drag-and-drop visual dashboard building without writing SQL
- you require a full enterprise BI suite with extensive governance features out of the box
- your team has no SQL skills at all
- you need a fully managed SaaS with no self-hosting involvement

## Facets
- artifact type: application
- maturity: active
- function: data-visualization, analytics, charts, pdf, self-hosted, http-server
- domain: analytics, data-visualization, self-hosted, web-development
- platform: self-hosted, windows
- tags: duckdb, sql-first, bi-as-code, embedded-analytics, dashboards, git-based, white-labeling, row-level-security, automated-reports, business-intelligence, docker, web-server, linux, macos

## Member repositories
- taleshape-com/shaper (main) score 82

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:06.051309+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:09:59.770513+00:00, confidence not recorded.
  - readme: https://github.com/taleshape-com/shaper (fetched 2026-08-28T04:04:06.051309+00:00, sha 7b5ea5e83601)
  - homepage: https://taleshape.com (fetched 2026-08-29T12:20:42.958843+00:00, sha 19e546577fbf)
  - site_page: https://taleshape.com/shaper/docs (fetched 2026-08-29T12:20:42.966698+00:00, sha 3309d853be6d)
  - site_page: https://taleshape.com/plans-and-pricing (fetched 2026-08-29T12:20:42.964232+00:00, sha f01594546176)
- Data as of 2026-08-30T08:39:29.467469+00:00.