How to Use CMS drug spending records in Devin
Returns pages of records from a CMS drug spending dataset. Use it to collect a complete dataset for comparisons, historical analysis, or your own calculations.
Prompts to try with CMS drug spending records in Devin
Copy an example into Devin, or ask in your own words.
Use CMS drug spending records to collect the annual Medicare Part D data and build a chart in this project comparing Eliquis prescription fills and total spending across available years.
Use CMS drug spending records 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 records and tell me what changed since last week.
Check CMS drug spending records and summarize what you find in three bullet points.
Pull the newest data from CMS drug spending records and give me the result as a table.
How to set up CMS drug spending records in Devin
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add a custom MCP
Open Customize › MCPs. Click + and choose New MCP. Fill in:
- Sign in to Spiral and approve
In Customize › MCPs, open Spiral and choose Connect. Spiral opens: sign in, pick the organization and click Authorize. No API key.
- Check it
On Spiral's configuration page, click Test tools. Devin lists Spiral's tools.
Use the Spiral skill
- Send Devin 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 records
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/records_list", "input": { "dataset": "part_d_annual" } }'
Then paste one of the prompts above: Devin finds CMS drug spending records on Spiral, shows the price and runs it.
CMS drug spending records providers and prices
Spiral runs CMS drug spending records through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask Devin for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Dataset | part_d_annual, part_d_quarterly, part_b_annual, part_b_quarterly, medicaid_annual, or part_d_geography | Dataset key: part_d_annual (Medicare Part D Spending by Drug), part_d_quarterly (Medicare Quarterly Part D Spending by Drug), part_b_annual (Medicare Part B Spending by Drug), part_b_quarterly (Medicare Quarterly Part B Spending by Drug), medicaid_annual (Medicaid Spending by Drug), part_d_geography (Medicare Part D Prescribers - by Geography and Drug). | |
| Page size | 1 to 5000 | Source rows per page (default 1000, maximum 5000: the API silently caps larger sizes). Annual pages yield five records per row. |
Every API field of CMS data.cms.gov · Records list is on its tool page: open its card above.
What can you do with CMS drug spending records in Devin?
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.
Medicaid spending concentration analysis
Rank drugs by reported Medicaid spending and use the full dataset to calculate how much the largest drugs contribute to the total. Keep the analysis at the drug and prescription level because beneficiary counts are unavailable.
Refresh an internal research dataset
Check publication metadata before collecting another copy of annual drug spending records. Compare successive collections to identify which reported drug totals changed.
More on CMS drug spending records and Devin
Overview
CMS drug spending records in other agents
Questions about CMS drug spending records in Devin
Can Devin use CMS drug spending records?
Yes. Add Spiral to Devin as an MCP server, and Devin can find and run CMS drug spending records like any built-in tool.
How much does CMS drug spending records cost in Devin?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Devin plan is separate.
Do I need an Alexandria account to use CMS drug spending records in Devin?
No. Spiral runs CMS drug spending records 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 records in Devin?
About two minutes: add a custom MCP, then sign in to Spiral and approve, then check it.
Does Devin wait while CMS drug spending records runs?
CMS drug spending records runs in the background. Devin 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 records in Devin
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into Devin:
set up https://spiral.ai/SKILL.md


