payquery.

Schema

customers9

Provider-specific customer records. The same person at two providers remains two rows.

idtext
providertext
external_idtext
emailtext
nametext
countrytext
currencytext
created_attimestamp
metadatajsonb

subscriptions11

Current subscription snapshots with normalized status and estimated recurring amounts in provider minor units.

idtext
providertext
customer_idtext
statustext
currencytext
mrr_minorbigint
started_attimestamp
current_period_endtimestamp
canceled_attimestamp
ended_attimestamp
trial_endtimestamp

subscription_items4

Price and quantity lines on a subscription.

idtext
subscription_idtext
price_idtext
quantityint

transactions15

Stripe charges and Paddle transactions with a shared status vocabulary.

idtext
providertext
customer_idtext
subscription_idtext
statustext
currencytext
amount_minorbigint
fee_minorbigint
tax_minorbigint
net_minorbigint
payment_method_typetext
countrytext
created_attimestamp
paid_attimestamp
failure_codetext

invoices11

Invoices (Stripe) and billed transactions (Paddle).

idtext
providertext
customer_idtext
subscription_idtext
statustext
currencytext
total_minorbigint
tax_minorbigint
created_attimestamp
paid_attimestamp
due_attimestamp

refunds8

Cash refund records. Completed states are Stripe succeeded and Paddle approved; exclude pending or rejected refunds.

idtext
providertext
transaction_idtext
currencytext
amount_minorbigint
reasontext
statustext
created_attimestamp

disputes8

Stripe disputes and Paddle chargebacks, with provider-specific lifecycle statuses.

idtext
providertext
transaction_idtext
currencytext
amount_minorbigint
reasontext
statustext
created_attimestamp

payouts7

Stripe payout records, including pending and failed payouts. Filter status to paid for completed payouts.

idtext
providertext
currencytext
amount_minorbigint
statustext
arrival_datedate
created_attimestamp

products5

Canonical products records.

idtext
providertext
nametext
activeboolean
created_attimestamp

prices9

Canonical prices records.

idtext
providertext
product_idtext
currencytext
unit_amount_minorbigint
billing_intervaltext
interval_countint
usage_typetext
activeboolean

discounts7

Canonical discounts records.

idtext
providertext
codetext
percent_offnumeric
amount_off_minorbigint
currencytext
activeboolean

subscription_events6

Estimated starts and ends reconstructed from current subscription snapshots. Historical plan changes are not captured.

subscription_idtext
customer_idtext
occurred_attimestamp
kindtext
delta_mrr_minorbigint
currencytext

mrr_daily5

Estimated daily MRR from current subscription snapshots, by provider and currency; not a complete historical ledger.

daydate
providertext
currencytext
mrr_minorbigint
active_subscriptionsint

raw_objects5

Latest synced provider objects in JSON. Coverage depends on connector endpoints and granted permissions.

providertext
object_typetext
idtext
updated_attimestamp
datajsonb

Connect your data

Query library

SQL for common payment questions. Open a query to edit and run it.

12 queries

Query library

What is our MRR by month, per processor?

Which payments failed in the last 30 days, and why?

Who churned this month and how much MRR did we lose?

Where do our gross collections come from, by country?

What share of each month's collected payments was refunded?

Why do customers dispute payments?

Which invoices are still unpaid?

What are our most popular active plans?

How does subscription retention look by signup cohort?

How do customers pay us?

How do Stripe and Paddle compare side by side?

What did we get paid out in the last 30 days?