ASasksurf
Onchain

On-Chain Table Schema

Discover tables and columns before writing SQL or structured queries. Example: call this endpoint first, then use agent.ethereum_dex_trades in /v1/onchain/query or /v1/onchain/sql.

The response includes database name, table name, column names, types, and comments. Pass the optional table parameter to include bounded physical source metadata: engine, partition key, sorting key, primary key, row estimate, and compressed bytes.

For transfer tables, amount is decimal-adjusted display units and amount_raw is the original base-unit value.

get/gateway/v1/onchain/schema

Request

  • Base URL
    https://api.asksurf.ai
  • Auth
    HTTP bearer

Query parameters

tablestring

Optional logical table name from the agent database. Use this to include bounded physical partition, ordering-key, and size metadata.

Example:polymarket_trades

Response

OK

$schemastring uri

A URL to the JSON Schema for this object.

Example response

{
  "$schema": "https://example.com/schemas/DataResponseOnchainSchemaTable.json"
}

Changes

No recorded changes to this operation across all 12 revisions of this API.