{"uid":"cap_0hmr1-MMA6-APc5tx7paH","slug":"agents-allium-so-52986032","name":"Allium Explorer Run Async (Raw SQL)","description":"API request: /api/v1/explorer/queries/run-async","url":"https://agents.allium.so/api/v1/explorer/queries/run-async","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","bodyType","body","method"],"properties":{"body":{"type":"object","properties":{"parameters":{"type":"object","description":"Key-value map of query parameter substitutions","additionalProperties":{"type":"string"}}}},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":{"type":"json","example":{"run_id":"a1b2c3d4-e5f6-7890-abcd-ef1234567890"}},"example":{"request":{"parameters":{"sql":"SELECT chain, COUNT(*) as transaction_count FROM transactions WHERE chain = 'ethereum' LIMIT 10","chain":"ethereum"}},"response":{"run_id":"2CKrepgO6oHlPHahYAoG_20260616T040155_truck"}},"exampleRequest":{"parameters":{"sql":"SELECT chain, COUNT(*) as transaction_count FROM transactions WHERE chain = 'ethereum' LIMIT 10","chain":"ethereum"}},"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_6QI8BXVaNnZQlOVaCYKKx","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Submits a raw SQL query for asynchronous execution against Allium's onchain blockchain data explorer","exampleAgentPrompt":"Run this SQL query against Allium's onchain explorer asynchronously: SELECT wallet_address, SUM(amount_usd) as total_volume FROM transactions WHERE chain = 'ethereum' AND block_timestamp >= '2024-01-01' GROUP BY wallet_address ORDER BY total_volume DESC LIMIT 100","exampleUseCases":null,"resultDescription":"Returns an async job ID that can be polled for status and results; once complete, delivers tabular onchain data rows matching the submitted SQL query against Allium's blockchain data warehouse","failureModes":["Invalid SQL syntax returns a parse error","Query references non-existent table or column names","Query times out for excessively complex or large scans","Insufficient USDC balance to cover the $0.01 per-call fee","Rate limiting if too many concurrent async jobs submitted","Job ID not found when polling if expired or invalid"],"whenToPreferThis":"Use this endpoint when you need to run a fully custom, arbitrary SQL query against Allium's onchain blockchain data — for example, complex aggregations, multi-table joins, or bespoke analytics not covered by Allium's pre-built endpoints for balances, prices, or transaction history. Prefer this over saved-query endpoints when the query is ad-hoc or unique to your use case.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-16T00:44:28.160Z","isFirstParty":false}