[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [CMS drug spending records](https://spiral.ai/integrations/opencode/cms-drug-spending-records)

# How to Use CMS drug spending records in opencode

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.

|  |  |
| --- | --- |
| Model | CMS drug spending records |
| Available through | Alexandria |
| Category | Health |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with CMS drug spending records in opencode

- 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 opencode

Pick the way that suits you. Each takes about two minutes.

### Use Spiral's MCP server

1. **Add the server**: Leave out `--global` to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.

```bash
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
```

2. **Sign in**: Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, `/mcps` starts the same sign-in.

```bash
opencode mcp auth spiral
```

3. **Check it**: Spiral shows as connected.

```bash
opencode mcp list
```

### Use the Spiral skill

1. **Send opencode this message**: Your agent reads Spiral's skill and sets itself up.

```
set up https://spiral.ai/SKILL.md
```

2. **Sign in or paste a key**: Approve Spiral in the browser, or give the agent a key from the console.

### Use the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run CMS drug spending records**: One request; the result comes back by polling or a webhook.

```bash
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: opencode finds CMS drug spending records on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/opencode

## CMS drug spending records tools and prices

- [CMS data.cms.gov · Records list](https://spiral.ai/tools/alexandria/data-cms-gov/drug-spending/records_list) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| 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. |
| continuation |  | — | Opaque cursor from the previous page's meta.page.next_cursor (also derivable from next_offset). Pins the release; a moved release fails with publication_changed. |

## What can you do with CMS drug spending records in opencode?

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.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All opencode guides](https://spiral.ai/integrations/opencode)

## CMS drug spending records in other agents

- [Amp](https://spiral.ai/integrations/amp/cms-drug-spending-records)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/cms-drug-spending-records)
- [Claude](https://spiral.ai/integrations/claude-desktop/cms-drug-spending-records)
- [Claude Code](https://spiral.ai/integrations/claude-code/cms-drug-spending-records)
- [Cline](https://spiral.ai/integrations/cline/cms-drug-spending-records)
- [Codex](https://spiral.ai/integrations/codex/cms-drug-spending-records)
- [Cursor](https://spiral.ai/integrations/cursor/cms-drug-spending-records)
- [Devin](https://spiral.ai/integrations/devin/cms-drug-spending-records)
- [dots](https://spiral.ai/integrations/dots/cms-drug-spending-records)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/cms-drug-spending-records)
- [Gemini](https://spiral.ai/integrations/gemini/cms-drug-spending-records)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/cms-drug-spending-records)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/cms-drug-spending-records)
- [goose](https://spiral.ai/integrations/goose/cms-drug-spending-records)
- [Grok](https://spiral.ai/integrations/grok/cms-drug-spending-records)
- [Grok Build](https://spiral.ai/integrations/grok-build/cms-drug-spending-records)
- [Hermes](https://spiral.ai/integrations/hermes/cms-drug-spending-records)
- [Instinct](https://spiral.ai/integrations/instinct/cms-drug-spending-records)
- [Manus](https://spiral.ai/integrations/manus/cms-drug-spending-records)
- [Muse](https://spiral.ai/integrations/muse/cms-drug-spending-records)
- [Muse Code](https://spiral.ai/integrations/muse-code/cms-drug-spending-records)
- [n8n](https://spiral.ai/integrations/n8n/cms-drug-spending-records)
- [Notion](https://spiral.ai/integrations/notion/cms-drug-spending-records)
- [OpenClaw](https://spiral.ai/integrations/openclaw/cms-drug-spending-records)
- [Perplexity](https://spiral.ai/integrations/perplexity/cms-drug-spending-records)
- [Raycast](https://spiral.ai/integrations/raycast/cms-drug-spending-records)
- [VS Code](https://spiral.ai/integrations/vscode/cms-drug-spending-records)
- [Windsurf](https://spiral.ai/integrations/windsurf/cms-drug-spending-records)
- [Zapier](https://spiral.ai/integrations/zapier/cms-drug-spending-records)

## More opencode guides

- [CMS drug spending record](https://spiral.ai/integrations/opencode/cms-drug-spending-record)
- [CMS drug spending search](https://spiral.ai/integrations/opencode/cms-drug-spending-search)
- [CMS drug spending rankings](https://spiral.ai/integrations/opencode/cms-drug-spending-rankings)
- [CMS home health agencies](https://spiral.ai/integrations/opencode/cms-home-health-agencies)
- [CMS drug spending publication status](https://spiral.ai/integrations/opencode/cms-drug-spending-publication-status)
- [CMS home health agency details](https://spiral.ai/integrations/opencode/cms-home-health-agency-details)

## Questions about CMS drug spending records in opencode

**Can opencode use CMS drug spending records?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run CMS drug spending records like any built-in tool.

**How much does CMS drug spending records cost in opencode?**

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your opencode plan is separate.

**Do I need an Alexandria account to use CMS drug spending records in opencode?**

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 opencode?**

About two minutes: add the server, then sign in, then check it.

**Does opencode wait while CMS drug spending records runs?**

CMS drug spending records runs in the background. opencode 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.

