Sba Loans MCP server

@pipeworx/sba-loans

U.S. Small Business Administration 7(a) and 504 loan data — "did this business get an SBA loan, from whom, how much, and did it pay it off" — kept current from SBA's own quarterly FOIA CSV extracts.

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

Phase 1 (this pack, shipped): 7(a) + 504. PPP is a separate phase 2 — not built yet, ~5GB, tracked on fleet #1921 as remaining work.

Tools

loan(s): amount, lender, approval date, status, charge-off detail.

• sbaloanlookup(borrower_name, state?, program?, limit?) — a borrower's

largest loans by any combination of filters.

• sbalargestloans(program?, naicscode?, state?, lendername?, limit?) —

ranked by loan count and dollar volume.

• sbalenderleaguetable(program?, state?, naicscode?, limit?) — lenders

— charge-off rate/amount grouped by naics | state | lender | program.

• sbachargeoffaggregate(groupby, program?, state?, naics_code?, limit?)

Auth

Keyless. The gateway supplies data-store credentials to this pack automatically (see the pack's entry in workers/gateway/src/index.ts), same pattern as zillow and usaspending. No caller-facing key.

PERSONAL-DATA RULE (mandatory, harris-county precedent)

Many 7(a)/504 (and, when built, PPP) borrowers are sole proprietors — individual humans, not companies. Street addresses (borrower AND lender-side: BorrStreet, BankStreet, CDCStreet, ThirdPartyLenderStreet) are dropped at ingest — scripts/sba-loans-transform.py never reads those source columns into the row it emits, so they cannot reach a stored row or a response no matter what the source CSV contains. Kept: business/borrower name, city, state, ZIP, NAICS, lender identity, amounts, dates, status. This is the same rule applied to Harris County civil dockets (supabase/migrations/dockets005harrisdroppii.sql): the standing public-data sourcing rule covers bulk public loan records, not bulk redistribution of individuals' home addresses.

Data sources

the CKAN root /dataset/7-a-504-foia (with the hyphen) 404s; the real slug has no hyphen between "7" and "a".

• https://data.sba.gov/dataset/7a-504-foia — dataset page. Portal trap:

https://data.sba.gov/sites/default/files/uploadedresources/FOIA7aFY2020Presentasof.csv, ...FY2010FY2019..., and FOIA504FY2010Presentasof.csv. Two more decades exist (7(a) FY1991-1999, FY2000-2009; 504 FY1991-2009, ~520MB more) — not ingested in phase 1 to keep the first load disciplined; easy to add later via the same transform script if demand shows up.

• Direct CSV downloads (quarterly asof_YYMMDD stamp in the filename):

• No developer API — this is a bulk-CSV-only source.

Ingest harness

Shortened. The full README is on GitHub.