{"uid":"cap__KhEHYUiAqO1kt1-smKcU","slug":"dune-execute-d0a165bb","name":"Dune SQL Execute","description":"Execute a SQL query","url":"https://api.dune.com/api/v1/sql/execute?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":null,"responseSchema":null,"example":null,"exampleRequest":null,"tags":["sql","analytics","blockchain","data","query"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":true,"priceHint":"$0.05-$4","priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":{"amountUsd":"10.00","asset":"USDC"},"pricing":{"kind":"dynamic","summary":"$0.05-$4 (dynamic)","primary":{"kind":"session","protocol":"mpp","network":"tempo","amountUsd":"0.05","per":"call","confidence":"exact","depositUsd":"10.00"},"accepted":[{"kind":"session","protocol":"mpp","network":"tempo","amountUsd":"0.05","per":"call","confidence":"exact","depositUsd":"10.00"},{"kind":"dynamic","protocol":"mpp","network":"tempo","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_MIGNFa9_PloYaKhYWmFzD","protocol":"mpp","methodType":"crypto","chain":"tempo","mode":"session","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x20c000000000000000000000b9537d11c60e8b50","unit":"request","depositMicros":10000000,"planRef":null},{"uid":"pm_l-xFUEjrwpAztIhRRDup3","protocol":"mpp","methodType":"crypto","chain":"tempo","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":"Dune","brandSlug":"dune","brandBaseUrl":"https://dune.com","brandDocsUrl":"https://docs.dune.com/api-reference/agents/mpp","whatItDoes":"Executes a SQL query against Dune's blockchain analytics database and returns an execution ID for result retrieval","exampleAgentPrompt":"Run this SQL query on Dune to get the top 10 wallets by ETH transfer volume in the last 7 days: SELECT from_address, SUM(value/1e18) as eth_sent FROM ethereum.transactions WHERE block_time > NOW() - INTERVAL '7 days' GROUP BY 1 ORDER BY 2 DESC LIMIT 10","exampleUseCases":null,"resultDescription":"Returns an execution ID and initial job status that can be used to poll for and retrieve the query results via the Dune Results endpoint","failureModes":["Invalid SQL syntax returns a parse error","Query references non-existent tables or columns returns schema error","Rate limit exceeded returns 429 with retry-after header","Authentication failure returns 401 if API key is missing or invalid","Query timeout for extremely complex queries against large datasets","Insufficient credits/balance returns 402 payment required"],"whenToPreferThis":"Use this endpoint when you need to run arbitrary SQL against Dune's comprehensive blockchain dataset covering raw transactions, decoded smart contract events, DeFi positions, NFT activity, stablecoin flows, and protocol analytics — especially when no pre-built query covers your exact analytical need","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":2,"lastUsedAt":"2026-08-28T17:29:06.162Z","lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T00:34:16.173Z","isFirstParty":false,"canonicalSlug":"dune-execute-d0a165bb"}