{"uid":"cap_YGnrIu0RCul3on3hEUlG-","slug":"allium-run-async-c1bd7436","name":"Allium SQL Explorer Run Async","description":"Submit raw SQL for async execution","url":"https://agents.allium.so/api/v1/explorer/queries/run-async?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"parameters":{"type":"object","description":"Key-value map of query parameter substitutions","additionalProperties":{"type":"string"}}}},"responseSchema":null,"example":{"request":{"parameters":{"sql":"SELECT COUNT(*) as transaction_count, chain FROM transactions WHERE block_timestamp >= NOW() - INTERVAL '24 HOUR' GROUP BY chain LIMIT 10"}},"response":{"run_id":"2CKrepgO6oHlPHahYAoG_20260605T040028_coats"}},"exampleRequest":{"parameters":{"sql":"SELECT COUNT(*) as transaction_count, chain FROM transactions WHERE block_timestamp >= NOW() - INTERVAL '24 HOUR' GROUP BY chain LIMIT 10"}},"tags":["blockchain","prices","tokens","wallet","balances","transactions","pnl","sql","explorer","solana","base","defi","data"],"displayCostAmount":"0.03","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.33","reviews":0,"stars":null,"state":"rated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.03/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"},{"kind":"static","protocol":"mpp","network":"tempo","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_6hJMBvevFRc5UIxzNyJct","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null},{"uid":"pm_Lwtntm15vR86ztrHiYVb5","protocol":"mpp","methodType":"crypto","chain":"tempo","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x20c000000000000000000000b9537d11c60e8b50","unit":"request","depositMicros":null,"planRef":null}],"brandName":"Allium","brandSlug":"allium","brandBaseUrl":"https://allium.so","brandDocsUrl":"https://docs.allium.so","whatItDoes":"Submit raw SQL for asynchronous execution against Allium's onchain blockchain data explorer","exampleAgentPrompt":"Submit this SQL for async execution on Allium's blockchain explorer: 'SELECT wallet_address, SUM(amount_usd) as total_volume FROM solana.transactions WHERE block_timestamp >= NOW() - INTERVAL 7 DAY GROUP BY wallet_address ORDER BY total_volume DESC LIMIT 100' — use the parameters map if any substitutions are needed.","exampleUseCases":null,"resultDescription":"Returns a job/run identifier that can be used to poll the Status endpoint for completion and retrieve results once the async SQL query finishes executing against Allium's onchain blockchain dataset.","failureModes":["Invalid SQL syntax returns a 400 error with parse details","Missing or malformed parameters object causes a validation error","Query timeout for extremely large or unoptimized SQL scans","Authentication failure (402 or 401) if payment or credentials are missing","Rate limiting if too many concurrent async queries are submitted"],"whenToPreferThis":"Use this endpoint when you need to execute custom, ad-hoc raw SQL queries against Allium's blockchain data and the query may take longer than a synchronous response allows. Prefer this over saved-query endpoints when your SQL is dynamic or parameterized at runtime. Choose this when analyzing large onchain datasets across Solana, Base, or other supported chains where batch/async processing is appropriate.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":3,"lastUsedAt":"2026-05-27T18:54:45.582Z","lastSuccessfullyRanAt":"2026-05-27T18:54:45.582Z","lastHealthCheckAt":"2026-10-12T12:36:13.571Z","isFirstParty":false,"canonicalSlug":"allium-run-async-c1bd7436"}