@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 infootnote. - 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_statecarries the state, taken from the name. prior_year_ratepairs 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_versionon 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 insrc/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_atand 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 siteaz_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