Onchain SQL (query Base with SQL)

Run read-only SQL against Coinbase's indexed, DECODED blockchain data — base.events (decoded logs with parameters), base.transactions, base.blocks, base.decoded_user_operations, base.transaction_attributions (builder codes), plus solana.instructions and hyperevm.events. ClickHouse-dialect SELECTs, server-side grammar validation, up to 50k rows / 30s / 12 joins. Ask Base anything — token flows, event analytics, gas studies — in one call, no indexer to run.

Input

Example output

{
  "rows": [
    {
      "txs": 123456
    }
  ],
  "rowCount": 1,
  "note": "Result rows exactly as returned by the SQL engine."
}

Try it — see the 402 challenge (free)

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

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/onchain-sql", {
  method: "POST",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
    "sql": "SELECT COUNT(*) AS txs FROM base.transactions WHERE block_number > 0 LIMIT 1"
  }),
});

Related tools