Get schema details
SQL API
Get schema details
Retrieve the schema information for the available tables in the SQL API’s indexed data.
This includes table names, column definitions, data types, and indexed fields.
GET
Get schema details
Authorizations
A JWT signed using your CDP API Key Secret, encoded in base64. Refer to the Generate Bearer Token section of our Authentication docs for information on how to generate your Bearer Token.
Query Parameters
The name of the database to query. Defaults to "base" when not specified.
Available options:
base, base_sepolia Get the schema for a specific table.
Response
Schema information retrieved successfully.
Schema information for available blockchain data tables.
List of available tables.
Example:
[
{
"database": "base",
"table": "events",
"columns": [
{
"name": "event_signature",
"type": "String",
"nullable": false,
"description": "The signature of the decoded event log.",
"indexOrder": 0
}
]
}
]