Public Database Lookup (database-lookup)
Retrieve facts from 78 documented public database APIs reproducibly, with explicit endpoints, pagination, and provenance.
Data & AnalyticsIntermediate★ 33,030⑂ 3,248AI score 9/10Last updated: Aug 9, 2026
What it does
- Ships reference files for 78 public databases (PubChem, UniProt, ClinicalTrials.gov, GDC/TCGA, FRED, SEC EDGAR, WHO GHO and more) with endpoints, parameters, rate limits and pagination behaviour, so the agent calls the real API instead of guessing from general knowledge.
- Forces a retrieval contract up front: target entity, accepted identifiers, organism/genome build/date constraints, output fields, and whether an exhaustive dataset or a targeted lookup is needed.
- Returns auditable output: databases queried, endpoints, parameters, access date, identifier conversions, count reconciliation (expected vs retrieved vs locally filtered) and explicit warnings.
- Includes built-in identifier resolution paths (gene symbol ↔ NCBI Gene ID ↔ Ensembl ↔ UniProt; compound name ↔ PubChem CID ↔ ChEMBL) plus an error-recovery ladder.
- Documents which databases need free API keys, which are POST-only (Open Targets, gnomAD, RummaGEO), and which are paid/restricted with free substitutes.
- Treats API payloads as untrusted third-party data: no embedded-instruction following, no raw text piped into shell commands, no secrets in provenance.
Who it's for
- Researchers and grad students who need citable, source-verified numbers rather than model recall
- Bioinformatics, pharma and clinical data people working with genes, variants, compounds and trials
- Data analysts pulling macroeconomic and demographic series (FRED, BLS, World Bank, Census, Eurostat)
- Research/IP teams tracking patents and regulatory filings (USPTO, SEC EDGAR, OpenFDA)
Examples
- "List every recruiting clinical trial mentioning TP53" → cursor-paginates ClinicalTrials.gov, reconciles total vs retrieved counts, returns a table plus a provenance block.
- "Compare aspirin's ChEMBL bioactivity with its PubChem properties" → resolves name → CID 2244 → CHEMBL25 and records the conversion chain.
- "US unemployment and CPI over the last 10 years" → silently tests for
FRED_API_KEY, proceeds anonymously if absent and notes the lower rate limit.
· · · Install guide · · ·
Try it now, no install
Paste this into Claude to use the skill without installing anything.
Read the instructions in this file and follow them to help me: https://raw.githubusercontent.com/K-Dense-AI/scientific-agent-skills/HEAD/skills/database-lookup/SKILL.md What I want: (describe your task here)
If Claude can't open the link, open it yourself and paste the contents instead.
↓ If it works for you, download the ZIP below and install it. Then it runs on its own — no pasting each time.
Install in the Claude app (no terminal)
- Download the ZIP with the button below.
- In Claude, open Settings → Capabilities and turn on 'Code execution and file creation'. (one time)
- Go to Customize → Skills → + → 'Upload a skill' and upload the ZIP.
Install in Claude Code
Let Claude do it — paste this into Claude Code
Install the skill I found on Claude Skill Mart. Copy the skills/database-lookup folder from the GitHub repo K-Dense-AI/scientific-agent-skills into my ~/.claude/skills/database-lookup/. When it's done, tell me in one line what this skill can do.
Install with a command instead
git clone https://github.com/K-Dense-AI/scientific-agent-skills.git && mkdir -p ~/.claude/skills && cp -r scientific-agent-skills/skills/database-lookup ~/.claude/skills/⚠ This is a third-party skill. Check the source repository before installing.
- Open a terminal (Terminal on macOS/Linux, Git Bash or WSL on Windows).
- Clone the repository:
git clone https://github.com/K-Dense-AI/scientific-agent-skills.git - Copy the whole skill folder — the references/ directory must come with it or the skill can't work:
mkdir -p ~/.claude/skills cp -r scientific-agent-skills/skills/database-lookup ~/.claude/skills/ - Verify the install:
ls ~/.claude/skills/database-lookup/references | head - (Optional) Register for free API keys for the databases you use most and export them in your shell profile or a project
.env, e.g.export FRED_API_KEY=...,export NCBI_API_KEY=... - Restart Claude Code and try a prompt like: "Use the database-lookup skill to get the gnomAD allele frequency for rs334."
View source on GitHub ↗License: MIT