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

View on GitHub
# OpenWeatherMap API Reference

## Base URL
```
https://api.openweathermap.org
```

## Authentication
- **API Key: REQUIRED.** Register for a free key at https://home.openweathermap.org/users/sign_up
- Pass as query parameter: `&appid=YOUR_KEY`
- Free tier key activates within a few hours of registration.

## Rate Limits (Free Tier)
- Quotas depend on product and subscription; check the account and [pricing page](https://openweathermap.org/price) before a batch.
- **Current weather, 5-day forecast, geocoding:** Available on free tier.
- **One Call 3.0:** Requires subscription (1,000 free calls/day with credit card on file).
- **Air pollution history** is documented from 2020-11-27; weather-history subscriptions are a separate product. Do not assume all history routes have the same entitlement.

---

## Key Endpoints

### 1. Current Weather
```
GET /data/2.5/weather
```

**Parameters:**
| Parameter | Type   | Required | Default  | Description |
|-----------|--------|----------|----------|-------------|
| `q`       | string | Cond.    | -        | City name, optionally with state/country: `London`, `London,GB`, `Portland,OR,US`. |
| `lat`     | float  | Cond.    | -        | Latitude (use with `lon`). |
| `lon`     | float  | Cond.    | -        | Longitude (use with `lat`). |
| `id`      | int    | Cond.    | -        | City ID (from OWM city list). |
| `zip`     | string | Cond.    | -        | Zip/postal code with country: `90210,US`, `SW1,GB`. |
| `units`   | string | No       | `standard` | `standard` (Kelvin), `metric` (Celsius), `imperial` (Fahrenheit). |
| `lang`    | string | No       | `en`     | Language code for descriptions. |
| `appid`   | string | Yes      | -        | API key. |

Use `lat`+`lon`. Built-in city-name, city-ID and ZIP geocoding (`q`, `id`, `zip`) is deprecated although still available; resolve locations through `/geo/1.0/` for maintained integrations.

**Example:**
```
https://api.openweathermap.org/data/2.5/weather?lat=40.7128&lon=-74.0060&units=metric&appid=YOUR_KEY
```

**Response:**
```json
{
  "coord": {"lon": -74.006, "lat": 40.7128},
  "weather": [
    {
      "id": 800,
      "main": "Clear",
      "description": "clear sky",
      "icon": "01d"
    }
  ],
  "base": "stations",
  "main": {
    "temp": 22.5,
    "feels_like": 21.8,
    "temp_min": 20.1,
    "temp_max": 24.3,
    "pressure": 1013,
    "humidity": 55,
    "sea_level": 1013,
    "grnd_level": 1010
  },
  "visibility": 10000,
  "wind": {"speed": 3.6, "deg": 220, "gust": 5.1},
  "clouds": {"all": 0},
  "dt": 1700000000,
  "sys": {
    "country": "US",
    "sunrise": 1699960000,
    "sunset": 1699996000
  },
  "timezone": -18000,
  "id": 5128581,
  "name": "New York",
  "cod": 200
}
```

### 2. 5-Day / 3-Hour Forecast (Free)
```
GET /data/2.5/forecast
```
Returns forecast data in 3-hour intervals for 5 days (40 data points). Same location parameters as current weather.

**Additional Parameters:**
| Parameter | Type | Description |
|-----------|------|-------------|
| `cnt`     | int  | Number of 3-hour steps to return (max 40). |

**Example:**
```
https://api.openweathermap.org/data/2.5/forecast?lat=51.5085&lon=-0.1257&units=metric&cnt=8&appid=YOUR_KEY
```

**Response:**
```json
{
  "cod": "200",
  "message": 0,
  "cnt": 8,
  "list": [
    {
      "dt": 1700000000,
      "main": {
        "temp": 10.5,
        "feels_like": 8.2,
        "temp_min": 9.8,
        "temp_max": 10.5,
        "pressure": 1020,
        "humidity": 80
      },
      "weather": [{"id": 802, "main": "Clouds", "description": "scattered clouds", "icon": "03d"}],
      "clouds": {"all": 40},
      "wind": {"speed": 4.1, "deg": 250},
      "visibility": 10000,
      "pop": 0.2,
      "dt_txt": "2024-01-15 12:00:00"
    }
  ],
  "city": {
    "id": 2643743,
    "name": "London",
    "coord": {"lat": 51.5085, "lon": -0.1257},
    "country": "GB",
    "population": 1000000,
    "timezone": 0,
    "sunrise": 1699950000,
    "sunset": 1699982000
  }
}
```
`pop` is probability of precipitation (0.0 to 1.0).

### 3. Geocoding
```
GET /geo/1.0/direct
GET /geo/1.0/reverse
GET /geo/1.0/zip
```

**Direct geocoding (city name to coordinates):**
```
https://api.openweathermap.org/geo/1.0/direct?q=London,GB&limit=5&appid=YOUR_KEY
```
Returns array of `{name, lat, lon, country, state}`.

**Reverse geocoding (coordinates to city name):**
```
https://api.openweathermap.org/geo/1.0/reverse?lat=51.5085&lon=-0.1257&limit=1&appid=YOUR_KEY
```

**Zip code geocoding:**
```
https://api.openweathermap.org/geo/1.0/zip?zip=90210,US&appid=YOUR_KEY
```

### 4. One Call API 3.0 (Subscription Required)
```
GET /data/3.0/onecall
```
Comprehensive endpoint returning current, minutely (1h), hourly (48h), daily (8d), and alerts in one call.

**Parameters:**
| Parameter | Type   | Required | Description |
|-----------|--------|----------|-------------|
| `lat`     | float  | Yes      | Latitude. |
| `lon`     | float  | Yes      | Longitude. |
| `exclude` | string | No       | Comma-separated parts to exclude: `current`, `minutely`, `hourly`, `daily`, `alerts`. |
| `units`   | string | No       | `standard`, `metric`, `imperial`. |
| `appid`   | string | Yes      | API key. |

**Example:**
```
https://api.openweathermap.org/data/3.0/onecall?lat=40.7128&lon=-74.006&exclude=minutely,alerts&units=metric&appid=YOUR_KEY
```

### 5. One Call API 4.0 (separate subscription)

The current [One Call 4.0 documentation](https://openweathermap.org/api/one-call-4) describes a separate endpoint family; the 3.0 route above remains separately documented. Do not change only the version in a 3.0 URL.

```text
GET /data/4.0/onecall/current?lat={lat}&lon={lon}&appid={key}
GET /data/4.0/onecall/timeline/1h?lat={lat}&lon={lon}&appid={key}
GET /data/4.0/onecall/timeline/1day?lat={lat}&lon={lon}&appid={key}
```

Responses contain location/timezone fields and a `data` array. Timeline responses can include `next`/`prev` URLs; follow those URLs rather than constructing offsets. Each page is a billed API call under the selected plan. The One Call by Call plan includes 1,000 calls/day free, while the initial account cap is 2,000 calls/day; those are different thresholds. Check the configured limit before running a batch. Examples here are documentation-verified, not authenticated live tests.

### 6. Air Pollution
```
GET /data/2.5/air_pollution
GET /data/2.5/air_pollution/forecast
GET /data/2.5/air_pollution/history
```

**Parameters:** `lat`, `lon`, `appid` (required). For history: `start` and `end` (Unix timestamps).

**Example:**
```
https://api.openweathermap.org/data/2.5/air_pollution?lat=40.7128&lon=-74.006&appid=YOUR_KEY
```

**Response:**
```json
{
  "coord": {"lon": -74.006, "lat": 40.7128},
  "list": [
    {
      "main": {"aqi": 2},
      "components": {
        "co": 230.31,
        "no": 0.5,
        "no2": 15.0,
        "o3": 68.0,
        "so2": 2.5,
        "pm2_5": 8.1,
        "pm10": 12.3,
        "nh3": 1.0
      },
      "dt": 1700000000
    }
  ]
}
```
AQI scale: 1=Good, 2=Fair, 3=Moderate, 4=Poor, 5=Very Poor. Components in ug/m3.

---

## Weather Condition Codes
| Range   | Category |
|---------|----------|
| 2xx     | Thunderstorm |
| 3xx     | Drizzle |
| 5xx     | Rain |
| 6xx     | Snow |
| 7xx     | Atmosphere (fog, mist, haze) |
| 800     | Clear |
| 80x     | Clouds |

Weather icons: `https://openweathermap.org/img/wn/{icon}@2x.png`

## Free Tier vs Paid Summary
| Endpoint | Free | Subscription |
|----------|------|-------------|
| Current weather | Yes | Yes |
| 5-day/3-hour forecast | Yes | Yes |
| Geocoding | Yes | Yes |
| Air pollution (current) | Yes | Yes |
| One Call 3.0 | 1000/day (credit card required) | Yes |
| Historical weather | No | Yes |
| Daily forecast 16-day | No | Yes |
| Climatic forecast 30-day | No | Yes |

## Notes
- All timestamps (`dt`, `sunrise`, `sunset`) are **Unix epoch seconds (UTC)**.
- `timezone` field is offset in seconds from UTC (e.g. -18000 = UTC-5).
- Default temperature unit is Kelvin. Always specify `units=metric` or `units=imperial`.
- City name queries (`q=`) can be ambiguous. Prefer `lat`+`lon` for precision, using geocoding first if needed.
- Weather icon URL pattern: `https://openweathermap.org/img/wn/{icon}@2x.png` (e.g. `01d` for clear day).
- Error responses return `{"cod": 401, "message": "Invalid API key"}` or similar.
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