K-Dense-AI/scientific-agent-skills / skills/database-lookup
database-lookup
VerifiedQueries 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.
references/fda.md
View on GitHub# 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.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |