@pipeworx/mn-drug-price-transparency

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

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: 2

Minnesota manufacturer drug price-growth and new-drug-launch disclosures — the Minnesota half of the fleet #3245 state WAC-transparency survey. See mcps/ca-drug-price-transparency/README.md for the full per-state survey.

Tools

• mn_rx_price_growth(drug?, manufacturer?, ndc?, limit?) — manufacturer disclosures of a reported WAC (list price) increase, filed under Minnesota’s Prescription Drug Price Transparency program.
• mn_rx_new_drug_launches(drug?, manufacturer?, limit?) — manufacturer disclosures of a new drug launched above Minnesota’s reporting threshold.

Both answer from a periodically-refreshed table (not a live query — Minnesota publishes no API) and every response carries data_as_of.

Auth

Keyless.

Data sources

• Minnesota Department of Health (MDH), Prescription Drug Price Transparency program (Minn. Stat. 62J.84) — two periodic snapshot files: drugs with a reported WAC price increase, and new drugs launched above the reporting threshold. Not a per-year archive like California’s CTRx program (see mcps/ca-drug-price-transparency), and no query API — refreshed by scripts/ingest-mn-rx-transparency.mjs.

Traps

MDH’s export uses the literal text "NULL" as its missing-value sentinel (confirmed 2026-10-18 on Patent Expiration Date etc, each paired with a same-row ... Not Applicable Indicator = 1) — a real ingest trap, since "NULL" is a non-empty, truthy string in JS and would otherwise be stored as the four literal characters rather than null. The parser checks for it explicitly.

Some narrative free-text fields (e.g. Price Increase Factors) already carry mojibake in MDH’s own source file — mis-decoded punctuation like doesn’t for “doesn’t”. This is MDH’s export, not something this ingest introduces; it is preserved as-is rather than guessed at, because a wrong re-encoding guess is worse than a visibly broken apostrophe.

No stable natural key. The same NDC recurs across multiple price-growth reports over time with no report id, so both tables use a surrogate bigserial key and a full-snapshot replace rather than an upsert.

A same-day rerun used to duplicate every row (found 2026-10-19, promoting this pack out of mcps/_incubator/): the delete-stale step ran AFTER insert and only removed rows STRICTLY OLDER than the current data_as_of, so dispatching the refresh workflow twice before MDH republishes inserted a second full copy and deleted nothing. Fixed by deleting everything at or before the current data_as_of BEFORE inserting — see scripts/ingest-mn-rx-transparency.mjs’s header.

MDH’s CDN 403s a bare curl/fetch with no identifying User-Agent — the exact same URL with one set returns 200. Not an auth wall; checked in scripts/ingest-mn-rx-transparency.mjs’s UA constant.

Refresh

.github/workflows/mn-rx-transparency-refresh.yml runs monthly and on workflow_dispatch: ingest, then install the pack’s workspace deps, then smoke the pack against the freshly loaded table with real credentials (GitHub Actions secrets only — no agent machine holds the Supabase service key).

Tools

• mn_rx_price_growth — Minnesota manufacturer disclosures of a prescription drug’s Wholesale Acquisition Cost (WAC — published list price) increasing — filed under Minnesota’s Prescription Drug Price Transparency program (M
• mn_rx_new_drug_launches — Minnesota manufacturer disclosures of a NEW prescription drug launched above Minnesota’s reporting threshold — filed under the same Prescription Drug Price Transparency program (Minn. Stat. 62J.84) as