Ffiec Call Reports MCP server

FFIEC Call Reports — US bank line-item detail

Every US bank's quarterly balance sheet, income statement, regulatory capital, loan, deposit and credit-quality detail, as filed on the FFIEC Call Report (Consolidated Reports of Condition and Income, forms 031/041/051) — 4,336 filers, line-item level.

Part of Pipeworx — an MCP gateway connecting AI agents to 1576+ live data sources.

Why this is not part of fdic, and not the same thing

Three packs touch US banks and they do different jobs:

The split is an id-space decision, not a preference. A bank carries an FDIC certificate number and a Federal Reserve IDRSSD, and they are different numbers for the same institution — JPMorgan Chase Bank is cert 628 and rssd 852218. The CDR keys on IDRSSD; fdic keys on cert. Interleaving them in one pack is how a caller passes the id one tool returned into another and silently gets a different bank.

So: both identifiers are accepted here, both are returned, and every response states which one it resolved on.

Tools

Auth

Keyless.

Units — the trap that breaks bank-vs-credit-union comparison

Call reports are filed in thousands of dollars. NCUA files in whole dollars. Comparing the two on raw numbers is wrong by 1000×, in the credit union's favour.

Every amount here is normalised to whole USD, with the as-filed figure kept alongside:

{ "mdrm": "RCFD2170", "label": "TOTAL ASSETS",
  "value_usd": 4016571000000, "as_filed": 4016571000,
  "unit": "USD (normalised from the thousands banks file in)" }

Capital ratios arrive as percentages with a literal % and are passed through as unit: "percent" — never multiplied.

What is mirrored

The seven core schedules — RC (balance sheet), RI (income statement), RC-R I (regulatory capital), RC-N (past due and nonaccrual), RC-C I (loans by category), RC-E (deposits), RC-K (quarterly averages). Measured: 1.49M values per quarter of the 5.23M across all 46 schedules.

The full 3,843-code MDRM dictionary loads regardless, so any code is explainable even where no value is held — ffieccoverage({code}) returns mirroredvalues: false for those.

Non-numeric cells (17,100 a quarter) go to their own table rather than being dropped. CONF matters: it means the bank filed and withheld the value as confidential, which is a different answer from "not reported".

Data source

• — FFIEC Central Data Repository bulk download.

Things the next person would otherwise rediscover

Shortened. The full README is on GitHub.