Tools
Admitted surface
Tools
58
With a real answer
56
Walked
2026-11-09REST, customer seat
Doors
2MCP, REST
describe_schema() # the tools YOUR seat can call find_data_sources(query="...") -> describe_data_source(...) -> a typed tool, or query_substrate(sql)
Medicare Advantage, Part D, Medicaid (30)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| get_benefit_change v2.0.0 | The locked 2027 Medicare Advantage benefit tables in one call: what each benefit was in 2026 and what it is in 2027 for the SAME members, member-weighted from t | none | 2026-10-09 | 5.69s |
| get_contract_profile v1.0.0 | Everything Vlada holds on one Medicare Advantage contract, or one of its plans, in ONE call: the contract (name, parent, plan type, plans and counties served), | none | 2026-10-18 | 0.48s |
| get_contract_service_area v0.2.0 | The county-level service area of Medicare Advantage contracts, month by month, from CMS's monthly MA Contract Service Area file (2006-10 on; 2022-11 was never published). | none | 2026-10-06 | 3.44s |
| get_county_view v1.5.0 | The whole Medicare Advantage picture of ONE county, over time, in one call: (1) enrollment by parent and product type each September from 2021, with CMS small-c | none | 2026-10-01 | 11.25s |
| get_enrollment v0.4.0 | Returns CMS monthly enrollment for a Medicare Advantage plan or contract: the member count, the trend over time, and, at contract level, the MA-only vs Part-D split, plus org/parent and plan type. | contract_id | 2026-10-01 | 3.46s |
| get_hos v0.2.0 | Returns a Medicare Advantage contract's CMS Health Outcomes Survey (HOS) rates across the four survey topics (fall_risk_management, urinary_incontinence, osteop | contract_id | 2026-09-19 | 7.56s |
| get_landscape v0.5.0 | Returns the CMS Landscape view of a Medicare plan: monthly premium, in-network MOOP, overall star rating, plan type, and the county/state service-area breadth. | contract_id | 2026-10-01 | 2.45s |
| get_landscape_benefit_change v1.4.0 | What the plan design looked like for the SAME Medicare Advantage members in year Y and in year Y+1, member-weighted from the CMS Landscape files: total, Part C | none | 2026-09-30 | 4.73s |
| get_landscape_exits v1.2.1 | Members of Medicare Advantage plans that do NOT continue into the next plan year, from the Landscape disposition: every September member of year Y placed against the Y+1 Landscape file. | none | 2026-09-30 | 4.73s |
| get_market_share v0.3.1 | Returns a Medicare Advantage plan's or contract's county-level enrollment and its SHARE of the local MA market: for each county, the plan's enrollees, the count | contract_id | 2026-09-19 | 6.33s |
| get_medicaid_mco_enrollment v0.5.0 | Returns Medicaid managed-care enrollment for ONE state. | state | 2026-11-01 | 4.39s |
| get_network_breadth v0.2.0 | How broad a Medicare Advantage plan's published provider network is, county by county, against the other plans sold there: for a contract or CMS plan id and pla | plan_year | 2026-11-05 | 1.75s |
| get_network_change v0.2.0 | Who joined and who left a Medicare Advantage plan's published network between two directory years (2026 to 2027): the NPIs that stayed, joined and left, with rates, on published units only. | none | 2026-11-02 | 2.3s |
| get_network_groups v0.2.0 | Which physician groups and health systems a Medicare Advantage contract's published network covers, and how much of each: for a contract and plan year (2026 or | none | 2026-11-06 | 1.7s |
| get_network_system_change v0.2.0 | Which health systems (or specialties) Medicare Advantage networks gained and lost between 2026 and 2027, from the plans' own published directories: for a contra | none | 2026-11-05 | 1.74s |
| get_pbp_benefit v0.5.0 | Returns Plan Benefit Package (PBP) benefit detail for an MA plan for a specific category (dental, inpatient_hospital, ER, etc.). | contract_id, plan_id, payment_year, category | 2026-09-19 | 0.12s |
| get_plan_hospitals v0.2.0 | The hospitals in a Medicare Advantage plan's published provider network for 2026 or 2027, by contract or CMS plan id: each hospital (CMS certification number, n | plan_year | 2026-11-05 | 2.9s |
| get_plan_network v0.2.0 | The provider network a Medicare Advantage plan publishes: the NPIs its directory lists for a plan year (2026 or 2027), by contract or CMS plan id, with the sour | plan_year | 2026-11-02 | 1.19s |
| get_plan_value v1.6.2 | Vlada Plan Value: MODELED value to the member of a Medicare Advantage plan, per member per month, for 2026 and 2027 (never a filed benefit, a bid or a paid claim). | none | 2026-10-09 | 7.79s |
| get_quality_bonus v1.0.0 | MA quality bonus dollars by contract or parent and payment year. | none | 2026-10-09 | 2.4s |
| get_star_benchmark v1.0.0 | How a Medicare Advantage contract performs on the Star measures against the market, its peers, its competitors and CMS's cut points, over time. | contract_id | 2026-10-12 | 10.97s |
| get_star_decomposition v1.5.2 | How a contract's star is built, and what moves it to the next line. | contract_id | 2026-10-09 | 3.8s |
| get_star_risk v4.0.0 | Star Risk: odds a star falls, holds or rises next year. | none | 2026-10-13 | 3.76s |
| get_stars v0.8.1 | Returns a Medicare Advantage contract's CMS Star Ratings: the Overall, Part C, and Part D summary stars for a rating year, each with the year-over-year change vs the prior year. | contract_id | 2026-10-01 | 0.1s |
| get_stars_cutpoints v0.6.1 | Returns CMS-published per-measure star-level cut points (the threshold a contract must reach for stars 2 to 5) for a rating_year, read through the Stars measure | rating_year | 2026-10-01 | 7.21s |
| get_stars_rollup v1.2.0 | MA Star Ratings by parent, product type or state, year over year. | none | 2026-10-09 | 4.8s |
| get_volatility_index v1.0.0 | The County Volatility Index, ranked across counties, states or insurers: per 100 members of individual Medicare Advantage plans the September before a plan year | none | 2026-10-26 | 2.44s |
| is_provider_in_plan v0.2.0 | Every Medicare Advantage plan whose published directory lists an NPI for a plan year (2026 or 2027): contract, CMS plan id, the source of the listing (the payer | npi, plan_year | 2026-11-02 | 1.46s |
| medicare_allowed v0.1.0 | Returns the Medicare allowed amount for ONE billing code (CPT/HCPCS, or an MS-DRG for inpatient) from every Medicare fee schedule that prices it: PFS (professio | billing_code | 2026-09-19 | 0.09s |
| prove_ma_enrollment_trend v0.1.0 | Execute a bounded MA enrollment-trend proof. | parent_org, year_range_start, year_range_end | 2026-09-19 | 4.48s |
Hospital price transparency (6)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| compare_hospital_rates v1.22.0 | NEGOTIATED RATES BY INSURER AND PLAN ARE SERVED HERE: hospital price-transparency files carry the rate each hospital filed for each payer and plan (the insurer-file / TiC tools are coming soon). | billing_code | 2026-09-19 | 5.67s |
| get_hospital_quality v0.1.0 | Returns one hospital's CMS Care Compare quality record by CCN: the overall star rating (1-5) with hospital type / ownership; every Care Compare measure for the | ccn | 2026-09-19 | 3.68s |
| get_service_line_prices v1.0.0 | A market's or a hospital's negotiated prices across a whole SERVICE LINE in ONE call: GI endoscopy, MRI, CT, cardiology, orthopedics, maternity, lab, and the re | none | 2026-10-18 | 11.17s |
| plan_hospital_price v1.5.0 | One hospital, one code, the rate by payer and plan name as the hospital filed it (where negotiated rates by insurer live today; the insurer-file / TiC tools are coming soon). | hospital_ccn, billing_code | 2026-09-19 | 6.39s |
| prove_hospital_price v1.5.0 | One hospital, one code, the rate by payer and plan name with a receipt (where negotiated rates by insurer live today; the insurer-file / TiC tools are coming soon). | hospital_ccn, billing_code | 2026-09-19 | 2.95s |
| replay_hospital_price v1.5.0 | Replay a hospital price-proof receipt by re-running its recorded tool inputs and comparing response hash, Iceberg snapshot, plan hash, row count, status, and raw-byte source descriptor. | receipt | 2026-09-19 | 2.7s |
Insurer negotiated rates (2)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| get_exchange_plan_profile v1.0.0 | One ACA Marketplace (healthcare.gov / HIX) plan's profile for a plan year, every field tagged with the CCIIO PUF it came from. | none | 2026-09-19 | 2.48s |
| query_substrate v1.1.0 | Set fresh=true for a user-requested saved-view update: execute without the result cache; all access and scan limits still apply. | sql | 2026-09-19 | 0.09s |
Provider identity (1)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| resolve_provider v1.0.0 | Resolve a provider's identity: an NPI, an EIN, or an organisation name (+ state) -> the Medicare CCN(s) it maps to, the CCN's provider type from the CCN authori | none | 2026-09-19 | 16.24s |
Drugs and formularies (5)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| asp_pricing_lookup v1.1.0 | Given an HCPCS code or short-description search, returns Medicare Part B ASP quarterly payment-limit rows from drug_silver.fact_drug_asp_quarterly_v2 (is_current) with trend aggregates. | none | 2026-09-19 | 2.21s |
| excluded_prescriber_payment_screen v1.2.0 | Given an NPI (10-digit), returns OIG LEIE exclusion status and — if excluded — any Open Payments received OR Part D prescribing activity recorded AFTER the excl | npi | 2026-09-19 | 4.88s |
| formulary_churn v1.0.0 | Given a quarter-pair (report_quarter_from, report_quarter_to) AND a formulary or plan filter, returns the formulary delta: drugs added, drugs dropped, drugs re- | report_quarter_from, report_quarter_to | 2026-09-19 | 15.26s |
| pbm_compensation_rollup v2.0.0 | Sums Form 5500 Schedule C direct + indirect compensation for a named PBM across one or more plan years. | pbm_name | 2026-09-19 | 6.56s |
| recall_spend_window v2.0.0 | Given an FDA-assigned recall_number, returns recall metadata plus Medicare Part D and Medicaid SDUD federal spend on the recalled drug during the recall window | recall_number | 2026-09-19 | 12.5s |
Curated datasets (13)
| Tool | What it answers | Required | Admitted | Answer |
|---|---|---|---|---|
| certified_measure v1.0.0 | Run a GOVERNED KPI by name from the certified measures registry. | none | 2026-09-19 | 0.1s |
| describe_data_source v1.3.0 | Return the catalog record for one substrate data source. | source_fqn | 2026-09-19 | 0.09s |
| describe_entity v2.0.0 | Everything layer one holds about one entity (an entity_id from resolve_entity): what it is and its identifiers; who owned or controlled it on a date (on=YYYY-MM | entity_id | 2026-10-29 | 14.15s |
| describe_schema v1.0.0 | Return the semantic layer: marts, columns, invariants, canonical payers, and the tools YOU can call (the same list tools/list returns for you, never a wider catalog). | none | 2026-09-19 | 0.08s |
| fetch_query v1.0.0 | Fetch the result of an async job once it is done. | job_id | 2026-09-19 | pending |
| find_data_sources v1.0.0 | Search the Vlada substrate catalog by keyword. | none | 2026-09-19 | 0.65s |
| find_views v1.0.0 | Look up the vetted analytic VIEWS for a question before you query. | none | 2026-09-30 | 0.95s |
| how_to_join v1.3.0 | Return the fail-closed measured way to join two Vlada substrate tables, including an explicit DIRECT_OK, DIRECT_DECLARED_KEY, NEEDS_GRAIN, ROUTE_THROUGH_DIM, ROUTE_MULTIHOP, or DO_NOT_SERVE directive. | table_a | 2026-09-19 | 0.24s |
| poll_query v1.0.0 | Poll the status of an async job submitted with submit_query. | job_id | 2026-09-19 | pending |
| query v0.3.0 | SAFE STUB. Given a catalog source FQN, return HOW to query it FROM THIS MCP -- and only paths executable here: query_substrate (sync, small) or submit_query -> | source_fqn | 2026-09-19 | 0.62s |
| resolve_entity v2.0.0 | Resolve any company name or ID to Vlada's canonical entity: a legal entity (le:...), a brand, an NAIC group, a CMS contract (H1234), a plan (H1234-001@2027), a | text | 2026-10-29 | 3.98s |
| state_expert v1.2.1 | The callable STATE EXPERT — the data-availability + regulation X-ray for a US state. | state_code | 2026-10-01 | 5.36s |
| submit_query v1.1.0 | Submit a heavy/long-running query to run OFF the request path and get a job_id back immediately, instead of blocking (and risking a timeout) on a statewide/cross-hospital scan. | tool | 2026-09-19 | 0.48s |
This page as markdown: /docs-md/recipes.md · every page in one file: /llms-full.txt