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

View on GitHub
# NOAA Climate Data Online (CDO) API Reference

## Base URL
```
https://www.ncdc.noaa.gov/cdo-web/api/v2
```

## Authentication
- **API Token: REQUIRED.** Request a free token at https://www.ncdc.noaa.gov/cdo-web/token
- Pass as HTTP header: `Token: YOUR_TOKEN`

## Rate Limits
- **5 requests per second** per token.
- **10,000 requests per day** per token.
- Queries are limited to **1,000 results per request** (use `offset` for pagination).
- Date ranges limited to **1 year per request** for the `/data` endpoint.

## Common Parameters (apply to most endpoints)
| Parameter      | Type   | Required | Default | Description |
|---------------|--------|----------|---------|-------------|
| `datasetid`   | string | Varies   | -       | Dataset ID (e.g. `GHCND`, `GSOM`). |
| `datatypeid`  | string | No       | -       | Data type filter (e.g. `TMAX`, `PRCP`). |
| `locationid`  | string | No       | -       | Location ID (e.g. `FIPS:37`, `ZIP:28801`, `CITY:US390029`). |
| `stationid`   | string | No       | -       | Station ID (e.g. `GHCND:USW00013874`). |
| `startdate`   | string | Varies   | -       | ISO date `YYYY-MM-DD`. |
| `enddate`     | string | Varies   | -       | ISO date `YYYY-MM-DD`. |
| `units`       | string | No       | native/unscaled | `standard` or `metric`. |
| `limit`       | int    | No       | 25      | Results per page (max 1000). |
| `offset`      | int    | No       | 1       | Pagination offset (1-based). |
| `sortfield`   | string | No       | -       | Field to sort by (e.g. `date`, `name`). |
| `sortorder`   | string | No       | `asc`   | `asc` or `desc`. |

---

## Key Endpoints

### 1. Data (Observations)
```
GET /data
```
Returns actual observation data. This is the primary data retrieval endpoint.

**Required parameters:** `datasetid`, `startdate`, `enddate`.

**Example -- daily max temperature for a station:**
```bash
curl -H "Token: YOUR_TOKEN" \
  "https://www.ncdc.noaa.gov/cdo-web/api/v2/data?datasetid=GHCND&datatypeid=TMAX&stationid=GHCND:USW00013874&startdate=2024-01-01&enddate=2024-01-31&units=metric&limit=31"
```

**Response:**
```json
{
  "metadata": {
    "resultset": {
      "offset": 1,
      "count": 31,
      "limit": 31
    }
  },
  "results": [
    {
      "date": "2024-01-01T00:00:00",
      "datatype": "TMAX",
      "station": "GHCND:USW00013874",
      "attributes": ",,W,2400",
      "value": 12.2
    },
    {
      "date": "2024-01-02T00:00:00",
      "datatype": "TMAX",
      "station": "GHCND:USW00013874",
      "attributes": ",,W,2400",
      "value": 8.9
    }
  ]
}
```
`units=standard` requests scaled US customary units (temperature in Fahrenheit); `units=metric` requests scaled metric units (Celsius). When `units` is omitted, native dataset scaling applies (GHCND raw temperature uses tenths of Celsius). Save the requested units with the observations.

### 2. Datasets
```
GET /datasets
GET /datasets/{id}
```
Lists available datasets or gets details for one.

**Example:**
```bash
curl -H "Token: YOUR_TOKEN" \
  "https://www.ncdc.noaa.gov/cdo-web/api/v2/datasets?limit=10"
```

**Key Dataset IDs:**
| ID       | Name | Description |
|----------|------|-------------|
| `GHCND`  | Daily Summaries | Global daily station observations (TMAX, TMIN, PRCP, SNOW, etc.) |
| `GSOM`   | Global Summary of the Month | Monthly aggregates |
| `GSOY`   | Global Summary of the Year | Annual aggregates |
| `NORMAL_DLY` | Climate Normals Daily | 30-year daily normals |
| `NORMAL_MLY` | Climate Normals Monthly | 30-year monthly normals |
| `PRECIP_15`  | Precipitation 15-Minute | Sub-hourly precipitation |
| `PRECIP_HLY` | Precipitation Hourly | Hourly precipitation |

### 3. Data Types
```
GET /datatypes
GET /datatypes/{id}
```
Lists available data types, optionally filtered by dataset.

**Example:**
```bash
curl -H "Token: YOUR_TOKEN" \
  "https://www.ncdc.noaa.gov/cdo-web/api/v2/datatypes?datasetid=GHCND&limit=50"
```

**Common GHCND Data Types:**
| ID     | Description |
|--------|-------------|
| `TMAX` | Maximum temperature |
| `TMIN` | Minimum temperature |
| `TAVG` | Average temperature |
| `PRCP` | Precipitation |
| `SNOW` | Snowfall |
| `SNWD` | Snow depth |
| `AWND` | Average wind speed |
| `WSF2` | Fastest 2-minute wind speed |

### 4. Stations
```
GET /stations
GET /stations/{id}
```
Find weather stations, optionally filtered by location, dataset, or extent.

**Additional Parameters:**
| Parameter  | Type   | Description |
|-----------|--------|-------------|
| `extent`  | string | Bounding box: `south_lat,west_lon,north_lat,east_lon`. |

**Example -- stations near Asheville, NC with daily data:**
```bash
curl -H "Token: YOUR_TOKEN" \
  "https://www.ncdc.noaa.gov/cdo-web/api/v2/stations?datasetid=GHCND&locationid=ZIP:28801&limit=10"
```

**Response:**
```json
{
  "metadata": {"resultset": {"offset": 1, "count": 5, "limit": 10}},
  "results": [
    {
      "elevation": 661.1,
      "mindate": "1893-01-01",
      "maxdate": "2024-11-15",
      "latitude": 35.5951,
      "name": "ASHEVILLE REGIONAL AIRPORT, NC US",
      "datacoverage": 1,
      "id": "GHCND:USW00013874",
      "elevationUnit": "METERS",
      "longitude": -82.5572
    }
  ]
}
```

### 5. Locations & Location Categories
```
GET /locations
GET /locations/{id}
GET /locationcategories
GET /locationcategories/{id}
```
Browse location hierarchies (countries, states, cities, zip codes, climate regions).

**Example:**
```bash
curl -H "Token: YOUR_TOKEN" \
  "https://www.ncdc.noaa.gov/cdo-web/api/v2/locations?locationcategoryid=ST&limit=52"
```

Location category IDs: `CITY`, `CLIM_DIV`, `CLIM_REG`, `CNTRY`, `CNTY`, `HYD_ACC`, `HYD_CAT`, `HYD_REG`, `HYD_SUB`, `ST`, `ZIP`.

---

## Workflow: Finding and Querying Data

1. **Find a dataset:** `GET /datasets` to list available datasets.
2. **Find a station:** `GET /stations?datasetid=GHCND&locationid=ZIP:28801` to find nearby stations.
3. **Check available data types:** `GET /datatypes?datasetid=GHCND&stationid=GHCND:USW00013874`.
4. **Query data:** `GET /data?datasetid=GHCND&stationid=GHCND:USW00013874&datatypeid=TMAX,TMIN&startdate=2024-01-01&enddate=2024-12-31&units=metric&limit=1000`.

## Notes
- The `/data` endpoint enforces a **1-year max date range** per request. For multi-year queries, make sequential requests.
- Pagination: `offset` is 1-based. Loop until `offset + limit > count` from the metadata.
- Station IDs include a dataset prefix (e.g. `GHCND:USW00013874`).
- The `attributes` field in data results contains quality flags (comma-separated). Consult dataset documentation for flag meanings.
- Token goes in the header, not as a query parameter.

For `/data`, bound daily/subdaily requests to one year; monthly and annual datasets allow up to ten years. Follow the returned resultset offset and count rather than assuming every endpoint starts at the same offset. Official contract: https://www.ncei.noaa.gov/cdo-web/webservices/v2
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