Skip to content

K-Dense-AI/scientific-agent-skills / skills/database-lookup

database-lookup

Verified

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.

FileKindSize
SKILL.mdskill md26.9 KB
references/addgene.mdmarkdown1.7 KB
references/alphafold.mdmarkdown2.9 KB
references/alphavantage.mdmarkdown7.9 KB
references/bea.mdmarkdown14.3 KB
references/bindingdb.mdmarkdown2.9 KB
references/biogrid.mdmarkdown3.8 KB
references/bls.mdmarkdown9.1 KB
references/brenda.mdmarkdown2.9 KB
references/cbioportal.mdmarkdown7.4 KB
references/census.mdmarkdown9.0 KB
references/chebi.mdmarkdown3.5 KB
references/chembl.mdmarkdown2.7 KB
references/clinicaltrials.mdmarkdown3.4 KB
references/clinpgx.mdmarkdown1.5 KB
references/clinvar.mdmarkdown4.1 KB
references/cod.mdmarkdown3.0 KB
references/cosmic.mdmarkdown1.3 KB
references/dailymed.mdmarkdown1.8 KB
references/database_selection_guide.mdmarkdown10.0 KB
references/datacommons.mdmarkdown7.0 KB
references/dbsnp.mdmarkdown3.5 KB
references/disgenet.mdmarkdown1.4 KB
references/drugbank.mdmarkdown1.3 KB
references/ecb.mdmarkdown5.2 KB
references/emdb.mdmarkdown1.1 KB
references/ena.mdmarkdown9.9 KB
references/encode.mdmarkdown1.8 KB
references/ensembl.mdmarkdown14.0 KB
references/epa.mdmarkdown1.9 KB
references/eurostat.mdmarkdown7.3 KB
references/fda.mdmarkdown2.1 KB
references/federal-reserve.mdmarkdown6.7 KB
references/fred.mdmarkdown9.9 KB
references/gene-ontology.mdmarkdown4.4 KB
references/geo.mdmarkdown3.8 KB
references/gnomad.mdmarkdown3.5 KB
references/gtex.mdmarkdown4.1 KB
references/gwas-catalog.mdmarkdown1.6 KB
references/hca.mdmarkdown1.4 KB
references/hpo.mdmarkdown1.2 KB
references/human-protein-atlas.mdmarkdown1.2 KB
references/interpro.mdmarkdown3.4 KB
references/jaspar.mdmarkdown1.4 KB
references/kegg.mdmarkdown2.5 KB
references/lincs-l1000.mdmarkdown2.1 KB
references/materials-project.mdmarkdown4.8 KB
references/metabolomics-workbench.mdmarkdown3.8 KB
references/monarch.mdmarkdown1.5 KB
references/mousemine.mdmarkdown1.5 KB
references/myvariant.mdmarkdown1.3 KB
references/nasa-exoplanet-archive.mdmarkdown4.3 KB
references/nasa.mdmarkdown3.0 KB
references/ncbi-gene.mdmarkdown1.7 KB
references/ncbi-protein.mdmarkdown3.2 KB
references/ncbi-taxonomy.mdmarkdown3.7 KB
references/nist.mdmarkdown3.6 KB
references/noaa.mdmarkdown6.7 KB
references/omim.mdmarkdown3.4 KB
references/opentargets.mdmarkdown7.0 KB
references/openweathermap.mdmarkdown8.2 KB
references/pdb.mdmarkdown3.2 KB
references/pride.mdmarkdown1.4 KB
references/pubchem.mdmarkdown3.4 KB
references/quickgo.mdmarkdown1.5 KB
references/reactome.mdmarkdown2.9 KB
references/regulomedb.mdmarkdown2.0 KB
references/retrieval-contract.mdmarkdown7.2 KB
references/rummageo.mdmarkdown1.3 KB
references/sdss.mdmarkdown4.4 KB
references/sec-edgar.mdmarkdown8.3 KB
references/simbad.mdmarkdown12.3 KB
references/sra.mdmarkdown4.5 KB
references/string.mdmarkdown7.7 KB
references/tcga-gdc.mdmarkdown2.0 KB
references/treasury.mdmarkdown7.2 KB
references/ucsc-genome.mdmarkdown3.3 KB
references/uniprot.mdmarkdown7.1 KB
references/usgs.mdmarkdown9.9 KB
references/uspto.mdmarkdown4.6 KB
references/who.mdmarkdown8.7 KB
references/worldbank.mdmarkdown7.0 KB
references/zinc.mdmarkdown5.7 KB

references/metabolomics-workbench.md

View on GitHub
# Metabolomics Workbench REST API

## Base URL
```
https://www.metabolomicsworkbench.org/rest/
```

## Auth
No API key required. Fully public.

## URL Structure
```
/rest/{context}/{input_item}/{input_value}/{output_item}
```

Contexts: `study`, `compound`, `refmet`, `gene`, `protein`, `moverz` (`exactmass` is an input item, not a context)

## Key Endpoints

### Study Context
| URL Pattern | Description |
|---|---|
| `/rest/study/study_id/{ST_ID}/summary` | Study summary metadata |
| `/rest/study/study_id/{ST_ID}/metabolites` | Metabolites in a study |
| `/rest/study/study_id/{ST_ID}/analysis` | Analysis details |
| `/rest/study/study_id/{ST_ID}/factors` | Experimental factors |
| `/rest/study/study_id/{ST_ID}/data` | Named metabolite data matrix |
| `/rest/study/study_title/{keyword}/summary` | Search studies by title keyword |
| `/rest/study/analysis_id/{AN_ID}/summary` | Summary by analysis ID |

Study IDs: `ST######` (e.g., `ST000001`). Analysis IDs: `AN######`.

### Compound Context
| URL Pattern | Description |
|---|---|
| `/rest/compound/formula/{FORMULA}/all` | Search compound by molecular formula |
| `/rest/compound/pubchem_cid/{CID}/all` | Search by PubChem CID |
| `/rest/compound/hmdb_id/{HMDB_ID}/all` | Search by HMDB ID |
| `/rest/compound/kegg_id/{KEGG_ID}/all` | Search by KEGG ID |
| `/rest/compound/inchi_key/{KEY}/all` | Search by InChI key |
| `/rest/compound/regno/{REGNO}/classification` | Compound classification |
| `/rest/compound/regno/{REGNO}/molfile` | MOL file (structure) |

### RefMet (Standardized Nomenclature)
| URL Pattern | Description |
|---|---|
| `/rest/refmet/name/{NAME}/all` | Full RefMet record |
| `/rest/refmet/match/{NAME}/name` | Match name to standardized RefMet name |

### Gene / Protein Context
| URL Pattern | Description |
|---|---|
| `/rest/gene/gene_symbol/{SYMBOL}/all` | Gene info by symbol |
| `/rest/gene/gene_id/{ID}/all` | Gene info by Entrez ID |
| `/rest/protein/uniprot_id/{ID}/all` | Protein by UniProt ID |

### Mass search

The moverz input encodes library, m/z, adduct and tolerance in Daltons:
```text
/rest/moverz/MB/635.52/M+H/0.5
```
`MB` selects the Metabolomics Workbench library. Encode a plus sign as `%2B`
when a client treats it as a space. Specify the ion/adduct; a positive/negative
mode label alone is not sufficient. Exact mass for a lipid abbreviation is:
```text
/rest/moverz/exactmass/PC(34:1)/M+H
```

## Example Calls

```
# Study summary
https://www.metabolomicsworkbench.org/rest/study/study_id/ST000001/summary

# Metabolites in a study
https://www.metabolomicsworkbench.org/rest/study/study_id/ST000001/metabolites

# Search studies by title
https://www.metabolomicsworkbench.org/rest/study/study_title/diabetes/summary

# Compounds with a formula (not unique chemical identity)
https://www.metabolomicsworkbench.org/rest/compound/formula/C6H12O6/all

# Compound by PubChem CID
https://www.metabolomicsworkbench.org/rest/compound/pubchem_cid/5793/all

# RefMet standardized name match
https://www.metabolomicsworkbench.org/rest/refmet/match/alpha-D-Glucose/name

# m/z search in positive mode
https://www.metabolomicsworkbench.org/rest/moverz/MB/635.52/M%2BH/0.5

# Exact mass search
https://www.metabolomicsworkbench.org/rest/moverz/exactmass/PC(34:1)/M%2BH
```

## Response Format
Most record queries default to JSON. `mwtab` returns MWTab text and `molfile` returns MOL text. `/moverz/exactmass/` returns a short HTML/text result: the live PC(34:1), M+H example returned 760.585077 and C42H83NO8P. No general pagination contract is exposed; keep queries narrow and inspect the actual content type and body. An HTTP 200 can contain an unsupported-input error. Resolve names through RefMet; `compound/name` is not a supported input item.

## Rate Limits
No published limits. Be reasonable. Add 0.5-1s delay for batch calls.

Official query builder and contract: https://www.metabolomicsworkbench.org/tools/mw_rest.php
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall