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/geo.md

View on GitHub
# NCBI GEO (Gene Expression Omnibus) via E-utilities

## Base URLs

| Purpose | URL |
|---|---|
| E-utilities | `https://eutils.ncbi.nlm.nih.gov/entrez/eutils/` |
| GEO direct query | `https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi` |

## Important: The database name is `gds`

The Entrez database for GEO is `gds` (not `geo`). It contains all GEO record types: GDS datasets, GSE series, GPL platforms, GSM samples. Filter by type using `[ETYP]` in the search term.

## Key Endpoints

### eSearch — Search GEO

```
GET /esearch.fcgi?db=gds&term={query}&retmode=json&retmax={n}
```

Parameters:
- `db=gds` (required)
- `term` — search query with field tags
- `retmax` — max results (default 20)
- `retstart` — offset for pagination
- `retmode=json` — get JSON response
- `usehistory=y` — store results server-side for large queries
- `api_key` — NCBI API key (optional, raises rate limit)

#### Entry type filters (`[ETYP]`)
- `gds[ETYP]` — curated GEO DataSets
- `gse[ETYP]` — GEO Series (most common, use this by default)
- `gpl[ETYP]` — platforms
- `gsm[ETYP]` — samples

#### Other field tags
- `[Organism]` — e.g. `"Homo sapiens"[Organism]`
- `[PDAT]` — publication date
- `[Title]` — title search
- Boolean: `AND`, `OR`, `NOT` (uppercase)

Example — cancer GSE series in human:
```
/esearch.fcgi?db=gds&term=cancer+AND+gse[ETYP]+AND+"Homo+sapiens"[Organism]&retmax=10&retmode=json
```

Response:
```json
{
  "esearchresult": {
    "count": "15432",
    "retmax": "10",
    "idlist": ["200012345", "200067890"],
    "querytranslation": "cancer AND gse[ETYP]"
  }
}
```

The IDs returned are numeric Entrez UIDs, not accessions. Resolve them with ESummary and read `accession`; do not depend on an arithmetic UID conversion.

### eSummary — Get metadata for UIDs

```
GET /esummary.fcgi?db=gds&id={uid_list}&retmode=json
```

Key response fields per record:
- `accession` — e.g. "GSE12345"
- `title`, `summary`
- `taxon` — organism
- `entrytype` — "GDS", "GSE", "GPL", "GSM"
- `gdstype` — e.g. "Expression profiling by array"
- `n_samples` — sample count
- `pubmedids` — linked PubMed IDs
- `pdat` — publication date
- `samples` — array of sample objects
- `ftplink` — data download path

Example:
```
/esummary.fcgi?db=gds&id=200012345&retmode=json
```

### GEO Direct Query — Full records by accession

```
GET https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi?acc={accession}&form={format}&view={detail}
```

Parameters:
- `acc` — GEO accession (GSE12345, GDS1234, GPL570, GSM12345)
- `targ` — `self`, `gsm` (samples), `gpl` (platform), `gse` (series)
- `form` — `text` (SOFT format), `xml` (MINiML), `html`
- `view` — `quick`, `brief`, `full`, `data`

Example — series metadata in SOFT:
```
acc.cgi?acc=GSE53757&targ=self&form=text&view=brief
```

Note: acc.cgi does not return JSON. Use eSearch + eSummary for JSON results. Use acc.cgi when you need full SOFT/MINiML records.

### eLink — Cross-reference with other NCBI databases

```
GET /elink.fcgi?dbfrom=gds&db=pubmed&id={uid}&retmode=json
```

## Practical Workflow

For most queries, use this two-step approach:

1. **eSearch** to find UIDs matching the query
2. **eSummary** to get metadata for those UIDs

This gives you JSON throughout.

## Important Notes

- GDS records are mostly frozen — NCBI stopped curating new GDS. Use `gse[ETYP]` for comprehensive results.
- eFetch has limited support for the `gds` database. Use eSummary for metadata or acc.cgi for full records.
- URL-encode spaces as `+` and quotes as `%22`.

## Rate Limits

- **Without API key**: 3 requests/second
- **With API key**: 10 requests/second (free registration at ncbi.nlm.nih.gov/account/settings)
- Include `&email=user@example.com` as a courtesy
- For large result sets, use the History server (`usehistory=y` then pass `WebEnv` and `query_key` to eSummary)
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 CodeCodexUnverifiedInstall
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 CodeCodexUnverifiedInstall