[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [U.S. Treasury debt issues and redemptions](https://spiral.ai/integrations/opencode/u-s-treasury-debt-issues-and-redemptions)

# How to Use U.S. Treasury debt issues and redemptions in opencode

Returns Treasury security issues and redemptions by category, with daily and cumulative amounts. Use it to compare borrowing and repayments across bills, notes, bonds, and nonmarketable securities.

|  |  |
| --- | --- |
| Model | U.S. Treasury debt issues and redemptions |
| Available through | Alexandria |
| Category | Finance |
| Price | $0.001746 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with U.S. Treasury debt issues and redemptions in opencode

- Use U.S. Treasury debt issues and redemptions to build a July 2025 table comparing daily bill, note, and bond issues with redemptions.
- Use U.S. Treasury debt issues and redemptions to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from U.S. Treasury debt issues and redemptions and tell me what changed since last week.
- Check U.S. Treasury debt issues and redemptions and summarize what you find in three bullet points.
- Pull the newest data from U.S. Treasury debt issues and redemptions and give me the result as a table.

## How to set up U.S. Treasury debt issues and redemptions 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 U.S. Treasury debt issues and redemptions**: 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": "treasury-fiscal-data/daily-statement/public-debt-transactions",
    "input": {
      "sort": "<sort>"
    }
  }'
```

Then paste one of the prompts above: opencode finds U.S. Treasury debt issues and redemptions on Spiral, shows the price and runs it.

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

## U.S. Treasury debt issues and redemptions tools and prices

- [Treasury Fiscal Data · Public debt transactions](https://spiral.ai/tools/alexandria/treasury-fiscal-data/daily-statement/public-debt-transactions) (Alexandria): $0.001746 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| sort |  | — | Sort column, prefixed with `-` for descending: `-record_date` puts the latest first. Comma-separated for several. Unsorted results come back oldest first. |
| fields |  | — | Columns to return, comma-separated, in place of all of them. Rows come back distinct over the chosen columns, so `fields=security_type` on auction results answers three rows, not eleven thousand; keep every column that identifies a row in the list before counting or summing (for buybacks, `operation_date` and `operation_start_time_est`, plus `cusip_nbr` on securities). A column not in the declared list answers HTTP 400 naming it. |
| filter |  | — | Filter, as `column:operator:value`, several joined by commas: `record_date:gte:2026-01-01`, `security_type:eq:Bill,auction_date:gte:2026-08-01`. Operators: eq, lt, lte, gt, gte, and in with a parenthesised list `security_type:in:(Bill,Note)`. An unknown column answers HTTP 400. |
| page[size] | … to 10000 | 100 | Rows per page, 1 to 10,000. The default of 100 is fine for a summary series and far too small for a full auction history. |
| page[number] |  | 1 | Page number, 1-indexed. `meta.total-pages` in the response says how many there are. |

## What can you do with U.S. Treasury debt issues and redemptions in opencode?

Build a daily U.S. Treasury time series in your project. A coding agent can chart reported balances or transaction amounts and distinguish daily flows from cumulative totals.

### Daily Treasury briefing

Prepare a dated briefing with the cash balance, major deposit and withdrawal categories, and security issues and redemptions.

### Cash and borrowing comparison

Compare changes in Treasury cash with reported cash flows and debt transactions over a selected week.

### Historical episode review

Examine a period such as June 2023 through separate charts of Treasury balances, cash transactions, and security issuance and redemption.

### Quarterly fiscal comparison

Compare two quarters using closing cash balances, daily cash flows, and daily debt issues and redemptions. Keep cumulative transaction amounts separate from daily amounts.

### Security repayment analysis

Compare bill, note, and bond issues with redemptions over a month to calculate net issuance for each category.

## Overview

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

## U.S. Treasury debt issues and redemptions in other agents

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

## More opencode guides

- [U.S. Treasury daily deposits and withdrawals](https://spiral.ai/integrations/opencode/u-s-treasury-daily-deposits-and-withdrawals)
- [U.S. Treasury debt to the penny](https://spiral.ai/integrations/opencode/u-s-treasury-debt-to-the-penny)
- [U.S. Treasury cash balance](https://spiral.ai/integrations/opencode/u-s-treasury-cash-balance)
- [U.S. Treasury gold reserves](https://spiral.ai/integrations/opencode/u-s-treasury-gold-reserves)
- [U.S. Treasury average interest rates](https://spiral.ai/integrations/opencode/u-s-treasury-average-interest-rates)
- [U.S. Treasury historical debt outstanding](https://spiral.ai/integrations/opencode/u-s-treasury-historical-debt-outstanding)

## Questions about U.S. Treasury debt issues and redemptions in opencode

**Can opencode use U.S. Treasury debt issues and redemptions?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run U.S. Treasury debt issues and redemptions like any built-in tool.

**How much does U.S. Treasury debt issues and redemptions cost in opencode?**

$0.001746 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 U.S. Treasury debt issues and redemptions in opencode?**

No. Spiral runs U.S. Treasury debt issues and redemptions on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up U.S. Treasury debt issues and redemptions in opencode?**

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

**Does opencode wait while U.S. Treasury debt issues and redemptions runs?**

U.S. Treasury debt issues and redemptions runs in the background. opencode starts the run, checks on it and gives you the json when it's ready.

**What government activity does this source cover?**

The Daily Treasury Statement covers the U.S. Treasury's cash and debt operations for the federal government. Its scope is federal cash and debt reporting.

**How soon does Treasury publish each day's report?**

Treasury states that the Daily Treasury Statement is available by 4:00 p.m. the following business day. The figures describe a completed reporting day.

**How are weekends and federal holidays handled?**

Treasury includes transactions occurring on weekends and federal holidays in the next business day's statement. A business-day observation can therefore include activity from intervening nonbusiness days.

**How precise are the reported amounts?**

Figures are rounded to the nearest million dollars. Treasury warns that rounded detail may not add exactly to published totals.

**What accounting basis does Treasury use?**

The statement uses a modified cash basis. Deposits are reported when received and withdrawals when processed.

