Submit raw SQL queries against 150+ blockchain datasets for async execution via Allium's onchain data platform.
What it does
Allium's async SQL query endpoint lets AI agents execute arbitrary SQL against Allium's indexed blockchain data covering 150+ chains including EVM, Solana, and Bitcoin networks. The endpoint is part of Allium's AgentHub, which packages enterprise-grade blockchain data infrastructure — the same pipelines used by Phantom, Uniswap, and Coinbase — for programmatic agent access.
The endpoint accepts raw SQL and runs it asynchronously, returning results that can be polled or retrieved later. Allium's data covers token prices (real-time and historical), wallet balances, transaction history, and onchain metrics. The platform supports both x402 machine-to-machine payments (USDC on Base) and traditional API key authentication. The AgentHub is installable as a skill via `npx skills add` for Claude Code, OpenClaw, or other skills-compatible agents.
Note: The probe returned 405 on HEAD and 403 on GET, which is consistent with a POST-only endpoint requiring authentication. The endpoint likely expects POST requests with a SQL payload and either an API key or x402 payment. No OpenAPI schema or detailed API documentation was available from the crawled pages, so the exact request/response format is inferred from the endpoint path and description.
Capabilities
Use cases
- —Running custom SQL queries against indexed blockchain data from 150+ chains
- —Retrieving historical and real-time token prices for portfolio analytics
- —Monitoring wallet balances and transaction activity across multiple chains
- —Building agent workflows that need onchain data lookups (PnL, holdings, transfers)
- —Generating onchain metrics and reports via ad-hoc SQL
Fit
Best for
- —AI agents needing structured onchain data via SQL
- —Developers building cross-chain analytics or monitoring tools
- —Automated portfolio tracking and wallet analysis workflows
Not for
- —Real-time sub-second streaming of blockchain events (this is async SQL, not websocket streaming)
- —Non-blockchain data queries — this is exclusively onchain data
Quick start
npx skills add https://github.com/allium-labs/skills --yes
# Or call directly via POST (API key or x402):
curl -X POST https://agents.allium.so/api/v1/explorer/queries/run-async \
-H 'Content-Type: application/json' \
-d '{"sql": "SELECT * FROM ethereum.transactions LIMIT 10"}'Example
Request
{
"sql": "SELECT * FROM ethereum.transactions LIMIT 10"
}Endpoint
Quality
No OpenAPI schema, no API documentation (docs page returns 404), no captured 402 challenge confirming liveness, and no detailed request/response format available. The endpoint path and description are the primary sources; request format is inferred. The landing page confirms the product exists and describes capabilities at a high level, but technical details are sparse.
Warnings
- —Probe did not capture a 402 MPP challenge — endpoint returned 405 (HEAD) and 403 (GET), suggesting POST-only with auth required. Liveness not fully confirmed via standard probe.
- —No OpenAPI or schema documentation available; /docs returns 404.
- —Request and response JSON formats are inferred from the endpoint name and description, not from actual documentation.
- —Pricing details (cost per query in USDC) are not documented in any crawled material.
- —Example request JSON is speculative — actual required fields may differ.
Citations
- —Allium indexes 150+ chains including EVM, Solana, and Bitcoinhttps://agents.allium.so
- —AgentHub supports x402 payments in USDC on Base or traditional API key authhttps://agents.allium.so
- —Allium's data infrastructure is used by Phantom, Uniswap, and Coinbasehttps://agents.allium.so
- —Skills can be installed via npx skills add command for Claude Code, OpenClaw, or skills-compatible agentshttps://agents.allium.so
- —Data includes token prices, wallet balances, transaction history, and onchain metricshttps://agents.allium.so