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
| Dataset | Cluster ID | Coverage | Reference |
|---|---|---|---|
| EVM | evm-mainnet | Blocks, transactions, logs, traces, transfers, and contracts | EVM Schema |
| Hyperliquid HyperCore | hyperliquid-core-mainnet | Trades, orders, funding, market data, and more | HL 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.