`ppp_aggregate`

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_aggregate for the schema, then POST the same URL with its arguments for the data.

Paycheck Protection Program (PPP) totals grouped by NAICS industry code, borrower state, or servicing lender: loan count, total approved, loans and dollars forgiven, forgiveness rate, and total jobs reported. Optionally scoped to one borrower state. Answers “which industries got the most PPP money in Texas” or “which lenders serviced the most PPP dollars”. Business borrowers only (sole proprietors and individuals excluded). Source: SBA PPP FOIA data, as of 2024-09-30.

Parameters

Name	Type	Required	Description
`group_by`	string	no	naics \| state \| lender (default naics).
`state`	string	no	Optional 2-letter borrower state code to scope before grouping.
`order_by`	string	no	Rank by total approved amount (default), loan count, or jobs reported.
`limit`	number	no	Max groups to return (1-100, default 25).

Example call

Arguments

{
  "group_by": "naics",
  "order_by": "jobs",
  "limit": 10
}

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_aggregate","arguments":{"group_by":"naics","order_by":"jobs","limit":10}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('ppp_aggregate', {
  "group_by": "naics",
  "order_by": "jobs",
  "limit": 10
});

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_aggregate