Spiral gives your agent every tool with one account. Browse the tools →

VS Code · Health

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.

Prompts to try with FDA substance records in VS Code

Copy an example into VS Code, or ask in your own words.

Use FDA substance records to look up acetaminophen and paracetamol, compare the returned UNIIs, and propose any duplicate corrections in our ingredient seed file.

FDA substance recordsVS Code
Try asking
  • 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:

    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.

    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.

    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.

FDA substance records providers and prices

Spiral runs FDA substance records through Alexandria. Open a card for today's price, with every fee included.

AlexandriaHealth
FDA · Substances
fda-gov/substances/substances

Settings you can ask for

Ask VS Code for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Skip0 to 250000

skip

Limit1 to 205

limit

Every API field of FDA · Substances is on its tool page: open its card above.

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.

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.

Get started

Start using FDA substance records in VS Code

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into VS Code:

Set up VS Code

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options