INDIVIDUAL MCP TOOL
hospital_prices
From the machine-readable standard-charge files hospitals must publish (45 CFR 180), parsed and normalized: for each hospital within the radius that posts the code, nearest first, the gross charge, the discounted cash price, the de-identified minimum and maximum, and every payer and plan’s negotiated dollar amount or percentage (with the v3.
LIVE ENDPOINT
https://data.spencermcw.com/mcp
Connect to this endpoint to inspect the live schema for hospital_prices and invoke it with your own arguments.
Indexed input schema
{}Risk classification
Potential side effects detected · medium confidence · heuristic, not a guarantee.
- A tool name or description contains a write-action term.
- A tool name or description suggests a financial action.
Parent server
CONNECT WITH APPROVAL
Client installation
Review this server and its permissions before adding it. Secret placeholders must be set locally.
Codex
~/.codex/config.toml
[mcp_servers.distill]
url = "https://data.spencermcw.com/mcp"
enabled = true
Claude Code
.mcp.json
{
"mcpServers": {
"distill": {
"type": "http",
"url": "https://data.spencermcw.com/mcp"
}
}
}
Claude Desktop
Settings → Connectors → Add custom connector
Name: distill
Remote MCP URL: https://data.spencermcw.com/mcp
Add this remote URL as a custom connector in Claude Desktop. Availability depends on the user plan and workspace policy.
Cursor
.cursor/mcp.json
{
"mcpServers": {
"distill": {
"url": "https://data.spencermcw.com/mcp"
}
}
}
Visual Studio Code
.vscode/mcp.json
Add to Visual Studio Code{
"servers": {
"distill": {
"type": "http",
"url": "https://data.spencermcw.com/mcp"
}
}
}
Generic MCP
Client-specific MCP configuration
{
"name": "distill",
"transport": "streamable-http",
"url": "https://data.spencermcw.com/mcp"
}
MCP Inspector
Run the official MCP Inspector locally and enter the indexed Streamable HTTP endpoint.
Related tools
tax_sales_rate— From the state’s own Streamlined Sales Tax rate and boundary files (24 states: AR, GA, IA, IN, KS, KY, MI, MN, NC, ND, NE, NJ, NV, OH, OK, RI, SD, TN, UT, VT, WA, WI, WV, WY).tax_sales_rate_batch— The same answer as tax.tax_changes— Change records read from the states’ rate and boundary files: rates that change, begin or end; ZIP+4 and 5-digit ZIP ranges whose jurisdictions change; new files posted.hospital_compare— For each named hospital: whether it posts the code, and over its items for the code (only those without modifiers when it posts any, so a professional -26 or bilateral -50 line does not skew the row) nearest-rank statistics of its gross charges, discounted cash prices and negotiated dollar amounts across payers and plans, the range of negotiated percentages, the de-identified minimum and maximum, and the number of payers.hospital_payers— Every payer’s negotiated dollar amounts for the code at the hospitals within the radius, grouped by canonical payer_id (the stable id behind the many ways hospitals write a payer’s name), plan type and methodology (a per diem and a case rate are never pooled): how many hospitals and rates, and nearest-rank statistics.hospital_changes— Change records from diffing consecutive weekly builds: a hospital republishing its file (source raw_sha256), items and payer rates that appear, disappear or change price, a hospital’s status or file date changing, and the canonical payer of a payer/plan name changing.