Search Annual Financial Summary Data
fdic_search_summarySearch annual financial summaries for FDIC-insured banks to track growth, analyze performance metrics, and compare institutions over time using filters like year, assets, and profitability.
Instructions
Search aggregate financial and structure summary data subtotaled by year for FDIC-insured institutions.
Returns annual snapshots of key financial metrics — useful for tracking an institution's growth over time.
Common filter examples:
Annual history for a bank: CERT:3511
Specific year: YEAR:2022
Year range: YEAR:[2010 TO 2020]
Large banks in 2022: YEAR:2022 AND ASSET:[10000000 TO *]
Profitable in 2023: YEAR:2023 AND ROE:[10 TO *]
Key returned fields:
CERT: FDIC Certificate Number
YEAR: Report year
ASSET: Total assets ($thousands)
DEP: Total deposits ($thousands)
NETINC: Net income ($thousands)
ROA: Return on assets (%)
ROE: Return on equity (%)
OFFICES: Number of branch offices
REPDTE: Report Date — the last day of the reporting period (YYYYMMDD)
Args:
cert (number, optional): Filter by institution CERT number
year (number, optional): Filter by specific year (1934-present)
filters (string, optional): Additional ElasticSearch query filters
fields (string, optional): Comma-separated field names
limit (number): Records to return (default: 20)
offset (number): Pagination offset (default: 0)
sort_by (string, optional): Field to sort by (e.g., YEAR, ASSET)
sort_order ('ASC'|'DESC'): Sort direction (default: 'ASC')
Prefer concise human-readable summaries or tables when answering users. Structured fields are available for totals, pagination, and annual summary records.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filters | No | FDIC API filter using ElasticSearch query string syntax. Combine conditions with AND/OR, use quotes for multi-word values, and [min TO max] for ranges (* = unbounded). Common fields: NAME (institution name), STNAME (state name), STALP (two-letter state code), CERT (certificate number), ASSET (total assets in $thousands), ACTIVE (1=active, 0=inactive). Examples: STNAME:"California", ACTIVE:1 AND ASSET:[1000000 TO *], NAME:"Chase" | |
| fields | No | Comma-separated list of FDIC field names to return. Leave empty to return all fields. Field names are ALL_CAPS (e.g., NAME, CERT, ASSET, DEP, STALP). Example: NAME,CERT,ASSET,DEP,STALP | |
| limit | No | Maximum number of records to return (1-10000, default: 20) | |
| offset | No | Number of records to skip for pagination (default: 0) | |
| sort_by | No | Field name to sort results by. Example: ASSET, NAME, FAILDATE | |
| sort_order | No | Sort direction: ASC (ascending) or DESC (descending) | ASC |
| cert | No | Filter by FDIC Certificate Number | |
| year | No | Filter by specific year (e.g., 2022) |
Implementation Reference
- src/tools/financials.ts:186-210 (handler)The handler function for fdic_search_summary, which queries the FDIC summary endpoint and formats the results.
async ({ cert, year, ...params }) => { try { const response = await queryEndpoint(ENDPOINTS.SUMMARY, { ...params, filters: buildFilterString({ cert, dateField: "YEAR", dateValue: year, rawFilters: params.filters, }), }); const records = extractRecords(response); const pagination = buildPaginationInfo( response.meta.total, params.offset ?? 0, records.length, ); const output = { ...pagination, summary: records }; const text = truncateIfNeeded( formatSearchResultText("annual summary records", records, pagination, [ "CERT", "YEAR", "ASSET", "DEP", "NETINC", - src/tools/financials.ts:141-185 (registration)Registration of the fdic_search_summary tool within the MCP server.
server.registerTool( "fdic_search_summary", { title: "Search Annual Financial Summary Data", description: `Search aggregate financial and structure summary data subtotaled by year for FDIC-insured institutions. Returns annual snapshots of key financial metrics — useful for tracking an institution's growth over time. Common filter examples: - Annual history for a bank: CERT:3511 - Specific year: YEAR:2022 - Year range: YEAR:[2010 TO 2020] - Large banks in 2022: YEAR:2022 AND ASSET:[10000000 TO *] - Profitable in 2023: YEAR:2023 AND ROE:[10 TO *] Key returned fields: - CERT: FDIC Certificate Number - YEAR: Report year - ASSET: Total assets ($thousands) - DEP: Total deposits ($thousands) - NETINC: Net income ($thousands) - ROA: Return on assets (%) - ROE: Return on equity (%) - OFFICES: Number of branch offices - REPDTE: Report Date — the last day of the reporting period (YYYYMMDD) Args: - cert (number, optional): Filter by institution CERT number - year (number, optional): Filter by specific year (1934-present) - filters (string, optional): Additional ElasticSearch query filters - fields (string, optional): Comma-separated field names - limit (number): Records to return (default: 20) - offset (number): Pagination offset (default: 0) - sort_by (string, optional): Field to sort by (e.g., YEAR, ASSET) - sort_order ('ASC'|'DESC'): Sort direction (default: 'ASC') Prefer concise human-readable summaries or tables when answering users. Structured fields are available for totals, pagination, and annual summary records.`, inputSchema: SummaryQuerySchema, annotations: { readOnlyHint: true, destructiveHint: false, idempotentHint: true, openWorldHint: true, }, }, - src/tools/financials.ts:38-50 (schema)Zod schema definition for the fdic_search_summary tool's input arguments.
const SummaryQuerySchema = CommonQuerySchema.extend({ cert: z .number() .int() .positive() .optional() .describe("Filter by FDIC Certificate Number"), year: z .number() .int() .min(1934) .optional() .describe("Filter by specific year (e.g., 2022)"),