Fl Medicaid Rates MCP server

@pipeworx/fl-medicaid-rates

Florida Medicaid reimbursement rates by provider and rate semester: FQHC and rural health clinic per-visit encounter rates, nursing home, skilled nursing unit, swing bed, hospice and hospital rates, with statewide min/median/max and the effective date.

Part of Pipeworx — an MCP gateway connecting AI agents to 1875+ live data sources. This is an independent, unofficial integration — not affiliated with, endorsed by, or published by the upstream provider.

Tools

• flfqhcrates(period?, provider?, limit?) — Florida Medicaid (not Medicare) FQHC per-visit PPS encounter rate for each clinic in a semester, with statewide min/median/max/mean.
• flmedicaidrates(schedule, period?, provider?, limit?) — the same shape for any schedule: fqhc, rhc, pbrhc, snu, swingbed, hospicelevelofcare, hospiceroomboard, nursinghome, hospital.
• flrateperiods(schedule?) — which effective periods are published for each schedule.

Auth

Keyless.

Data sources

• Florida Agency for Health Care Administration (AHCA), Medicaid cost reimbursement rate schedules — the per-semester provider rate tables the agency publishes for each rate type. Public, no account.

Each call reads the agency's current publication list and the one table asked for, so new semesters appear without a code change. Nothing is bundled. Tables are small, and parsed results are held for ten minutes within an isolate.

Things worth knowing:

• The agency states that published rates are those in effect on the first day of the semester and are not updated for later revisions to an individual provider's cost data. Responses repeat this.
• Effective dates come from the publication's naming, which is not uniform across rate types; undated entries are listed as undated.
• FQHC/RHC tables carry one rate column whose header embeds the MEI percentage for the year. Rate columns are detected by being numeric and not an identifier, so a header change flows through rather than breaking.
• The nursing home workbook has more than one sheet; rows carry a Sheet column.
• Provider number is a string in the FQHC/RHC tables (leading zeros) and a number in others; the provider filter matches the digits either way.
• hospital is the state mental health hospital per diem table only (3 hospitals). The agency's own page says community-hospital inpatient is paid by DRG (since July 2013) and outpatient by EAPG (since July 2017) and posts no per diem for them; only the state mental health hospitals still get one. A community hospital is not missing from the data, it is not in this schedule. Responses carry a scope line saying so. snu is the complete hospital-based skilled nursing unit table the agency posts (3 units in October 2026).
• A 0 in a rate cell is the agency's "no rate for this service" (the hospital table shows 0 for outpatient on every state hospital). It is returned as null, listed in nullratecells/nullratenote, and left out of statewide, so no statewide mean is computed over zeros.
• Rates are rounded to the cent (some workbooks store float noise such as 159.18499999999997).
• A partial read is refused, not answered: the reader counts the cells it read against the cells in the sheet, refuses a workbook with a sheet it could not open or a data sheet with no header row, and refuses a latest table with fewer provider rows than a per-schedule floor.
• Rate-letter and calculation-sheet PDFs, and the reimbursement plans, are not parsed.

Freshness and refusals

Shortened. The full README is on GitHub.