How much did we capture in card payments last month?
Stripe
You captured $482,300 across 6,214 charges, up 9% on the prior month.
Via Kondado MCP
You
Which subscription plan grew the most this quarter?
Subscriptions
The Growth plan added 318 active subscriptions, a 24% increase over Q1.
Via Kondado MCP
You
What is our refund rate on the top-selling products?
Refunds
Refunds represent 2.7% of revenue, concentrated in 3 of the 40 products sold.
Via Kondado MCP
You
How many disputes are still open right now?
Disputes
11 disputes are open, with 4 evidence deadlines in the next 7 days.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client
Try out all the features for free for 14 days
AI to analyze Stripe data with Claude and ChatGPT
Kondado lets you ask Claude, ChatGPT or any other MCP client questions in plain language about your Stripe account and read the answers right in the chat. You can type something like “how much did we collect in card payments last month?” or “which plan is driving the most subscription revenue?” and the assistant works from your replicated Stripe data. No SQL, no spreadsheet exports, no waiting for someone to build a report.
Kondado replicates 51 Stripe pipelines with 1,971 fields and exposes them through an MCP server, so Claude, ChatGPT and any other MCP client can answer questions about charges, subscriptions, invoices, refunds, disputes and payouts directly in chat. The same data also feeds ready dashboards in Power BI and Looker Studio.
Finance and operations teams use the chat to reconcile payouts against balance transactions, while e-commerce and subscription managers ask about MRR movement, failed payments and refund rates. A payments analyst can compare dispute volume by reason across quarters, and a founder can ask which coupons actually moved revenue. Every answer comes from the same replicated Stripe data, so numbers stay consistent between the chat and your dashboards.
Below you can see the 51 Stripe pipelines available to query in chat. Asking about Charges reveals how much was captured, refunded and disputed per currency, while Payment intents shows which confirmation methods convert best. Subscriptions and Subscription items answer questions about active plans, trial conversions and quantity changes, and Disputes surfaces the reasons and evidence due dates behind chargebacks. Payouts and Balance transactions let you trace what actually landed in the bank against the fees Stripe charged.
Combine them in a single question and the analysis gets sharper: cross Charges with Customers to find which cohorts generate the highest average order value, or join Refunds with Products to spot the items with the heaviest return pattern. Because Kondado refreshes each pipeline on a configurable schedule, the answers you get in chat reflect the latest replicated data.
How to connect Stripe to Claude, ChatGPT and other AI clients
MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.
Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.
51
Tables
1971
Fields
∞
Ad-hoc questions
Subscription schedules
Registry of subscription schedules, with id, customer, subscription, status, creation, cancellation, completion and release dates, current phase, billing mode, default settings, end behavior, and live-mode flag.
Early fraud warnings
Record of early fraud warnings, with id, actionable flag, related charge and PaymentIntent, creation timestamp, fraud type, and live/test mode.
Tax rates
Tax rate record with identifier, active status, country, state and jurisdiction, display name, percentage and effective percentage, flat amount and currency, inclusive flag, rate type and tax type, creation timestamp, and live mode.
Subscriptions
Subscription record with identifier, customer, status, collection method, currency, billing cycle and anchor, creation, start, cancellation and end dates, fee amounts and percentages, discounts, thresholds, invoice and trial settings, plus schedule and pending updates.
Subscriptions - Details - Subscription items
Subscription items, with id, associated subscription and price, quantity, billing and trial periods, usage thresholds, and price attributes such as currency, unit amount, recurring interval, and usage type.
Customers
Stripe customer records, with identifier, name/business, email, address, balance and currency, invoice settings, tax data, shipping, discount, cash balance, and creation timestamp.
Customers - Details - Tax IDs
Registry of each customer's tax IDs (CNPJ, CPF, VAT, etc.), with country, type, value, verification status, creation timestamp, and customer, account, and owner references.
Customers - Details - Payment methods
Payment methods linked to customers, with identifiers, billing details, card details (brand, expiry, last four digits, checks), bank accounts, and digital wallets.
Each row is a customer credit balance transaction, with id, customer_id, amount, ending_balance, currency, type, created, description, livemode, and related IDs for checkout_session, credit_note, customer, customer_account, and invoice.
Charges
Stripe charge records with id, amount, captured and refunded amounts, currency, creation date, status, paid/captured/refunded/disputed flags, customer, PaymentIntent, payment method, balance transaction, risk outcome, and billing/shipping details.
Billing credit grants
Registry of billing credit grants issued to customers for consumption-based billing, with id, customer/account, monetary amount and currency, type, category, priority, price scope, effective/expiration/void timestamps, live/test mode, and creation/update timestamps.
Connected accounts (Connect)
Registry of connected accounts (Connect), with identifier, business profile (name, MCC, type, estimated annual and monthly revenue, estimated worker count), support details, and payment capability statuses.
Disputes
Stripe dispute records, with id, disputed amount, currency, related charge and PaymentIntent, reason, status, creation and evidence due dates, plus evidence and eligibility details.
Coupons
Registry of discount coupons, with identifier, name, amount or percentage off, currency, duration and duration in months, redemption limits and count, redemption deadline, validity status, livemode flag, and creation timestamp.
Promotion codes
Registry of promotion codes customers enter to apply a coupon, with identifier, code, active status, customer, expiration, redemption limits and count, promotion type, and minimum-amount and first-transaction restrictions.
Events
Record of Stripe account events, with id, account, API version, context, creation time, livemode, pending webhooks, request details, event type, and the affected object's id and type.
Invoices
Registry of invoices, with identifier, customer, currency, amounts due/paid/remaining, creation and due dates, collection method, billing reason, and automatic tax status.
Invoices - Details - Invoice line items
Each row represents a Stripe invoice line item, with invoice, subscription, and parent identifiers, plus amount, subtotal, currency, quantity/quantity_decimal, period_start/period_end, description, discountable, livemode, parent_type, and pricing details (price, product, pricing_type).
Entitlement features
Registry of features that can be granted to customers by product, with unique identifier, active status, live-mode flag, lookup key, and name.
Setup intents
Each row records a SetupIntent, with id, customer, status, usage, created, payment_method, cancellation_reason, last_setup_error fields, automatic_payment_methods, mandate, latest_attempt, and livemode.
Payment intents
Payment intent records, with id, amount and amount received, currency, status, creation date, customer, payment method, capture and confirmation method, cancellation reason, latest charge, and transfer data.
Invoice items
Record of an invoice item, with id, amount and currency, linked customer and invoice, date, description, quantity, discount and proration flags, period, and pricing/subscription details.
Payment links
Registry of payment links, with identifier, active status, URL, currency, post-purchase behavior, tax, invoice, PaymentIntent, subscription, application fee, transfer amount, and session restriction settings.
Payment links - Details - Line items
Line items of payment links, with payment_link_id, id, quantity, description, currency, discount, subtotal, tax and total amounts, plus price data (id, type, billing scheme, recurring interval and unit amount) and adjustable quantity limits.
Radar value lists
Each row represents a Radar value list, with id, alias, name, item type, creator, creation timestamp, and live mode indicator.
Radar value lists - Details - Items
Item in a Radar value list, with its own and parent list identifiers, value, creation timestamp, creator, and live-mode indicator.
Billing meters
Registration of usage billing meters for consumption-based billing, with id, display_name, event_name, default_aggregation_formula, customer_mapping_type, event_time_window, status, livemode, and creation, update, and deactivation timestamps.
Credit notes
Credit notes issued or voided, with identifier, customer, invoice, status, reason, currency, amounts (subtotal, total, tax, shipping and payment amounts), creation/effective/void dates, and PDF link.
Credit notes - Details - Line items
Each row represents a credit note line item, with credit note and item IDs, amount, description, discount amount, linked invoice line item, livemode flag, quantity, type, and unit amounts.
Quotes
Record of quotes with id, status, customer, invoice and subscription, currency, subtotal/total amounts and computed recurring and upfront totals, discount, shipping and tax details, creation/expiration/status-transition dates, and invoice and subscription settings.
Quotes - Details - Line items
Each row represents a quote line item, with quote_id and id, description, quantity, currency, discount, subtotal, tax, and total amounts, plus price details (id, type, unit amount, recurrence, product) and adjustable quantity limits.
Invoice payments
Payments applied to invoices, with id, related invoice, paid and requested amounts, currency, status, payment type and originating payment references, default flag, livemode, and creation, payment, and cancellation timestamps.
Plans
Registry of recurring price plans, with id, active status, amount and currency, billing scheme, interval and interval count, product, nickname, tiers mode, usage type, trial days, meter, usage transformation, creation timestamp, and live/test mode.
Prices
Registry of product prices (one-time or recurring), with id, active status, currency, unit amount, billing scheme, recurring interval, associated product, and tier and tax settings.
Products
Stripe catalog product record, with identifier, name, description, active status, default price, package dimensions, tax code, unit label, URL, and creation and update timestamps.
Top-ups
Record of each balance top-up, with id, amount and currency, status, creation time, balance transaction, payment method, initiator, failure code/message, expected availability date, description, statement descriptor, source ID, and transfer group.
Refunds
Each row represents a Stripe refund, with id, amount, currency, status, reason, creation date, links to charge, customer, and PaymentIntent, plus balance transaction, destination, failure/pending, and presentment details.
Payouts
Each row is a payout, with id, amount, currency, status, creation and arrival dates, method, destination, balance transaction, failure code/message, and reversal references.
Payouts - Details - Payout transactions
Each row is a balance transaction linked to a payout, with identifier, gross amount, fee, net amount, currency, status, type, reporting category, availability and creation dates, source, and exchange rate.
Radar reviews
Each row represents a Radar review, with its identifier, associated charge and PaymentIntent, open/closed status and reasons, creation timestamp, IP and location data, session details, and live-mode flag.
Current balance
Current Stripe account balance per balance type and currency, with amount, portions from cards, bank accounts, and FPX, production/test mode flag, and read timestamp.
Checkout sessions
Checkout sessions, with unique id, creation and expiration timestamps, currency, subtotal and total amounts, customer, invoice, and PaymentIntent references, plus address, tax, branding, and consent data.
Checkout sessions - Details - Line items
Line items of a checkout session, with session and item identifiers, quantity, description, currency, discount, subtotal, tax and total amounts, plus price details such as product, type, recurrence, tax behavior and unit amount.
Identity verification sessions
Each row represents an identity verification session, with id, client_reference_id, created, status, type, livemode, document/email/phone and matching options, provided details, latest error, redaction_status, related customer/person, verification_flow, and verified outputs (address, date of birth, email, name, ID number, phone, and sex).
Shipping rates
Each row represents a shipping rate, with id, active status, creation time, display name, delivery estimate minimum/maximum unit and value, fixed amount and currency, livemode, tax behavior, tax code, and calculation type.
Application fees
Each row represents a Stripe application fee, with its identifier, account, application, related charge and balance transaction, amount and amount refunded, currency, creation time, fee source, live mode, and full-refund indicator.
Terminal readers
Registry of terminal readers, with id, label, serial number, device type and software version, IP address, location, network status, last seen, livemode, and action details such as type, status, API errors, refund, display, print, and processing configurations.
Terminal locations
Registry of physical locations for Stripe Terminal readers, with id, address (including kana/kanji variants), display name, configuration override, phone, and live-mode flag.
Balance transactions
Each row is a Stripe balance transaction, with id, gross amount, fee, net impact, currency, exchange rate, creation and availability dates, balance type, reporting category, source, status, and transaction type.
Transfers
Stripe transfer record with identifier, amount and reversed amount, balance transaction, creation timestamp, currency, description, destination account, destination payment, live mode, reversal status, source charge, source type, and transfer group.
Transfers - Details - Reversals
Transfer reversals, with id, reversed transfer, amount, currency, creation timestamp, balance transaction, and linked source/destination payment refunds.
In 3 steps: connect on Kondado, pick dashboard or chat, analyze.
1
Connect Stripe on Kondado
Sign in at app.kondado.com.br, add Stripe as a data source and choose a Via Kondado destination so your data lands ready for AI access and for the dashboard templates.
2
Add the Kondado MCP server
Open the connection settings in Claude (Web or Desktop) or in ChatGPT, add the Kondado MCP server and authorize once via OAuth. The setup is identical in both clients, with no code or command line.
3
Ask about Stripe in chat
Use natural language to question charges, subscriptions, invoices or payouts and follow up with more detail. For visual recurring monitoring, open a ready Power BI or Looker Studio dashboard template built on the same data.
Try out all the features for free for 14 days
Other connectors with AI via MCP
Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.
How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.
What can I ask Claude or ChatGPT about my Stripe account?▼
You can ask about captured volume by currency, MRR movement, trial conversion, refund and dispute rates, payout timing and customer lifetime value. Questions work best when they name the metric and the period, for example "how many subscriptions canceled in the last 90 days and why". The assistant answers from the replicated Stripe pipelines and returns the numbers inside the chat.
How do I add Kondado to Claude Web or ChatGPT?▼
Open the connection settings in Claude (Web or Desktop) or in ChatGPT and add the Kondado MCP server as a new connection. The flow is the same in both clients and takes a couple of minutes, with no code or command line involved. Once connected, your Stripe pipelines become available as context for your questions.
How does authentication work?▼
You authorize Kondado once through OAuth at app.kondado.com.br, signing in with your Kondado account. After that, the client you configured can query the Stripe pipelines you already replicate. If you remove the authorization, the connection stops until you approve it again.
Can the AI change, create or delete anything in Stripe?▼
No. The chat is read-only: the assistant queries replicated Stripe data and returns analysis, it never writes back to Stripe. Refunds, cancellations and customer edits stay in the Stripe dashboard. Kondado is built for analysis, not for making changes at the source.
How current are the numbers the AI sees?▼
Kondado updates each Stripe pipeline on a configurable schedule that you define in the platform. If you pick a shorter interval, the chat reflects more recent charges, invoices and payouts. The answer you get in chat always matches the last replication cycle.
Which dashboard templates can I open for Stripe?▼
Kondado offers ready report templates for Power BI and Looker Studio covering payments, subscriptions, refunds and payouts. They read the same replicated Stripe data as the chat, so figures line up between both views. They sit alongside the AI chat and are meant for visual, recurring monitoring.
What is the difference between asking in chat and opening a dashboard?▼
The chat is exploratory: you ask a specific question, get a written answer with numbers and keep digging with follow-ups. A ready dashboard is fixed and visual, designed to be reopened on a routine to track the same set of KPIs. Many teams use both, asking in chat when a number looks off and checking the dashboard for the weekly review.
Do other MCP clients work besides Claude and ChatGPT?▼
Yes. MCP is an open standard, so any MCP client can connect to the Kondado server and query the same Stripe pipelines. Claude and ChatGPT are simply the most popular options for business users. Setup varies slightly per client but always goes through the connection settings and OAuth.
Stripe
Via Kondado MCP
