· Open Source· GitHub

opensigma

Mirror your Stripe account into a Cloudflare D1 database. Query your own data, build dashboards, run analytics — no extra Stripe fees, no warehouse contract.

opensigma is a free, MIT-licensed replacement for Stripe Sigma and Stripe Data Pipeline. It mirrors every billing-core object from your Stripe account into a Cloudflare D1 database, so you can query, join, and dashboard your data without paying Stripe a second time for numbers you already gave them.

It replicates the core behaviour of stripe/sync-engine, but runs entirely on Cloudflare Workers + D1 + Queues instead of Postgres and a long-lived server. For most accounts, Cloudflare's free tier covers it end-to-end at $0/month.

Why it exists

If you want to JOIN invoices against your own customer table, rank top products by revenue, or ship an internal dashboard, you shouldn't need a Stripe Sigma subscription or a Snowflake contract. opensigma gives you the raw data as plain SQLite rows you own, queryable from any Worker or any SQLite client.

Architecture

A single Cloudflare Worker handles both real-time and historical sync:

  • Webhooks keep rows fresh within seconds. Out-of-order deliveries are dropped via a per-row last_event_at guard.
  • Cron + Queue backfills historical data and retries anything webhooks missed, paging the Stripe REST API with a read-only restricted key.
  • D1 is the only datastore — 27 tables covering charges, invoices, customers, payouts, disputes, checkout sessions, payment methods, Radar, and more.
Stripe webhooks and an hourly cron feed a Cloudflare Worker, which upserts every billing object into a D1 database
Sync architecture — webhooks and cron feed a Worker that upserts into D1
A plain-English question turned into SQL against the synced Stripe tables, with ranked results
stripe-schema-query — plain English in, SQL and ranked results out

Cost comparison

At 100k charges/month, Stripe Sigma runs roughly CA$2,700+/mo and Data Pipeline sits around CA$2,300+/mo plus your warehouse bill. opensigma stays at $0 for the same volume on Cloudflare's free tier.

Natural-language queries, any LLM

A bundled stripe-schema-query skill lets Claude, GPT, Gemini, or a local model answer questions against your D1 database in plain English — no vendor-managed AI required.

Source, setup guide, and the full 27-table schema live on GitHub → choyiny/opensigma.