Skill: Onchain analyst (SQL over Base)

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.

TRY IN PLAYGROUND →

Input

Example output

{
  "pack": "onchain-analyst",
  "args": {
    "sql": "SELECT COUNT(*) AS blocks FROM base.blocks WHERE block_number > 32000000"
  },
  "steps": [
    {
      "slug": "onchain-sql-schema",
      "ok": true,
      "result": {}
    },
    {
      "slug": "onchain-sql",
      "ok": true,
      "result": {}
    },
    {
      "slug": "stats-summary",
      "ok": true,
      "result": {}
    }
  ],
  "summary": "3/3 steps succeeded"
}

Try it - see the 402 challenge (free)

curl -i -X POST https://agent402.tools/api/skill/onchain-analyst \
  -H "Content-Type: application/json" \
  -d '{"sql":"SELECT COUNT(*) AS blocks FROM base.blocks WHERE block_number > 32000000"}'

The response is HTTP 402 Payment Required with exact payment requirements. Any x402 v2 client pays automatically and retries:

Paid call (JavaScript agent)

import { wrapFetchWithPayment } from "@x402/fetch";
import { x402Client } from "@x402/core/client";
import { registerExactEvmScheme } from "@x402/evm/exact/client";
import { privateKeyToAccount } from "viem/accounts";

const client = new x402Client();
registerExactEvmScheme(client, { signer: privateKeyToAccount(KEY) });
const payFetch = wrapFetchWithPayment(fetch, client);

const res = await payFetch("https://agent402.tools/api/skill/onchain-analyst", {
  method: "POST",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
    "sql": "SELECT COUNT(*) AS blocks FROM base.blocks WHERE block_number > 32000000"
  }),
});

Related tools