[Integrations](https://spiral.ai/integrations) › [VS Code](https://spiral.ai/integrations/vscode) › [FDA substance records](https://spiral.ai/integrations/vscode/fda-substance-records)

# How to Use FDA substance records in VS Code

Find a substance’s UNII, recorded names, external codes, and relationships in FDA’s substance registry. Use it to reconcile ingredient names across datasets or inspect recorded links between a salt and its active moiety.

|  |  |
| --- | --- |
| Model | FDA substance 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 FDA substance records in VS Code

- Use FDA substance records to look up acetaminophen and paracetamol, compare the returned UNIIs, and propose any duplicate corrections in our ingredient seed file.
- Use FDA substance records to retrieve UNII 362O9ITL9D and add its recorded names and external codes to our ingredient reference fixture.
- Use FDA substance records to look up sodium chloride and potassium chloride, then build a review table beside our existing ingredient dictionary with returned names and UNIIs.
- Use FDA substance records to inspect the recorded relationships for ibuprofen sodium and ibuprofen, then propose how our schema should preserve those links.
- Use FDA substance records to retrieve caffeine, aspirin, and citric acid and create a JSON reference file containing their returned UNIIs, names, and external codes.

## How to set up FDA substance records in VS Code

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

### Use Spiral's MCP server

1. **Add the hosted server**: Use Add to VS Code on the console's Agents & MCP page, or run:

```bash
code --add-mcp '{"name":"spiral","type":"http","url":"https://api.spiral.ai/mcp"}'
```

2. **Sign in**: VS Code asks you to sign in when it first starts the server: sign in to Spiral and click Authorize. No API key. Run MCP: List Servers from the Command Palette to check that Spiral is running.

### Use the Spiral skill

1. **Send VS Code 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 FDA substance 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": "fda-gov/substances/substances",
    "input": {
      "unii": "<unii>"
    }
  }'
```

Then paste one of the prompts above: VS Code finds FDA substance records on Spiral, shows the price and runs it.

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

## FDA substance records tools and prices

- [FDA · Substances](https://spiral.ai/tools/alexandria/fda-gov/substances/substances) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| code |  | — | One code from another system, e.g. CAS 103-90-2 or RXCUI 161. |
| name |  | — | Exact substance name, e.g. acetaminophen or sodium chloride; tried as typed and in upper, lower, title and sentence case. |
| skip | 0 to 25000 | 0 | skip |
| unii |  | — | UNII, e.g. 362O9ITL9D. Pattern: ^ *[A-Za-z0-9]{10} *$. |
| limit | 1 to 20 | 5 | limit |

## What can you do with FDA substance records in VS Code?

Add FDA substance identifiers and recorded synonyms to your project’s ingredient reference table. A coding agent can compare those records with existing entries and prepare changes for review.

### Reconcile ingredient names

Look up ingredient names from two catalogs and compare their returned UNIIs before proposing duplicate records for review.

### Build an ingredient synonym index

Collect recorded scientific, common, generic, and brand names for a defined ingredient list to support catalog search.

### Cross-reference external identifiers

Attach the external codes recorded by FDA to an ingredient reference table, keeping each code beside its originating system.

### Review salt relationships

Inspect recorded salt, solvate, and active moiety links before combining ingredient records in a research dataset.

### Prepare a terminology review

Give a reviewer the substance’s UNII, recorded names, and external identifiers alongside the ingredient terminology used in a draft document.

### Check published reference changes

Compare periodic lookups for a fixed ingredient list and report changes in returned names, codes, or relationships.

### Create ingredient reference cards

Populate internal reference cards with FDA substance identifiers, names, and recorded relationships for researchers reviewing a compound list.

## Overview

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

## FDA substance records in other agents

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

## More VS Code guides

- [FDA orphan drug designation search](https://spiral.ai/integrations/vscode/fda-orphan-drug-designation-search)
- [FDA warning letter details](https://spiral.ai/integrations/vscode/fda-warning-letter-details)
- [FDA orphan drug designation details](https://spiral.ai/integrations/vscode/fda-orphan-drug-designation-details)
- [FDA warning letter search](https://spiral.ai/integrations/vscode/fda-warning-letter-search)
- [FDA novel drug approvals](https://spiral.ai/integrations/vscode/fda-novel-drug-approvals)
- [G-BA benefit assessment details](https://spiral.ai/integrations/vscode/g-ba-benefit-assessment-details)

## Questions about FDA substance records in VS Code

**Can VS Code use FDA substance records?**

Yes. Add Spiral to VS Code as an MCP server, and VS Code can find and run FDA substance records like any built-in tool.

**How much does FDA substance records cost in VS Code?**

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

**Do I need an Alexandria account to use FDA substance records in VS Code?**

No. Spiral runs FDA substance 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 FDA substance records in VS Code?**

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

**Does VS Code wait while FDA substance records runs?**

FDA substance records runs in the background. VS Code starts the run, checks on it and gives you the json when it's ready.

**What kinds of substances does FDA cover?**

GSRS defines six substance classes: chemicals, proteins, nucleic acids, polymers, mixtures, and structurally diverse substances. Its coverage includes substances used in drugs, biologics, foods, and devices.

**How fresh are the substance records?**

openFDA lists the substance dataset’s update frequency as every few months. A scheduled check can detect a published change, but that schedule does not make the underlying data update daily.

**Does a UNII mean FDA approved the substance?**

No. FDA explicitly states that UNII availability does not imply regulatory review or approval.

**Are the synonyms and code mappings definitive?**

FDA describes them as based on the best public information available at publication. That is a publication-time mapping, not a promise that every name or external identifier is included.

**Which kinds of names can a record include?**

Records can include scientific, common, generic, and brand names. This makes the data useful for comparing ingredient terminology across catalogs without assuming that each spelling represents a different substance.

