@pipeworx/medicaid-drug-rebate

Connect: https://pipeworx.io/mcp — every tool in the catalog, including @pipeworx/medicaid-drug-rebate’s. Install: one-click buttons

Connect to just the @pipeworx/medicaid-drug-rebate pack

https://gateway.pipeworx.io/medicaid-drug-rebate/mcp — only @pipeworx/medicaid-drug-rebate’s own tools, nothing else in the catalog.

No MCP client? Skip the connection: POST https://gateway.pipeworx.io/v1/tools/search_packs {"query":"..."} to find a tool below, GET /v1/tools/<name> for its schema, POST the same URL with arguments for the data — see For AI agents.

Tools: 6

Medicaid Drug Rebate Program reference data from CMS: which drug products participate, which were newly reported this week, ACA Federal Upper Limits, whether manufacturers reported their Average Manufacturer Price, and the clotting-factor, exclusive-pediatric and first-time NADAC lists.

Tools

  • mdrp_product_lookup(ndc?, name?, labeler?, active_only?, limit?, offset?) — a product’s current Medicaid Drug Rebate Program listing: labeler, FDA product name, drug category, approval and market dates, termination date, unit type, clotting-factor and pediatric flags. An NDC with no current listing returns the period it last appeared in; an unmatched name returns near matches.
  • mdrp_newly_reported_drugs(week_start?, from?, to?, labeler?, name?, ndc?, limit?) — products manufacturers newly reported to CMS, weekly. Defaults to the latest week; a date with no release returns the weeks that exist.
  • aca_federal_upper_limit(ingredient?, ndc?, strength?, year?, month?, limit?) — the ACA Federal Upper Limit per unit and the weighted average AMP it derives from, for multiple-source generics. Latest monthly file by default.
  • amp_reporting_status(ndc?, labeler?, frequency?, limit?) — whether the required AMP was reported (R) or not (NR). By NDC: the last 12 periods. By labeler: reported and not-reported counts for the latest period plus the not-reported products.
  • mdrp_drug_designations(list, name?, labeler?, ndc?, limit?) — the CMS clotting-factor and exclusive-pediatric product lists.
  • first_time_nadac_rates(name?, since?, limit?) — products that just received their first NADAC rate. For ongoing NADAC prices use nadac_price and nadac_history in the drug-prices pack; for state utilization use medicaid-intelligence.

NDCs are always strings. Pass 11 digits (00002120001) or the dashed form (00002-1200-01); every tool normalises to what its dataset uses.

Auth

Keyless.

Data sources

  • CMS, Medicaid open data catalog: Drug Products in the Medicaid Drug Rebate Program; Product Data for Newly Reported Drugs in the Medicaid Drug Rebate Program; ACA Federal Upper Limits; Drug AMP Reporting (monthly and quarterly); Clotting Factor Drug Report; Exclusive Pediatric Drugs; First Time NADAC Rates. US federal government data, public domain or government-works licence.

Every response names the dataset in source and carries data_as_of, the publisher’s own last-modified timestamp for that dataset.

Served live, one filtered request per call; nothing is copied or stored. The upstream scans millions of rows without indexes, so a cold call can take several seconds (the latest-period lookup is the slow part and is remembered for an hour within a running instance).

Traps the next person would otherwise rediscover:

  • Period columns are text, so a descending sort puts month “9” above “10”. The latest period is found by asking for months 10-12 and 1-9 separately.
  • The weekly newly-reported releases each have their own dataset id; they are resolved by title, never hardcoded, and CMS skips some weeks.
  • The quarterly AMP file pads labeler names with spaces; they are trimmed.
  • The monthly AMP file lacks some products the quarterly one has; amp_reporting_status falls back to quarterly when frequency is not given.

Tools

  • mdrp_product_lookup — 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 l
  • mdrp_newly_reported_drugs — Products newly reported to the Medicaid Drug Rebate Program by manufacturers, from CMS’s weekly “Product Data for Newly Reported Drugs” releases. With no dates it returns the most recent week; give we
  • aca_federal_upper_limit — ACA Federal Upper Limit (FUL) for multiple-source generic drugs from CMS, “ACA Federal Upper Limits”: the FUL per unit, the weighted average of AMPs it derives from, product group, strength, dosage fo
  • amp_reporting_status — Whether a manufacturer reported the required Average Manufacturer Price (AMP) for a drug under the Medicaid Drug Rebate Program, from CMS “Drug AMP Reporting” (monthly and quarterly files). By NDC: th
  • mdrp_drug_designations — Products CMS designates as clotting factor (minimum rebate 17.1% of AMP) or exclusive pediatric under the Medicaid Drug Rebate Program, from the CMS “Clotting Factor Drug Report” and “Exclusive Pediat
  • first_time_nadac_rates — Drug products that received their FIRST National Average Drug Acquisition Cost (NADAC) rate, from CMS “First Time NADAC Rates”: product, brief indication, drug class (Legend/OTC), package size, billin

Tools

  • aca_federal_upper_limit — ACA Federal Upper Limit (FUL) for multiple-source generic drugs from CMS, ACA Federal Upper Limits : the FUL per unit, the weighted average of AMPs it derives from, product group, strength, dosage for
  • amp_reporting_status — Whether a manufacturer reported the required Average Manufacturer Price (AMP) for a drug under the Medicaid Drug Rebate Program, from CMS Drug AMP Reporting (monthly and quarterly files). By NDC: the
  • first_time_nadac_rates — Drug products that received their FIRST National Average Drug Acquisition Cost (NADAC) rate, from CMS First Time NADAC Rates : product, brief indication, drug class (Legend/OTC), package size, billing
  • mdrp_drug_designations — Products CMS designates as clotting factor (minimum rebate 17.1% of AMP) or exclusive pediatric under the Medicaid Drug Rebate Program, from the CMS Clotting Factor Drug Report and Exclusive Pediatric
  • mdrp_newly_reported_drugs — Products newly reported to the Medicaid Drug Rebate Program by manufacturers, from CMS's weekly Product Data for Newly Reported Drugs releases. With no dates it returns the most recent week; give week
  • mdrp_product_lookup — 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 la

Regenerated from source · build November 16, 2026