@pipeworx/ca-medicaid-rates
Connect: https://pipeworx.io/mcp — every tool in the catalog, including @pipeworx/ca-medicaid-rates’s. Install: one-click buttons
Connect to just the @pipeworx/ca-medicaid-rates pack
https://gateway.pipeworx.io/ca-medicaid-rates/mcp — only @pipeworx/ca-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
California Medi-Cal (Medicaid) per-visit payment rates for federally qualified health centers (FQHC) and rural health clinics (RHC), one record per clinic location: the medical visit rate and the dental visit rate, each with the date it began, from the California Department of Health Care Services.
Tools
ca_medicaid_clinic_rates(name?, provider_number?, county?, city?, zip?, program?, service?, limit?)— per-clinic rates. Filter by clinic name fragment, 10-digit provider number, county, city or zip; narrow to FQHC or RHC and to the medical or dental rate. Returns each location’s rates and begin dates, address, summary statistics (min, median, max, mean) over every location matched, anddata_as_of. An unmatched filter returns the nearest clinic names or the list of valid counties instead of an empty result.ca_medicaid_rates_edition()— the edition served (month and publication date), location and provider-number counts, per-program and per-county counts with median rates, the range of rate begin dates, and what is not covered.
Auth
Keyless.
Data sources
- California Department of Health Care Services (DHCS), FQHC and RHC Current Rates, current monthly edition — public, no account. Data as of the publication date printed on the workbook (2026-02-24 for the February 2026 edition).
Things worth knowing:
- Rates are per clinic location and service, not statewide per code. Each location has its own rate. A location can carry a medical visit rate (revenue code 0521) and a dental visit rate (revenue code 0003), each with its own begin date. One published dental line carries procedure code T1015 beside revenue code 0003; the service is read from the revenue code and the procedure code is returned as published.
- One current edition. Only the newest monthly edition is served.
rate_beginis each rate’s own begin date (from 2003 to 2026-02 in the February 2026 edition), so it can be years beforedata_as_of. - A published rate of 0 is returned as 0, flagged
published_zero, and left out of the summary statistics (12 such rates in the February 2026 edition). The workbook does not say why. special_processing_codeandrevenue_type_code(FQ and RH read as FQHC and RHC; AD appears on two locations and is returned as a code) are the Department’s own codes, passed through; the workbook does not define them.- A few locations are outside California (four rows for two Iowa rural health clinics, county “UNKNOWN”) and keep their own state.
- Legal names are abbreviated and cut off as published. Provider number, owner number, service location number and zip are strings.
- Organisations only: a clinic enrolled under a physician’s own name (for example ”
MD INC”) or a bare personal name is dropped when the data is read and counted in individual_rows_dropped(63 source rows in the February 2026 edition). - Medi-Cal fee-for-service prospective payment rates; managed-care plans may pay differently. Built to a request to cover more of Medicaid, not from measured demand for California.
Stored data and refresh
The sheet is 4,244 rows, 2,332 locations after individuals are dropped (about 1.3 MB). The Department’s site answers every automated client with a bot challenge, so nothing here fetches it. A person downloads the workbook in a browser and drops it in the inbox directory; scripts/bake-index.mjs reads that local file into src/ca-rates-data.ts, registered in workers/gateway/src/pack-baked-indexes.json; the deploy uploads the table to KV and the gateway injects it on the first call into this pack, so nothing is evaluated at module scope. The refresh runner is human in scripts/baked-index-freshness.json.
node mcps/ca-medicaid-rates/scripts/bake-index.mjs [workbook.xlsx] [--force] takes the newest FQHC-and-RHC-Current-Rates-<Month>-<Year>.xlsx in the inbox when no path is given, does nothing when that month is already baked, and refuses a changed title, a file-name month that disagrees with the sheet, a changed header, an unknown code, a non-numeric rate, a sheet under its row floor, an older edition than the one baked, or a legal name with no organisation word and no credential that nobody has judged (it lists the names to add to the reviewed lists in the script).
The publisher’s edition cannot be checked automatically (the same challenge), so the source-edition check registers this pack as not checked, with the reason.
Tools
- ca_medicaid_clinic_rates — California MEDI-CAL (Medicaid, not Medicare) per-visit payment rates for federally qualified health centers (FQHC) and rural health clinics (RHC), PER CLINIC LOCATION, with the date each rate began, f
- ca_medicaid_rates_edition — Which California Medi-Cal FQHC and RHC rates edition is served (month, publication date from the California Department of Health Care Services), how many clinic locations and provider numbers, per-pro
Tools
ca_medicaid_clinic_rates— California MEDI-CAL (Medicaid, not Medicare) per-visit payment rates for federally qualified health centers (FQHC) and rural health clinics (RHC), PER CLINIC LOCATION, with the date each rate began, fca_medicaid_rates_edition— Which California Medi-Cal FQHC and RHC rates edition is served (month, publication date from the California Department of Health Care Services), how many clinic locations and provider numbers, per-pro