{"slug":"agent402-tools-api-skill-onchain-analyst-179aaa","title":"Bundled execution of the Onchain analyst (SQL over Base) workflow","host":"agent402.tools","method":"POST","resource":"https://agent402.tools/api/skill/onchain-analyst","category":"code","description":"Bundled execution of the Onchain analyst (SQL over Base) workflow - Ask Base anything in one paid call: your SQL runs against Coinbase's indexed, DECODED chain data (events with parsed parameters, transactions, blocks, user-ops) with the live schema alongside - no indexer, no RPC archaeology. One x4","price_listed":0.021,"price_asked":0.021,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":913,"reported_calls_30d":2,"reported_payers_30d":1,"networks":["algorand:wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=","eip155:10","eip155:1329","eip155:137","eip155:143","eip155:42161","eip155:42220","eip155:43114","eip155:4663","eip155:8453","solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","stellar:pubnet"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"sql":"SELECT COUNT(*) AS blocks FROM base.blocks WHERE block_number > 32000000"},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"properties":{"sql":{"description":"Read-only ClickHouse-dialect SQL to run (SELECT/WITH only, time-bounded)","type":"string"}},"required":["sql"]},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"properties":{"args":{"properties":{"sql":{"type":"string"}},"type":"object"},"pack":{"type":"string"},"steps":{"items":{"properties":{"ok":{"type":"boolean"},"result":{"type":"object"},"slug":{"type":"string"}},"type":"object"},"type":"array"},"summary":{"type":"string"}},"required":["pack","args","steps","summary"],"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-09-24","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.021,"price_match":true,"latency_ms":913,"error":null}],"description_full":"Bundled execution of the Onchain analyst (SQL over Base) workflow - Ask Base anything in one paid call: your SQL runs against Coinbase's indexed, DECODED chain data (events with parsed parameters, transactions, blocks, user-ops) with the live schema alongside - no indexer, no RPC archaeology. One x402 payment runs 3 underlying tools (onchain-sql-schema, onchain-sql, stats-summary); partial-success per step.","last_updated":"2026-09-22T16:39:11.546Z","schemes":["exact","upto"]}