Get Started

SQL Insights Stripe App

Use SQL to query your Stripe data in a PostgreSQL database.

Empower your teams to answer questions about your business in real time using standard SQL. Render automatically syncs your Stripe data to a secure, encrypted PostgreSQL database, so Finance, Product Management, and Business Operations teams can get instant insights.

You can sync your Stripe data to a new or existing PostgreSQL database. Stripe data will be continuously synced as Stripe objects are changed, added, or deleted.

How to connect Stripe to your Render account

  1. Go to “SQL Insights” in the Stripe App Marketplace.

  2. Click the “Install app” button.

  3. Open the “SQL Insights” app in your Stripe dashboard.

  4. Click the “Sign in to Render” button.
    If you don’t have a Render account, you can create one by clicking the “Sign up” link. stripe 1

  5. Follow the prompts to connect your Stripe account to your Render account.

How to pick a database

  1. Pick a PostgreSQL database to copy your Stripe data into and click Continue. stripe 2

  2. Follow the prompts to finish connecting your database. The sync process should start automatically.

  3. Wait for the sync process to complete.
    Depending on how much data you have, this might take a while. stripe 3 stripe 4

  4. Once the sync process has completed, you can connect to your database.

How to disconnect Stripe from your Render account

  1. Go to the settings page for the app.

  2. Click the “Disconnect account” button.

You can also disconnect by using your Render Dashboard.

  1. Open your Render Dashboard.

  2. Go to the settings page for the team or personal account that you want to disconnect from Stripe.

  3. Press the “Disconnect from Stripe” button.

Schema

Tables prefixed with stripe_ will be added to the PostgreSQL database you picked, and kept up to date automatically. You can see the latest sync time and next sync time in your Stripe dashboard.

  • stripe_application_fee_refunds
  • stripe_application_fees
  • stripe_balance_transactions
  • stripe_bank_accounts
  • stripe_cards
  • stripe_charges
  • stripe_checkout_sessions
  • stripe_coupons
  • stripe_credit_notes
  • stripe_customers
  • stripe_disputes
  • stripe_early_fraud_warnings
  • stripe_files
  • stripe_invoice_items
  • stripe_invoices
  • stripe_issuing_authorizations
  • stripe_issuing_cardholders
  • stripe_issuing_cards
  • stripe_issuing_disputes
  • stripe_issuing_transactions
  • stripe_payment_intents
  • stripe_payment_links
  • stripe_payment_methods
  • stripe_payouts
  • stripe_plans
  • stripe_prices
  • stripe_products
  • stripe_promotion_codes
  • stripe_quotes
  • stripe_refunds
  • stripe_shipping_rates
  • stripe_subscription_schedules
  • stripe_subscriptions
  • stripe_sync_states
  • stripe_tax_rates
  • stripe_topups
  • stripe_transfer_reversals
  • stripe_transfers

Example queries

Check out our announcement blog post to see some example queries and output.

Synchronization frequency

New data in your Stripe account is inserted into your Render PostgreSQL database approximately once per hour.