@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 usenadac_priceandnadac_historyin 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_statusfalls 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 foramp_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: thefirst_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, billingmdrp_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 Pediatricmdrp_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 weekmdrp_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