Onchain SQL (query Base with · Onchain SQL

import { wrapFetchWithPayment } from "@x402/fetch";
import { privateKeyToAccount } from "viem/accounts";

const account = privateKeyToAccount(process.env.PRIVATE_KEY);
const fetchWithPay = wrapFetchWithPayment(fetch, account);

const res = await fetchWithPay("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"
  }),
});
const data = await res.json();

curl -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"}' \
  -H "X-PAYMENT: <signed x402 payment>"

{
  "rowCount": 1,
  "rows": [
    {
      "txs": 123456
    }
  ]
}