---
title: "Sync real-time Stripe data to Supabase with Stripe Data Pipeline"
description: "Stripe’s Data Pipeline now adds Postgres as a destination, enabling developers to sync Stripe data directly into their Supabase project without maintaining webhooks or working around API rate limits. Setup occurs entirely in the Stripe Dashboard: under Reporting, Data management, users select Data Pipeline, choose Postgres and Supabase, and authorize the connection. Stripe backfills historical records and continuously syncs charges, refunds, disputes, customers, subscriptions, and invoices into a dedicated stripe_sdp schema in the user’s Postgres database. A dedicated stripe_sdp role with scoped permissions, JWT direct connections using short-lived tokens, and enforced SSL ensure the database password is never exposed to Stripe. Developers can then query the synced tables with standard SQL, join them with application data, and implement features like MRR calculations, churn analysis, or subscription-based feature gating without extra API calls."
---

# Sync real-time Stripe data to Supabase with Stripe Data Pipeline

[Supabase](https://yomu.fyi/company/supabase) · gregor\_vand, saba\_pochkhua, staaldraad · Oct 15, 2026

**Type:** Announcement

## Summary

Stripe’s Data Pipeline now adds Postgres as a destination, enabling developers to sync Stripe data directly into their Supabase project without maintaining webhooks or working around API rate limits. Setup occurs entirely in the Stripe Dashboard: under Reporting, Data management, users select Data Pipeline, choose Postgres and Supabase, and authorize the connection. Stripe backfills historical records and continuously syncs charges, refunds, disputes, customers, subscriptions, and invoices into a dedicated stripe\_sdp schema in the user’s Postgres database. A dedicated stripe\_sdp role with scoped permissions, JWT direct connections using short-lived tokens, and enforced SSL ensure the database password is never exposed to Stripe. Developers can then query the synced tables with standard SQL, join them with application data, and implement features like MRR calculations, churn analysis, or subscription-based feature gating without extra API calls.

## Context

Many Supabase-based businesses use Stripe for payments, but revenue data previously required API calls or complex webhook handlers to sync into Postgres. Stripe Data Pipeline already solved this for warehouse destinations like Snowflake and BigQuery, but Postgres was not supported. The latest evolution adds Postgres as a destination, with Supabase as one of the first providers. This allows developers to bypass webhook maintenance and API rate limits.

## Approach / What changed

Users initiate setup from the Stripe Dashboard under Reporting > Data management > Data Pipeline, selecting Postgres and Supabase as the destination. After signing in to Supabase and selecting a project, Stripe backfills historical data and maintains continuous sync. Security is ensured by creating a dedicated stripe\_sdp role with scoped permissions, enabling JWT direct connections with short-lived tokens, and enforcing SSL. No database password is shared.

## Takeaways

- Stripe Data Pipeline eliminates the need to maintain custom webhook handlers or worry about API rate limits.
- Synced data appears as tables in a stripe\_sdp schema, including charges, customers, subscriptions, and invoices, queryable with standard SQL.
- The connection uses OAuth-based short-lived JWT credentials and a dedicated database role, so Stripe never receives the user’s database password.

## FAQ

### How does Stripe Data Pipeline ensure secure access to my Supabase database?

It uses OAuth to obtain a one-time authorization, creates a dedicated stripe\_sdp role with permissions limited to the stripe schema, enables JWT direct connections with short-lived tokens, and enforces SSL. Stripe never receives the database password.

### What Stripe data is synced and what does the schema look like?

Stripe syncs charges, refunds, disputes, customers, subscriptions, invoices, and more. They land as tables in a schema prefixed with stripe\_sdp in your database. You can query them with standard SQL.

### Can I query Stripe data alongside my application's existing tables?

Yes, because the data is in the same Postgres database. You can perform joins, for example matching Stripe customers to user rows, or check subscription status for feature gating without extra API calls.

**Tags:** [Data Pipelines](https://yomu.fyi/topic/data-pipelines), [Postgres](https://yomu.fyi/topic/postgres), [Real-time](https://yomu.fyi/topic/real-time), [Stripe](https://yomu.fyi/topic/stripe), [Supabase](https://yomu.fyi/topic/supabase)

- Source: [Supabase](https://supabase.com/blog/stripe-data-pipeline-now-syncs-real-time-data-to-supabase)
- Source URL: https://supabase.com/blog/stripe-data-pipeline-now-syncs-real-time-data-to-supabase
- Ingested by Yomu: 2026-10-15T18:00:18.132Z

[Read original post](https://supabase.com/blog/stripe-data-pipeline-now-syncs-real-time-data-to-supabase)