Discovery
Describe Data Schema
describe_schemaFree
Pro · Institutional
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
example_call.pypython
# 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 free tier returns real S&P500 data without authentication.
try-it.shbash
# 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
Illustrative
response.jsonjson
{ "tables": null, "columns": null, "types": null, "primary_keys": null, "foreign_keys": null, "description": null}Shape only — field names match the live schema; values are placeholders, not real filings. 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
Free (guest)
AvailableFree (token)
AvailablePro · Institutional
Available