Onchain SQL schema · Onchain SQL Schema

by Onchain SQL schema

GETBaseSolanaArbitrumPolygonMonadAvalancheeip155:1329OptimismFraxtaleip155:42220stellar:pubnetalgorand:wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=

$0.002

per call · USD Coin on Base

The table + column schema for the onchain-sql tool - every queryable table (base.events, base.transactions, base.blocks, base.decoded_user_operations, base.transaction_attributions, solana.instructions, …) with its columns and types. Fetch once, then write SQL with confidence.

Endpoint

GET https://agent402.tools/api/onchain-sql-schema

5

Calls / 30d

3

Unique payers / 30d

Aug 31

Last called

exact

Payment scheme

Call this service

TypeScript · @x402/fetch
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-schema", {
  method: "GET",
});
const data = await res.json();
cURL
curl -X GET \
  "https://agent402.tools/api/onchain-sql-schema" \
  -H "X-PAYMENT: <signed x402 payment>"

Example response

{
  "schema": {
    "base.events": [
      {
        "name": "block_number",
        "type": "UInt64"
      }
    ]
  }
}

Payment details

Pay to0xabf4fabd7c416fb67202e5f9002389fc75e2a9d0
AssetUSD Coin · 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913
NetworksBase, Solana, Arbitrum, Polygon, Monad, Avalanche, eip155:1329, Optimism, Fraxtal, eip155:42220, stellar:pubnet, algorand:wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=
Schemesexact, upto

Is this your API?

Pin it to the top of Onchain Data and the homepage with a featured placement.

Get featured →

More from Onchain SQL schema & similar services