`ppp_loan_lookup`

Pack: sba-loans · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/ppp_loan_lookup for the schema, then POST the same URL with its arguments for the data.

Look up a business’s Paycheck Protection Program (PPP) loan(s) by borrower name. Returns each loan’s approved amount, jobs_reported (the headcount the business stated on its 2020-21 application), NAICS code, servicing and originating lender, approval date, first or second draw, loan status, and forgiveness amount and date. Names match from their first word (“Sumter Coatings” finds “SUMTER COATINGS, INC.”); add zip to also match a word inside the name. Business borrowers only: sole proprietors, self-employed individuals and borrowers named as a person are excluded, and no street address is stored. Source: SBA PPP FOIA data, as of 2024-09-30.

Parameters

Name	Type	Required	Description
`borrower_name`	string	yes	Business name, from its first word, e.g. “Sumter Coatings”. Suffixes like Inc/LLC and punctuation are ignored.
`state`	string	no	Optional 2-letter borrower state code to narrow common names, e.g. “SC”.
`zip`	string	no	Optional 5-digit borrower ZIP. With it, a word inside the name also matches.
`limit`	number	no	Max loans to return (1-100, default 20).

Example call

Arguments

{
  "borrower_name": "Sumter Coatings",
  "state": "SC"
}

curl

curl -X POST https://gateway.pipeworx.io/sba-loans/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ppp_loan_lookup","arguments":{"borrower_name":"Sumter Coatings","state":"SC"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('ppp_loan_lookup', {
  "borrower_name": "Sumter Coatings",
  "state": "SC"
});

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the sba-loans pack

{
  "mcpServers": {
    "sba-loans": {
      "url": "https://gateway.pipeworx.io/sba-loans/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

ppp_loan_lookup