mdrp_product_lookup
Pack: medicaid-drug-rebate · 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/mdrp_product_lookup for the schema, then POST the same URL with its arguments for the data.
Look up a drug product in the Medicaid Drug Rebate Program covered-product file (CMS, “Drug Products in the Medicaid Drug Rebate Program”) by 11-digit NDC, product name, or labeler name. Returns the latest quarterly listing: labeler, FDA product name, drug category (single source / innovator / non-innovator), market and FDA approval dates, termination date, unit type, therapeutic-equivalence code, clotting-factor and pediatric flags. An NDC with no current listing returns the last period it appeared in. NDCs are strings.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
ndc | string | no | 11-digit NDC without dashes (00002120001) or dashed form (00002-1200-01). |
name | string | no | Part of the FDA product name, e.g. “OZEMPIC”. Case-insensitive. |
labeler | string | no | Part of the labeler (manufacturer) name, e.g. “NOVO NORDISK”. |
active_only | boolean | no | Drop products that carry a termination date. Default false. |
limit | number | no | Rows to return (1-100, default 25). |
offset | number | no | Rows to skip, for paging. |
Example call
Arguments
{
"name": "OZEMPIC",
"limit": 3
}
curl
curl -X POST https://gateway.pipeworx.io/medicaid-drug-rebate/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"mdrp_product_lookup","arguments":{"name":"OZEMPIC","limit":3}}}'
TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('mdrp_product_lookup', {
"name": "OZEMPIC",
"limit": 3
});
Response shape
| Field | Type | Description |
|---|---|---|
period | string | |
total | number | |
returned | number | |
products | array | |
source | string | |
data_as_of | string |
Full JSON Schema
{
"type": "object",
"properties": {
"period": {
"type": "string"
},
"total": {
"type": "number"
},
"returned": {
"type": "number"
},
"products": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ndc": {
"type": "string"
},
"labeler_name": {
"type": "string"
},
"labeler_code": {
"type": "string"
},
"fda_product_name": {
"type": "string"
},
"drug_category": {
"type": "string"
},
"drug_category_label": {
"type": "string"
},
"termination_date": {
"type": "null"
},
"reactivation_date": {
"type": "null"
},
"market_date": {
"type": "string"
},
"fda_approval_date": {
"type": "string"
},
"unit_type": {
"type": "string"
},
"units_per_pkg_size": {
"type": "string"
},
"therapeutic_equivalence_code": {
"type": "string"
},
"clotting_factor": {
"type": "boolean"
},
"pediatric": {
"type": "boolean"
},
"line_extension": {
"type": "boolean"
},
"fda_application_number": {
"type": "string"
},
"period": {
"type": "string"
}
},
"additionalProperties": true
}
},
"source": {
"type": "string"
},
"data_as_of": {
"type": "string"
}
},
"additionalProperties": true
}
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 medicaid-drug-rebate pack
{
"mcpServers": {
"medicaid-drug-rebate": {
"url": "https://gateway.pipeworx.io/medicaid-drug-rebate/mcp"
}
}
}
See Getting Started for client-specific install steps.