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

Charge-off rate and dollar amount, aggregated by NAICS code, state, lender, or program. Answers “which industries have the highest SBA loan charge-off rate” or “charge-off amount by state”. charge_off_rate is charged-off loan COUNT divided by total loan count in that group (not dollar-weighted).

Parameters

Name	Type	Required	Description
`group_by`	string	no	One of: naics \| state \| lender \| program (default naics).
`program`	string	no	Optional: “7A” or “504” to scope before grouping.
`state`	string	no	Optional 2-letter borrower state code to scope before grouping.
`naics_code`	string	no	Optional 6-digit NAICS code to scope before grouping.
`limit`	number	no	Max groups to return (1-100, default 25).

Example call

Arguments

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

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('sba_charge_off_aggregate', {
  "group_by": "naics",
  "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.

sba_charge_off_aggregate