AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

database-lookup

Queries documented public database APIs with explicit endpoints, filters, pagination, and provenance. Used when a scientific, regulatory, financial, or other database-backed fact must be retrieved reproducibly from a named source rather than inferred from general knowledge.

Original source
K-Dense-AI
License
MIT
Pinned revision
5f2bc0341354fd5590aef76a533ada1e1e5b4e62

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

Ask your assistant

Use Agentic Memory skills to read k-dense-ai--database-lookup at revision 5f2bc0341354fd5590aef76a533ada1e1e5b4e62, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 83

references/fda.md

OpenFDA API

Base URL

https://api.fda.gov

Auth

Optional free API key (240 req/min with or without). Register at https://open.fda.gov/apis/authentication/ Pass as: ?api_key=YOUR_KEY

Key Endpoints

| Endpoint | Description | |----------|-------------| | /drug/event.json | Drug adverse events (FAERS) | | /drug/label.json | Drug product labeling (SPL) | | /drug/ndc.json | NDC directory | | /drug/drugsfda.json | Drugs@FDA (approvals) | | /drug/enforcement.json | Drug recalls | | /device/event.json | Device adverse events | | /device/510k.json | 510(k) clearances | | /food/event.json | Food adverse events | | /food/enforcement.json | Food enforcement |

Query Parameters

  • search — query using OpenFDA syntax
  • count — count unique values for a field
  • limit — results per request (max 1000)
  • skip — pagination offset (max 25000)

Search Syntax

  • Field search: field:"value"
  • AND: field1:value1+AND+field2:value2
  • OR: field1:value1+OR+field2:value2
  • Date range: field:[20230101+TO+20231231]
  • Wildcards: field:aspir*
  • OpenFDA harmonized fields use openfda. prefix

Example Calls

# Adverse events for aspirin
/drug/event.json?search=patient.drug.openfda.brand_name:"aspirin"&limit=5

# Top adverse reactions for a drug
/drug/event.json?search=patient.drug.openfda.generic_name:"metformin"&count=patient.reaction.reactionmeddrapt.exact

# Drug labels by generic name
/drug/label.json?search=openfda.generic_name:"ibuprofen"&limit=3

# Drug recalls in date range
/drug/enforcement.json?search=report_date:[20230101+TO+20231231]&limit=10

# Serious adverse events only
/drug/event.json?search=patient.drug.openfda.brand_name:"warfarin"+AND+serious:1&limit=10

Rate Limits

| Tier | Requests/min | Requests/day | |------|-------------|-------------| | No API key | 240 | 1,000 | | With API key (free) | 240 | 120,000 |

FAERS reports are not incidence estimates or proof that a drug caused an event. Preserve report versions and avoid double-counting follow-ups. OpenFDA harmonization is incomplete; a missing harmonized name is not evidence of absence.