Skip to main content

SQL Explorer Schema

Updated on
Nov 16, 2026

What Is a Schema?​

A SQL Explorer schema describes the tables you can query in a dataset. For each table, it lists column names and data types, plus sort keys and partition strategies that help you write efficient SQL.

Each dataset has a cluster ID for REST API requests. The EVM cluster contains multiple networks; use the network column to select one. See Using the REST API for authentication and query requests.

Available Schemas​

DatasetCluster IDCoverageReference
EVMevm-mainnetBlocks, transactions, logs, traces, transfers, and contractsEVM Schema
Hyperliquid HyperCorehyperliquid-core-mainnetTrades, orders, funding, market data, and moreHL Schema

Accessing a Schema​

Use the static files for a snapshot of table definitions, or fetch the schema through the API for the current structure.

Downloadable Files​

The files are updated periodically:

The text files are useful for AI agent context; the JSON files contain machine-readable table and column definitions.

Schema API​

Fetch the current schema with the REST API. Replace {clusterId} with a cluster ID from the table above and provide your API key:

curl 'https://api.quicknode.com/sql/rest/v1/schema/{clusterId}' \
-H 'x-api-key: YOUR_API_KEY'

The response includes table names, engines, columns and types, sort keys, and partition strategies. Here is an abbreviated Hyperliquid response:

{
"chain": "Hyperliquid (HyperCore)",
"cluster_id": "hyperliquid-core-mainnet",
"tables": [
{
"name": "hyperliquid_agents",
"engine": "SharedReplacingMergeTree",
"sorting_key": ["block_number", "agent"],
"partition_key": "toYYYYMM(snapshot_time)",
"columns": [
{ "name": "block_number", "type": "UInt64" },
{ "name": "agent", "type": "FixedString(42)" }
]
}
]
}

Using Schemas with AI Agents​

Give an agent the JSON or text schema for the dataset you want it to query. Ask it to use the listed column types, sort keys, and partitions when generating SQL. For EVM queries, also specify a network and consult evm_native_currencies for valid network values.

The Build Web3 plugin includes SQL Explorer schema and query guidance. In Claude Code:

/plugin marketplace add quicknode/agent-plugins

For a custom agent, fetch or download the schema, include it in the prompt context, and request a query against its listed tables. For example:

Using the Hyperliquid schema, find the top 10 traders by volume in the last 24 hours. Filter on the relevant time column and explain the sort keys used.

Using the EVM schema, find recent native transfers for a specified network and recipient. Return wei amounts and hex-encoded addresses.