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 workspace

Write SQL or start with a question.

What are our most popular active plans?

PostgreSQL

Loading SQL editor…

No results yet

Run the query above, or choose a starting point from the query library.