# Supabase Stripe Wrapper

> PostgreSQL foreign data wrapper to query and write Stripe data via SQL

The Stripe Wrapper is a Postgres foreign data wrapper built into Supabase Wrappers that maps Stripe API endpoints directly to foreign tables in your database. It lets you query transactions, invoices, and checkout sessions with standard SQL, and directly insert, update, or delete records like customers, products, and subscriptions without custom ETL pipelines. Credentials can be managed securely through Supabase Vault.

Website: https://fdw.dev/catalog/stripe

## What it is for

- Query Stripe charges, balances, and invoices directly alongside application tables in Postgres
- Sync customer and subscription status changes via SQL commands without dedicated webhook syncing scripts
- Join Stripe payment data with internal user analytics inside database queries or reporting tools

## Features

- Maps Stripe API entities into standard Postgres foreign tables using SQL schemas
- Read-only support for charges, balance transactions, events, invoices, payment intents, and disputes
- Read and write support (INSERT, UPDATE, DELETE) for customers, products, and subscriptions
- Direct integration with Supabase Vault for encrypted API key management
- Pushdown filtering support to optimize API queries based on WHERE clauses like ID or email
- JSONB attributes column for inspecting raw Stripe API response properties

## Pricing

Open source. Free and open source (Apache-2.0)

## Details

- Type: Web app
- Category: [Development](https://xiry.app/topics/development.md)
- Open source: yes
- Platforms: Self-hosted, Web
- For: Postgres and Supabase developers who want to access Stripe data without ETL pipelines
- Alternative to: Stripe Sync Engine, Airbyte Stripe Connector, Fivetran Stripe Connector
- Tags: supabase, postgres, stripe, fdw, sql, database

## Why it was saved

- [@supabase, 14 January 2026](https://x.com/supabase/status/2011476096844243034): Shows the whole setup flow: install from the Integrations catalog, paste a Stripe secret key, create a foreign schema, and get foreign tables (charges, customers, events, invoices, payment\_intents, etc.) in the Table Editor — Stripe data queryable in Postgres in under a minute.
- [@supabase, 14 January 2026](https://x.com/supabase/status/2011476096844243034): The link http://fdw.dev/catalog/stripe points to the Stripe wrapper's entry; the catalog indexes the many wrappers visible in the video (Airtable, Auth0, BigQuery, ClickHouse, Cloudflare D1…).

## Related

- [AnotherWrapper](https://xiry.app/resources/anotherwrapper): Next.js AI boilerplate with pre-built apps, auth, and payments. (Web app, Paid)
- [hn-search](https://xiry.app/resources/hn-search): Full-text search over 49M Hacker News items using Neon Postgres BM25 (GitHub repo, Open source)
- [Safe Manual SQL Updates Using Transactions](https://xiry.app/resources/safe-manual-sql-updates-using-transactions): A workflow to safely update or delete database records using transactions. (Tip, Free)
- [Zero](https://xiry.app/resources/zero): General-purpose sync engine bringing local-first performance to Postgres web apps (Web app, Open source)
- [Stripe Bill for LLM Tokens](https://xiry.app/resources/stripe-bill-for-llm-tokens): Usage-based billing infrastructure for charging end users and reselling LLM tokens. (Web app, Paid)
- [Zero to Paid SaaS in 10 Min (Free Template)](https://xiry.app/resources/zero-to-paid-saas-in-10-min-free-template): Tutorial and starter template for shipping a paid SaaS application quickly (Article or course, Free)

Updated 10 October 2026. Page: https://xiry.app/resources/supabase-stripe-wrapper

Make your own library: Xiry takes your saved reels, tweets, Reddit bookmarks and Watch Later videos, makes them searchable and pulls the useful stuff out, like this library. It's invite-only for now; join the waitlist at https://xiry.app/#waitlist.