How to Use CMS drug spending search in Codex
Returns spending and utilization results for named drugs across Medicare Part D, Part B, or Medicaid. Use it for a question about Eliquis or Keytruda without collecting an entire dataset.
Prompts to try with CMS drug spending search in Codex
Copy an example into Codex, or ask in your own words.
Use CMS drug spending search to find Ozempic and Jardiance in Medicare Part D, then add their reported spending and prescription fills to this project's comparison table.
Use CMS drug spending search to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from CMS drug spending search and tell me what changed since last week.
Check CMS drug spending search and summarize what you find in three bullet points.
Pull the newest data from CMS drug spending search and give me the result as a table.
How to set up CMS drug spending search in Codex
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add the hosted server
codex mcp add spiral --url https://api.spiral.ai/mcp
- Sign in
Codex opens the browser: sign in to Spiral and click Authorize. No API key. codex mcp list then shows Spiral.
codex mcp login spiral
Use the Spiral skill
- Send Codex this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use the Spiral CLI
- Install and sign in
Installs the Spiral CLI, signs you in and adds its skill to your coding agents.
npx -y spiral-cli@latest init
Call the Spiral API
- Create an API key
In the console, under API keys.
- Run CMS drug spending search
One request; the result comes back by polling or a webhook.
curl https://api.spiral.ai/v1/runs \ -H "Authorization: Bearer $SPIRAL_API_KEY" \ -H "Content-Type: application/json" \ -H "Idempotency-Key: $(uuidgen)" \ -d '{ "provider": "alexandria", "model": "data-cms-gov/drug-spending/search", "input": { "drug": "<drug>" } }'
Then paste one of the prompts above: Codex finds CMS drug spending search on Spiral, shows the price and runs it.
CMS drug spending search providers and prices
Spiral runs CMS drug spending search through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask Codex for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Limit | 1 to 50 | 10 | Drugs returned per program, largest latest-year spending first. |
| Program | part_d, part_b, or medicaid | Search one program; omit to search all three. |
Every API field of CMS data.cms.gov · Search is on its tool page: open its card above.
What can you do with CMS drug spending search in Codex?
Build a CMS drug spending report that compares prescription fills with reported spending for named drugs. A coding agent can turn the records into project tables and charts while keeping Medicare and Medicaid measures distinct.
Annual drug spending report
Identify the annual datasets and publication versions, collect the records, rank spending, and investigate named drugs. Recheck the exact records supporting the report's main findings.
Diabetes drug utilization study
Compare reported spending and prescription fills for drugs such as Ozempic and Jardiance across available years. Establish coverage and publication versions first, then verify the individual records behind notable changes.
Medicare Part B oncology spending review
Find the relevant Part B publication, rank spending, and examine Keytruda alongside other reported drugs. Collect the underlying records and verify selected results before preparing a fee-for-service spending brief.
Prescription volume and spending comparison
Use a consistent annual publication to find high-spending drugs and compare their spending changes with prescription-fill changes. Retrieve and verify the records needed to distinguish changes in reported utilization from changes in average spending.
Drug spending fact-check
Check a published claim about Eliquis spending against CMS results, then retrieve the exact drug and year record supporting the comparison. Explain that Part D totals exclude rebates.
Select drugs for a policy brief
Find the highest-spending drugs or largest changes in average spending per unit, then examine named results and their underlying records. Use the findings to choose which drugs warrant a closer explanation.
More on CMS drug spending search and Codex
Overview
CMS drug spending search in other agents
Questions about CMS drug spending search in Codex
Can Codex use CMS drug spending search?
Yes. Add Spiral to Codex as an MCP server, and Codex can find and run CMS drug spending search like any built-in tool.
How much does CMS drug spending search cost in Codex?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Codex plan is separate.
Do I need an Alexandria account to use CMS drug spending search in Codex?
No. Spiral runs CMS drug spending search on its own Alexandria account. You sign in to Spiral once and never paste a key.
How long does it take to set up CMS drug spending search in Codex?
About two minutes: add the hosted server, then sign in.
Does Codex wait while CMS drug spending search runs?
CMS drug spending search runs in the background. Codex starts the run, checks on it and gives you the json when it's ready.
Does CMS drug spending cover the entire US drug market?
No. Annual Part D data summarizes final-action claims for Part D enrollees, Part B spending excludes Medicare Advantage beneficiaries, and Medicaid spending covers outpatient drugs paid for by state Medicaid agencies.
How often does CMS update annual drug spending data?
CMS typically updates the annual Medicare Part D spending dataset once every 12 months. That publication schedule describes the annual dataset, rather than current prescribing activity.
Do the spending totals include rebates?
Part D totals exclude manufacturer rebates and other price concessions. Medicaid totals likewise are not reduced by rebates paid to states, so these figures do not establish spending after rebates.
Can I compare spending per beneficiary across Medicare and Medicaid?
The Medicaid spending dataset does not provide individual beneficiary counts. CMS explicitly says that per-beneficiary calculations are therefore not possible for that dataset.
Does a Part D drug total describe one strength or dosage form?
Annual Part D summaries combine strengths, dosage forms, and routes of administration under brand and generic names. A drug-level result therefore does not isolate a particular tablet strength or injection formulation.
Start using CMS drug spending search in Codex
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into Codex:
set up https://spiral.ai/SKILL.md


