Valuein — SEC EDGAR Fundamentals & Smart-Money Data

Describe Data Schema

describe_schema

Read-onlyIdempotent

Returns the Parquet schema for all tables in the Valuein SEC data warehouse. Includes table descriptions, column names, types, primary keys, and foreign-key references. Use this tool to understand the data model before querying with other tools. No data reads required — schema is embedded in the manifest. Available on all plans.

Input Schema

TableJSON Schema

Name	Required	Description	Default
`table`	No	Filter to a single table name (e.g. 'fact', 'entity', 'references'). Omit to return the full schema for all tables.

Output Schema

TableJSON Schema

Name	Required	Description
`_meta`	Yes	Provenance envelope — data lineage for every MCP response
`table`	No	Single-table mode: the requested table name
`tables`	No	Full-schema mode: map of table name → { description, column_count, columns }
`columns`	No	Single-table mode: map of column name → definition
`project`	No	Full-schema mode: source project name
`description`	No	Single-table mode: the table's description
`schema_version`	Yes	Parquet schema version from the active R2 manifest

Schema Changelog

Changes observed during successful MCP inspections.

Changed1 schema field changedSep 18, 2026

changedOutput schema / properties / _meta / properties / fundamentals_as_of / description

Previous value: -"ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt. Use THIS — not `last_updated` — when telling a user how current the fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to."New value: +"ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt in bulk. Use THIS — not `last_updated` — when telling a user how current the cross-sectional fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to. It is a floor for a single filer, not a ceiling: a filer with a live partition receives its filing, facts and ratios intraday (minutes after EDGAR dissemination), so an entity-scoped read may carry a filing newer than this; cross-sectional ranks (factor scores, earnings signals) refresh with the weekly bulk export."

Changed2 schema fields changedJul 25, 2026

addedOutput schema / properties / _meta / properties / fundamentals_as_of

Added value: +{
+  "description": "ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt. Use THIS — not `last_updated` — when telling a user how current the fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to.",
+  "type": "string"
+}

addedOutput schema / properties / _meta / properties / price_as_of

Added value: +{
+  "description": "ISO timestamp when the price surfaces were last refreshed.",
+  "type": "string"
+}

Changed2 schema fields changedJul 7, 2026

addedOutput schema / properties / _meta / properties / cost_usd

Added value: +{
+  "additionalProperties": false,
+  "description": "Per-call cost transparency. Omitted for subscription-only tools that have no PAYG-equivalent price.",
+  "properties": {
+    "amount_usd": {
+      "minimum": 0,
+      "type": "number"
+    },
+    "basis": {
+      "description": "payg_charge = real agent-pay charge. payg_rate_card = indicative price, not billed.",
+      "enum": [
+        "payg_charge",
+        "payg_rate_card"
+      ],
+      "type": "string"
+    },
+    "billed": {
+      "description": "true = this amount was actually charged via PAYG for this call. false = indicative PAYG-equivalent value; your plan already covers this call for free.",
+      "type": "boolean"
+    }
+  },
+  "required": [
+    "amount_usd",
+    "billed",
+    "basis"
+  ],
+  "type": "object"
+}

addedOutput schema / properties / _meta / properties / latency_ms

Added value: +{
+  "description": "Wall-clock milliseconds this tool call took, measured server-side around the handler.",
+  "minimum": 0,
+  "type": "integer"
+}

Changed1 schema field changedJun 18, 2026
- addedOutput schema / properties / _meta / properties / pit_safe / description
```
Added value: +"true iff a zero-look-ahead point-in-time cut was applied to every returned figure"
```

Changed1 schema field changedJun 3, 2026

changedOutput schema / (root)

Previous value: -nullNew value: +{
+  "$schema": "http://json-schema.org/draft-07/schema#",
+  "additionalProperties": false,
+  "properties": {
+    "_meta": {
+      "additionalProperties": false,
+      "description": "Provenance envelope — data lineage for every MCP response",
+      "properties": {
+        "as_of_date": {
+          "type": [
+            "string",
+            "null"
+          ]
+        },
+        "data_plan": {
+          "description": "Access plan: sample | sp500 | pro | full",
+          "type": "string"
+        },
+        "data_quality": {
+          "additionalProperties": false,
+          "description": "Server-side invariants run on this response",
+          "properties": {
+            "notes": {
+              "items": {
+                "type": "string"
+              },
+              "type": "array"
+            },
+            "validation_failed": {
+              "items": {
+                "additionalProperties": false,
+                "properties": {
+                  "detail": {
+                    "type": "string"
+                  },
+                  "rule": {
+                    "type": "string"
+                  }
+                },
+                "required": [
+                  "rule",
+                  "detail"
+                ],
+                "type": "object"
+              },
+              "type": "array"
+            },
+            "validation_passed": {
+              "items": {
+                "type": "string"
+              },
+              "type": "array"
+            }
+          },
+          "required": [
+            "validation_passed",
+            "validation_failed",
+            "notes"
+          ],
+          "type": "object"
+        },
+        "last_updated": {
+          "description": "ISO timestamp when the snapshot was exported",
+          "type": "string"
+        },
+        "limit_warnings": {
+          "description": "Soft-warning array for partial fulfillment. Each entry carries a stable subcode + remediation.options[]. AI agents pattern-match on subcode.",
+          "items": {
+            "additionalProperties": true,
+            "properties": {
+              "code": {
+                "const": "LIMIT_EXCEEDED",
+                "type": "string"
+              },
+              "current_plan": {
+                "type": "string"
+              },
+              "extensions": {
+                "additionalProperties": {},
+                "type": "object"
+              },
+              "limit_type": {
+                "type": "string"
+              },
+              "limit_value": {},
+              "remediation": {
+                "additionalProperties": true,
+                "properties": {
+                  "contact_sales": {
+                    "type": "string"
+                  },
+                  "default_action": {
+                    "type": "string"
+                  },
+                  "options": {
+                    "items": {
+                      "additionalProperties": {},
+                      "type": "object"
+                    },
+                    "type": "array"
+                  },
+                  "pricing_page": {
+                    "type": "string"
+                  }
+                },
+                "required": [
+                  "options",
+                  "default_action",
+                  "pricing_page",
+                  "contact_sales"
+                ],
+                "type": "object"
+              },
+              "requested_value": {},
+              "returned_value": {},
+              "subcode": {
+                "type": "string"
+              }
+            },
+            "required": [
+              "code",
+              "subcode",
+              "limit_type",
+              "current_plan",
+              "remediation"
+            ],
+            "type": "object"
+          },
+          "type": "array"
+        },
+        "payg_override": {
+          "additionalProperties": false,
+          "description": "Set when this single response was paid for via the agent-pay PAYG flow — the rate-limit / depth-limit checks were bypassed for this call only.",
+          "properties": {
+            "amount_cents": {
+              "type": "number"
+            },
+            "entity_scope_hash": {
+              "type": "string"
+            },
+            "meter": {
+              "type": "string"
+            },
+            "quote_id": {
+              "type": "string"
+            },
+            "retry_token_hash": {
+              "type": "string"
+            },
+            "ticker_count": {
+              "type": "number"
+            },
+            "tool": {
+              "type": "string"
+            }
+          },
+          "required": [
+            "quote_id",
+            "tool",
+            "meter",
+            "amount_cents",
+            "ticker_count",
+            "entity_scope_hash",
+            "retry_token_hash"
+          ],
+          "type": "object"
+        },
+        "pit_safe": {
+          "type": "boolean"
+        },
+        "rate_limit": {
+          "additionalProperties": false,
+          "description": "Caller's remaining budget",
+          "properties": {
+            "limit": {
+              "type": "integer"
+            },
+            "remaining": {
+              "type": "integer"
+            },
+            "reset_at": {
+              "description": "ISO 8601 timestamp when the window resets",
+              "type": "string"
+            },
+            "window": {
+              "enum": [
+                "minute",
+                "hour"
+              ],
+              "type": "string"
+            }
+          },
+          "required": [
+            "limit",
+            "remaining",
+            "reset_at",
+            "window"
+          ],
+          "type": "object"
+        },
+        "request_id": {
+          "description": "Per-request correlation id (8-char)",
+          "type": "string"
+        },
+        "result_count": {
+          "type": "integer"
+        },
+        "schema_version": {
+          "description": "Parquet schema version from manifest.json",
+          "type": "string"
+        },
+        "snapshot": {
+          "description": "Snapshot directory name (e.g. snapshot_20260420)",
+          "type": "string"
+        },
+        "source": {
+          "const": "SEC EDGAR",
+          "type": "string"
+        },
+        "ticker": {
+          "type": "string"
+        },
+        "truncation": {
+          "additionalProperties": false,
+          "description": "Set when fewer rows were returned than requested — explains why and points to a remedy",
+          "properties": {
+            "current_plan": {
+              "type": "string"
+            },
+            "plan_limit": {
+              "minimum": 0,
+              "type": "integer"
+            },
+            "reason": {
+              "enum": [
+                "PLAN_LIMIT",
+                "DATA_NOT_AVAILABLE",
+                "FISCAL_YEAR_BOUNDARY_FILTER",
+                "OTHER"
+              ],
+              "type": "string"
+            },
+            "requested": {
+              "minimum": 0,
+              "type": "integer"
+            },
+            "returned": {
+              "minimum": 0,
+              "type": "integer"
+            },
+            "upgrade_required_for": {
+              "type": "string"
+            },
+            "upgrade_url": {
+              "type": "string"
+            }
+          },
+          "required": [
+            "requested",
+            "returned",
+            "reason"
+          ],
+          "type": "object"
+        }
+      },
+      "required": [
+        "data_plan",
+        "schema_version",
+        "snapshot",
+        "last_updated",
+        "source",
+        "pit_safe"
+      ],
+      "type": "object"
+    },
+    "columns": {
+      "additionalProperties": {},
+      "description": "Single-table mode: map of column name → definition",
+      "type": "object"
+    },
+    "description": {
+      "description": "Single-table mode: the table's description",
+      "type": [
+        "string",
+        "null"
+      ]
+    },
+    "project": {
+      "description": "Full-schema mode: source project name",
+      "type": [
+        "string",
+        "null"
+      ]
+    },
+    "schema_version": {
+      "description": "Parquet schema version from the active R2 manifest",
+      "type": "string"
+    },
+    "table": {
+      "description": "Single-table mode: the requested table name",
+      "type": "string"
+    },
+    "tables": {
+      "additionalProperties": {},
+      "description": "Full-schema mode: map of table name → { description, column_count, columns }",
+      "type": "object"
+    }
+  },
+  "required": [
+    "_meta",
+    "schema_version"
+  ],
+  "type": "object"
+}

First observedApr 22, 2026

TDQS

A4.3/5.0

Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint, idempotentHint, and destructiveHint=false. The description adds meaningful context beyond those: the schema is embedded in the manifest, no data reads are required, and it is available on all plans. This reassures an agent about cost and access without contradicting the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is compact, front-loaded with the core purpose, then adds return contents, usage timing, and efficiency context. Every sentence earns its place with no filler or repetition.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only, single-parameter schema-inspection tool with an output schema and strong annotations, the description is complete. It tells the agent what it returns, why it is cheap, when to use it, and that it works on all plans — nothing needed for correct invocation is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the single optional `table` parameter is already well documented in the schema. The description adds context by framing the parameter as a filter over the full-schema return, but it does not need to repeat parameter syntax. Baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb ('Returns'), names the exact resource ('Parquet schema for all tables in the Valuein SEC data warehouse'), and enumerates what is included: table descriptions, columns, types, primary keys, and foreign keys. This makes the tool's purpose unambiguous and distinguishable from the many get_* and list_* siblings.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly states when to use it: 'Use this tool to understand the data model before querying with other tools.' This provides clear context for invocation, though it does not formally name alternatives or exclusions, so it falls just short of a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

All Valuein — SEC EDGAR Fundamentals & Smart-Money Data tools Inspect

Try in Browser

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Glama MCP Gateway

Add one secure layer between your agents and this server.