Discovery
Describe Data Schema
describe_schemasample
sp500
full
Returns the Parquet schema for all tables in the Valuein SEC data warehouse: table descriptions, column names, types, primary keys, and foreign-key references. Use this tool before querying with other tools to understand the data model. No data reads required — schema is embedded in the manifest.
Example Call
# Using the Valuein MCP server from Python (via MCP SDK)
# Or call directly from Claude / Cursor after setup
result = await client.call_tool(
"describe_schema",
arguments={}
)
print(result)Direct tool call:describe_schema(table="fact")
Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | optional | Filter to a single table name (e.g. 'fact', 'entity', 'references'). Omit to return the full schema for all tables. |
Output Fields
tablescolumnstypesprimary_keysforeign_keysdescriptionExample Response
{
"tables": null,
"columns": null,
"types": null,
"primary_keys": null,
"foreign_keys": null,
"description": null
}Returns the column definitions and types for the fact table.
Notes
Available on all plans. Schema metadata is cached with the manifest (5-min TTL) — zero R2 reads.
Plan Access
sample
✓ Availablesp500
✓ Availablefull
✓ Available