All your Stripe data, in your own databasequeryable, for free.
OpenSigma is an open-source alternative to Stripe Sigma and Stripe Data Pipeline. It mirrors your Stripe account into Cloudflare D1 over webhooks — so you can join, rank, and chart your billing data without paying Stripe a second time for what you already gave them.
SELECT
p.name AS product,
SUM(ili.amount) / 100.0 AS revenue_usd,
COUNT(DISTINCT i.customer) AS paying_customers
FROM invoice_line_items ili
JOIN invoices i ON i.id = ili.invoice
JOIN prices pr ON pr.id = ili.price
JOIN products p ON p.id = pr.product
WHERE i.status = 'paid'
AND i.created > strftime('%s', '2026-01-01')
GROUP BY p.id
ORDER BY revenue_usd DESC
LIMIT 10;Stripe Sigma, on your own infrastructure.
Stripe Sigma is the dashboard SQL editor you pay extra for. Stripe Data Pipeline is the pipe that drips your data into Snowflake or BigQuery — and only after you've already paid for the warehouse.
OpenSigma does the same job differently: a Cloudflare Worker subscribes to your Stripe webhooks, upserts every event into D1, and backloads history on a cron. The result is a normal SQLite database — one you query with any client, join with your own app data, and ship dashboards on top of.
Built and maintained by XY Space as an open-source project. The code lives on GitHub, free for anyone to self-host — or we can run it for you.
Six things you'd otherwise pay Stripe — or a warehouse — for.
Your Stripe data, in your database
Every billing-core object — charges, invoices, subscriptions, payouts, disputes — lands as a queryable SQLite row in your Cloudflare D1. You own the data, not Stripe.
Fresh in seconds
Webhook-driven updates keep rows in sync the moment events fire. Out-of-order deliveries are handled with a per-row guard, so the database never goes backward.
27 mirrored tables
Customers, products, prices, subscriptions, invoices, charges, payment intents, refunds, disputes, payouts, checkout sessions, and more — each one ported from Stripe's open-source sync-engine to SQLite.
Join with your own app data
It's just SQLite. Rank your top products by revenue, segment customers by plan, or wire Stripe history into your existing dashboards — no extra ETL, no warehouse contract.
Natural-language queries
Ships with a skill that reads the schema, writes the SQL, runs it, and renders the result. Ask in plain English, bring any LLM — Claude, GPT, Gemini, or a local model.
No vendor lock-in
MIT-licensed, runs on your Cloudflare account, uses a read-only Stripe restricted key. A compromised Worker can read your data — but can't move money, refund anyone, or mutate your account.
Zero dollars. For most accounts. All in.
Cloudflare's free tier covers Workers, D1, and Queues for the vast majority of Stripe accounts. At 100,000 charges per month, OpenSigma still runs at $0 — while Sigma would charge you ~CA$2,700/mo and Data Pipeline would charge you ~CA$2,300 plus warehouse fees.
Stripe Sigma
~CA$21/mo for 250 charges, climbing to CA$621+/mo at 25k charges. Dashboard-only — your data stays on Stripe's servers.
Stripe Data Pipeline
~CA$69/mo to CA$759+/mo — plus whatever you already pay Snowflake, Redshift, BigQuery, or Databricks to receive it.
OpenSigma
$0 for most accounts. Cloudflare's free tier covers Workers, D1, and Queues. The data lives in your account, MIT-licensed end to end.
Runs entirely on Cloudflare.
Webhooks keep rows fresh in real time. A cron-driven Queue backfills historical data and retries anything webhooks missed. D1 is the only datastore — query it from any Worker, any framework, any host.
You're comfortable with a terminal.
Clone the repo, mint a read-only Stripe restricted key, run the migrations, and point a webhook at your Worker. The README walks through it end to end.
Open the repoYou'd rather it just be running.
We can set up OpenSigma on your Cloudflare account, wire it to your Stripe webhooks, backload your history, and hand back a database your finance team can actually query.
Start a conversationBook a discovery call.Leave with a scoped XY Space AI deployment.
Two weeks of discovery. One scoped XY Space AI wrapper. Your people still decide. Everything you build stays yours.