Customers, subscriptions, invoices, charges, refunds, payouts and fees — copied into SQL Server, Azure SQL, PostgreSQL, MySQL or Oracle and kept up to date within seconds. Query it with SQL, join it with your data, build reports in Power BI.
Install from Stripe PricingInstall from the Stripe App Marketplace, paste a connection string, press Save. Tables are created for you.
Webhooks apply every change within seconds. A reconcile loop re-checks recent events, so nothing gets lost.
Typed columns for the fields you report on, plus the full JSON of every object. Deletions are kept as soft deletes.
Data goes straight into your server. We store only an encrypted connection string, sync status and your plan — never your Stripe data.
13 tables: stripe_customers, stripe_products, stripe_prices, stripe_subscriptions, stripe_subscription_items, stripe_invoices, stripe_invoice_line_items, stripe_payment_intents, stripe_charges, stripe_refunds, stripe_balance_transactions, stripe_payouts, stripe_disputes.
-- Monthly revenue by product, straight from your database SELECT p.name, FORMAT(i.paid_at, 'yyyy-MM') AS month, SUM(l.amount) / 100.0 AS revenue FROM stripe_invoice_line_items l JOIN stripe_invoices i ON i.id = l.invoice AND i.status = 'paid' JOIN stripe_products p ON p.id = l.product GROUP BY p.name, FORMAT(i.paid_at, 'yyyy-MM');
or $470.40/year
or $1,430.40/year
or $2,870.40/year
One Stripe account per subscription. 3-day free trial, no card needed. Save 20% with yearly billing. Cancel any time. Prices exclude VAT.
Questions? support@mirrorbooksql.com