Agent context
Adyen models
4 SQL models that turn the raw Adyen tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions behind every number.
How the set is built
- 2Raw tables
- 2Staging
- 5Core
- 4Analytics
Staging cleans each raw table once, core holds the logic, and analytics is the table dashboards and agents read.
- Authorisation rateAuthorisation rate by day and payment method: of the payments that reached an authorisation decision, the share that were authorised.grain: day (first decision, report time zone) x merchant account x payment method x payment currency · 1 raw table
- Fees by payment methodWhat each payment method costs: settled volume, refunds, chargebacks and the transaction fees withheld, with interchange, scheme fees and markup broken out where Adyen has interchange level data.grain: day (creation date, report time zone) x merchant account x payment method x payment method variant x net (settlement) currency · 1 raw table
- Payment lifecycleOne row per payment with every step of its life: when it was received, authorised or refused, captured, settled, refunded and charged back, and the amounts Adyen booked at each step. Built from the Payment accounting report.grain: merchant account x PSP reference (one payment) · 1 raw table
- Settlement batchesAdyen's settlement batches, itemised: what was settled, what came back out as refunds and chargebacks, what Adyen and the card schemes withheld, and what was paid to your bank account. Recreates the batch view of the Settlement details report in the Customer Area.grain: merchant account x batch number x net (settlement) currency · 1 raw table
- Weld or dbt
- The same SQL in both dialects. Sync the folder with GitHub Sync, or copy the dbt models into your project.
- Check before you rely on it
- Reconcile a month against Adyen's own reports first. Each model's notes say what the synced data can and can't support.
Connect Adyen.
Your agents start with context.
Sync Adyen to your warehouse, deploy these models, and query them from Claude, Cursor or ChatGPT over MCP. Free for 14 days, no credit card.