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

NameTypeRequiredDescription
ndcstringno11-digit NDC without dashes (00002120001) or dashed form (00002-1200-01).
namestringnoPart of the FDA product name, e.g. “OZEMPIC”. Case-insensitive.
labelerstringnoPart of the labeler (manufacturer) name, e.g. “NOVO NORDISK”.
active_onlybooleannoDrop products that carry a termination date. Default false.
limitnumbernoRows to return (1-100, default 25).
offsetnumbernoRows 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

FieldTypeDescription
periodstring
totalnumber
returnednumber
productsarray
sourcestring
data_as_ofstring
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.

Regenerated from source · build November 16, 2026