@pipeworx/az-medicaid-rates

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

Connect to just the @pipeworx/az-medicaid-rates pack

https://gateway.pipeworx.io/az-medicaid-rates/mcp — only @pipeworx/az-medicaid-rates’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: 2

Arizona Medicaid FQHC (federally qualified health center) and rural health clinic (RHC) per-visit rates, by clinic or health centre, one table per federal fiscal year (FY2022 to FY2027): the PPS rate in dollars, the program, the methodology (APM or BIPA, from FY2025) and the effective period. From the Arizona Health Care Cost Containment System (AHCCCS), fee-for-service rate tables.

Built on a Bruce ask (“more states”, 2026-11-16) under the supply-creates-demand ruling; there is no measured demand for this state yet.

Tools

  • az_clinic_rates(provider?, program?, period?, methodology?, out_of_state?, limit?) — rates by clinic name fragment. Defaults to the newest fiscal year (FY2027: 2026-10-01 to 2027-09-30); period: "all" returns every year with the change from the prior year and any footnote. An unmatched filter returns the nearest provider names or the valid values, never a bare empty.
  • az_rate_summary(program?, period?, group_by?) — what each fiscal-year table is (effective period, version date, clinic counts), min/median/max/mean rate, optionally grouped by fiscal year, program or methodology.

Auth

Keyless.

Data sources

  • Arizona Health Care Cost Containment System (AHCCCS), fee-for-service FQHC and RHC rate tables — one table per federal fiscal year, October 1 to September 30. Public, no account.

Things worth knowing:

  • The grain is the clinic or health centre, not the site and not the procedure code. AHCCCS lists one rate per billing organisation (“El Rio Health Center”, “Banner Health Page”). The tables carry no NPI, address or city, so there are no such filters. AHCCCS fee schedules by procedure code are a different publication and are not in this pack.
  • Rates are PPS per-visit encounter rates. From FY2025 each rate is marked APM (alternative payment methodology) or BIPA; FY2022 to FY2024 carry no methodology (methodology: null).
  • Footnotes mark mid-year splits. Some older tables give two rates for one year with dates (for example Marana in FY2024: $271.41 to 2024-03-30, $284.26 from 2024-04-01). The published figure is the row’s per_visit_rate; the dated split is in footnote.
  • Out-of-state clinics are listed. AHCCCS includes a few clinics in Utah, California, New Mexico and other states that treat Arizona Medicaid members; out_of_state_state carries the state, taken from the name.
  • prior_year_rate pairs an exact name match in the previous fiscal year; it is null when a name changed (“North Country Community Health Center” became “North Country HealthCare Inc.”) or the clinic is new. Names are as printed each year and are not merged.
  • Tables are revised during the year (FY2027 carries “Revised 10/5/26 to add new providers”); table_version on each row quotes the publisher’s own version line.
  • Organisations only. Any row whose name reads as a person is left out when the table is stored and counted in individual_rows_dropped (0 today: the tables list health centres and clinics). The rule is in src/individuals.ts.
  • Fee-for-service rates only: managed-care plans may pay under their own contracts.
  • Every response carries data_as_of (the newest table’s version date), captured_at and the source.

Stored data and refresh

AHCCCS publishes these as small yearly workbooks with no query interface, so every listed year is read by scripts/bake-index.mjs into src/az-rates-data.ts (295 rows, about 47 KB), registered in workers/gateway/src/pack-baked-indexes.json; the deploy uploads it to KV and the gateway injects it on the first call into this pack, so nothing is evaluated at module scope. Refresh with node mcps/az-medicaid-rates/scripts/bake-index.mjs: it discovers the workbooks from the program page, reads each with the in-repo reader, and rewrites the module in place. It refuses a changed title, header or effective-date row, a file whose name and effective date disagree on the fiscal year, a non-positive rate, an unexpected row, a table under its row floor, a repeated provider, or a total more than 10% under the module on disk. AHCCCS posts a new workbook each October; data_as_of says which version is held.

Tools

  • az_clinic_rates — Arizona MEDICAID (AHCCCS, not Medicare) FQHC (federally qualified health center) and rural health clinic (RHC) per-visit PPS rates, PER CLINIC OR HEALTH CENTRE (the billing organisation, not each site
  • az_rate_summary — Arizona Medicaid FQHC and RHC per-visit rate tables at a glance (Arizona Health Care Cost Containment System): what each fiscal-year table is (effective period, version date, clinic counts), min/media

Tools

  • az_clinic_rates — Arizona MEDICAID (AHCCCS, not Medicare) FQHC (federally qualified health center) and rural health clinic (RHC) per-visit PPS rates, PER CLINIC OR HEALTH CENTRE (the billing organisation, not each site
  • az_rate_summary — Arizona Medicaid FQHC and RHC per-visit rate tables at a glance (Arizona Health Care Cost Containment System): what each fiscal-year table is (effective period, version date, clinic counts), min/media

Regenerated from source · build November 16, 2026