ValueinValuein
Discovery

Describe Data Schema

describe_schema
Free
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

ParameterTypeRequiredDescription
tablestringoptionalFilter to a single table name (e.g. 'fact', 'entity', 'references'). Omit to return the full schema for all tables.

Output Fields

tablescolumnstypesprimary_keysforeign_keysdescription

Example 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.