Data MCP

Read a loan's balance for a stated reporting date, keeping scheduled and actual balance fields separate.

What balance does this loan record report, for which date and field?

Agents and analysts querying public records within an agreed data scope.

Interface: MCP server
Access: Request access
Availability: Access by arrangement
Runs on: Hosted service

API key required

Request Data MCP access

Cairn roles: AI connectors, Public records library
Evidence roles: Source
Semantic context: Source meaning
Contribution: Query available public datasets within the configured service scope.
Limit: A query result depends on source definitions, filters and dates; it is not an independently verified claim.

Query a balance

What it does

List available tables and inspect column names, meanings and query guidance.
Sample records or run a guarded read-only SELECT within the configured limits.
Return bounded results with completeness and truncation information.

Live data query, November 3, 2026

Read the latest observation for WFCM 2020-C58, CIK 1827054, asset 25, keeping scheduled and actual balance separate.

The one-row result reported an as-of date of October 13, 2026, and filing date of October 27. Scheduled balance was $9,268,821.88; actual balance was $9,399,496.50. They are different fields, not interchangeable answers.

SELECT CIK, ASSETNUMBER, REPORTINGPERIODENDDATE, FILING_DATE, FILING_ID, REPORTPERIODENDSCHEDULEDLOANBALANCEAMOUNT, REPORTPERIODENDACTUALBALANCEAMOUNT FROM EDGAR_DB.PROPERTY_MART.LOAN_PERIOD_FACT WHERE CIK = '1827054' AND ASSETNUMBER = '25' ORDER BY REPORTINGPERIODENDDATE DESC, FILING_DATE DESC LIMIT 1

Executed through edgar_data.run_query after listing and describing the table. The response was complete for this LIMIT 1 query; it is not a complete loan history or an independent claim verification.

Setup

Tell us the datasets, question and MCP client you need. We will confirm scope, limits and the connection configuration before issuing credentials. Start by listing and describing tables; do not guess column names.

Request Data MCP access

Coverage and freshness

Available datasets, warehouse role, tool namespace and row limits depend on provisioning. Source reporting dates, filing dates and load dates are distinct; inspect the fields relevant to your question.

Limits

Count at the right grain. A table may hold many observations for one loan or property.
Read completeness and truncation fields before treating a result as a total.
A successful SQL query establishes execution, not that the query answers the question correctly.

Related tools and guides

Contact support