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")
Try it now
No token required
Paste this in your terminal — the sample tier returns real S&P500 data without authentication.
# No auth required — sample tier covers S&P500 with a 5-year window.
# Add an Authorization: Bearer header for full universe and history.
$ curl -X POST https://mcp.valuein.biz/mcp \
-H "Content-Type: application/json" \
-d '{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "describe_schema",
"arguments": {}
}
}'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