{"uid":"cap_SQITQccoand8PgLgf14Ax","slug":"graphadvocate-x402-settlement-q-a-460c2ac9","name":"GraphAdvocate x402 Settlement Q&A","description":"Natural-language Q&A over the x402 Base settlements warehouse. POST {question}. Backed by 132M settlement rows on Cloudflare R2 + pre-aggregated daily_stats (388 days, May 2025 - Jun 2026), queried via Anthropic Sonnet + DuckDB. Returns {answer, sql_trace, model, upstream_ms}; sql_trace lets the caller verify the data path is real, not hallucinated. $0.05 USDC on Base.","url":"https://graphadvocate.com/ask","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"question":{"type":"string","maxLength":1000,"description":"Plain-English question about x402 Base settlements"}}},"responseSchema":{"type":"json","example":{"model":"claude-sonnet-4-6","answer":"# Top 10 recipients\n| Rank | Address | Count | USDC |\n...","dataset":"base-x402-settlements via x402-watch.vercel.app","question":"Top 10 recipient addresses last 30 days","sql_trace":[{"ms":1350,"sql":"SELECT recipient, COUNT(*) AS payment_count, SUM(amount::DECIMAL(38,0))/1e6 AS usdc_total FROM settlements WHERE block_number >= 45553999 GROUP BY recipient ORDER BY payment_count DESC LIMIT 10","rows":10}],"upstream_ms":3500}},"example":{"request":{"question":"What was the total USDC volume settled through x402 on Base in May 2025?"},"response":{"model":"claude-sonnet-4-6","answer":"Here's the summary for **May 2025** on Base:\n\n| Metric | Value |\n|---|---|\n| 💰 Total USDC Volume | **$110.86 USDC** |\n| 📄 Total Settlements | **702** |\n| 📅 Days with Activity | **21 out of 31** |\n\nA few notes:\n- The dataset begins on **May 9, 2025**, so only the final ~23 days of May are captured (21 of which had settlement activity). The first ~8 days of May are outside the dataset range.\n- All settlements use **USDC** (on Base mainnet) via the **EIP-3009** authorization flow.\n- The relatively modest volume reflects the early days of the x402 protocol, which was just getting started in this period.","dataset":"base-x402-settlements via x402-watch.vercel.app","question":"What was the total USDC volume settled through x402 on Base in May 2025?","sql_trace":[{"ms":960,"sql":"SELECT\n  SUM(total_usdc) AS total_usdc_volume,\n  SUM(settlement_count) AS total_settlements,\n  COUNT(*) AS days_counted\nFROM daily_stats\nWHERE day >= '2025-05-01'\n  AND day < '2025-06-01'","rows":1}],"upstream_ms":9183,"generated_at":"2026-06-12T04:16:45.019407+00:00"}},"exampleRequest":{"question":"What was the total USDC volume settled through x402 on Base in May 2025?"},"tags":["x402"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm__vAf_hYyMkiwPMPZ2dJIt","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Natural-language Q&A over 132M x402 Base settlement rows, returning an answer, the SQL trace used, and upstream latency.","exampleAgentPrompt":"How much total USDC was settled through x402 on Base in May 2025, and which day had the highest volume? I want to see the SQL trace so I can verify the query.","exampleUseCases":null,"resultDescription":"Returns a JSON object with: `answer` (natural-language response to the question), `sql_trace` (the exact DuckDB SQL query executed so the caller can verify the data path), `model` (the Anthropic model used), and `upstream_ms` (query latency in milliseconds). Covers 132M settlement rows and 388 days of pre-aggregated daily_stats (May 2025–Jun 2026).","failureModes":["Question is too ambiguous for the model to generate valid SQL — returns an error or empty answer","DuckDB query times out on very broad aggregations over 132M rows","x402 settlement data not yet available for requested date range (only May 2025–Jun 2026)","Invalid or malformed POST body — missing `question` field","Payment not confirmed — x402 $0.05 USDC charge fails, request rejected"],"whenToPreferThis":"Use this endpoint when you need auditable, SQL-verifiable answers about x402 Base settlement data at scale. It is the only service with 132M settlement rows queryable via natural language with a sql_trace for verification — ideal for agents that need to cross-check on-chain payment analytics without hallucination risk.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T12:56:07.505Z","isFirstParty":false}