Stripe Wrapper

Stripe is the financial infrastructure platform used by millions of companies to handle payments, subscriptions, invoicing, and more. It processes over $1.9 trillion in payments annually and powers everything from simple checkouts to complex multi-party revenue models.

The Stripe Wrapper maps Stripe's API endpoints directly to Postgres foreign tables, so you can query live billing data with SQL and join it against your own application data. Supports both read and write operations across customers, subscriptions, invoices, and more, and works with Supabase Vault for secure API key management.

Preparation

Before you get started, make sure the wrappers extension is installed on your database:

and then create the foreign data wrapper:

Secure your credentials (optional)

By default, Postgres stores FDW credentials inide pg_catalog.pg_foreign_server in plain text. Anyone with access to this table will be able to view these credentials. Wrappers is designed to work with Vault, which provides an additional level of security for storing credentials. We recommend using Vault to store your credentials.

Connecting to Stripe

We need to provide Postgres with the credentials to connect to Stripe, and any additional options. We can do this using the create server command:

With Vault:

Without Vault:

Resources

• Supabase docs: Connecting to Stripe
• Enable in Supabase dashboard
• supabase/wrappers on GitHub
• Stripe product page
• Official supabase/wrappers documentation