{"uid":"cap_vCy5_8LKUhBHeQsxPFKsG","slug":"db-gedx402-com-sql-query-ac2381ff","name":"db.gedx402.com SQL Query","description":"Read-only SQL on shared agent memory database. POST SELECT with optional params; results capped at 1000 rows. With valid session_token from POST /v1/memory/sessions, no x402 until query credits exhausted. x402 settlement USDC per request (see npm run pricing:report) worst-case per standalone query. Hero: GET /heroes/sql-query. Bundle: GET /v1/models?bundle=memory. Shard omitted from default OpenAPI discovery.","url":"https://db.gedx402.com/v1/sql/query","method":"GET","headers":{},"bodySchema":{"type":"object","properties":{"sql":{"type":"string"},"params":{"type":"array","items":{"type":"string"}},"session_token":{"type":"string"}}},"responseSchema":{"type":"json","example":{"meta":{"rows_read":1,"duration_ms":2},"results":[{"id":"run-1","body":"hello"}],"service":"gedx402-memory"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.007","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.007/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.007","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.007","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_3-e8LYn0tFf4dR2tI-INa","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.007","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Execute read-only SQL SELECT queries against a hosted Cloudflare D1 database via x402 micropayment, no API key required","exampleAgentPrompt":"Query the db.gedx402.com database for the latest 10 entries from the 'runs' table — something like SELECT id, body FROM runs ORDER BY id DESC LIMIT 10.","exampleUseCases":null,"resultDescription":"Returns a JSON object with a 'results' array containing the matched rows, a 'meta' object with rows_read count and duration_ms, and a 'service' field identifying the backend as cloudflare-d1.","failureModes":["Invalid or non-SELECT SQL returns an error (only read-only queries are permitted)","Payment failure if USDC balance is insufficient on the selected chain","Malformed params array causes binding error","Query timeout for long-running or complex queries","Network error contacting the x402 endpoint"],"whenToPreferThis":"Choose this endpoint when you need to run ad-hoc read-only SQL queries against a hosted Cloudflare D1 database without needing to obtain or manage API keys, paying per-query with USDC on Base, Polygon, Arbitrum, World, or Solana.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T06:39:31.581Z","isFirstParty":false}