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

View on GitHub
# FRED (Federal Reserve Economic Data) API Reference

## Overview
The FRED API, provided by the Federal Reserve Bank of St. Louis, offers access to over 800,000 economic time series from 100+ sources. Covers GDP, employment, inflation, interest rates, money supply, trade, housing, and much more.

## Base URL
```
https://api.stlouisfed.org/fred
```

## Authentication
- **API Key: REQUIRED.** Register at https://fred.stlouisfed.org/docs/api/api_key.html
- Pass as query parameter: `&api_key=YOUR_KEY`

## Rate Limits
- **120 requests per minute** per API key.
- No daily limit documented, but excessive use may trigger throttling.

## Common Parameters (apply to most endpoints)
| Parameter       | Type   | Required | Default | Description |
|----------------|--------|----------|---------|-------------|
| `api_key`      | string | Yes      | -       | Your FRED API key. |
| `file_type`    | string | No       | `xml`   | Response format: `xml` or `json`. |
| `realtime_start` | string | No     | today   | Start of real-time period `YYYY-MM-DD`. |
| `realtime_end`   | string | No     | today   | End of real-time period `YYYY-MM-DD`. |

---

## Key Endpoints

### 1. Series Observations (Time Series Data)

#### `GET /fred/series/observations`
Returns the data values for an economic time series.

**Parameters:**
| Parameter           | Type   | Required | Default       | Description |
|--------------------|--------|----------|---------------|-------------|
| `series_id`        | string | Yes      | -             | FRED series ID (e.g., `GDP`, `UNRATE`, `CPIAUCSL`). |
| `observation_start`| string | No       | `1776-07-04`  | Start date `YYYY-MM-DD`. |
| `observation_end`  | string | No       | `9999-12-31`  | End date `YYYY-MM-DD`. |
| `units`            | string | No       | `lin`         | Data transformation: `lin` (levels), `chg` (change), `ch1` (change from year ago), `pch` (% change), `pc1` (% change from year ago), `pca` (compounded annual % change), `cch` (continuously compounded rate of change), `cca` (continuously compounded annual rate), `log` (natural log). |
| `frequency`        | string | No       | (native)      | Aggregation frequency: `d`, `w`, `bw`, `m`, `q`, `sa`, `a` (daily through annual). |
| `aggregation_method` | string | No    | `avg`         | `avg`, `sum`, `eop` (end of period). |
| `sort_order`       | string | No       | `asc`         | `asc` or `desc`. |
| `limit`            | int    | No       | 100000        | Max observations returned (max 100000). |
| `offset`           | int    | No       | 0             | Pagination offset. |

**Example:**
```
https://api.stlouisfed.org/fred/series/observations?series_id=GDP&api_key=YOUR_KEY&file_type=json&observation_start=2020-01-01&observation_end=2024-12-31&units=pch&frequency=q
```

**Response:**
```json
{
  "realtime_start": "2024-11-01",
  "realtime_end": "2024-11-01",
  "observation_start": "2020-01-01",
  "observation_end": "2024-12-31",
  "units": "pch",
  "output_type": 1,
  "file_type": "json",
  "order_by": "observation_date",
  "sort_order": "asc",
  "count": 20,
  "offset": 0,
  "limit": 100000,
  "observations": [
    {
      "realtime_start": "2024-11-01",
      "realtime_end": "2024-11-01",
      "date": "2020-01-01",
      "value": "-1.3"
    },
    {
      "realtime_start": "2024-11-01",
      "realtime_end": "2024-11-01",
      "date": "2020-04-01",
      "value": "-8.4"
    }
  ]
}
```

Note: `value` is always a string. Missing values appear as `"."`.

---

### 2. Series Info (Metadata)

#### `GET /fred/series`
Returns metadata for a series.

**Parameters:**
| Parameter   | Type   | Required | Description |
|------------|--------|----------|-------------|
| `series_id`| string | Yes      | FRED series ID. |

**Example:**
```
https://api.stlouisfed.org/fred/series?series_id=UNRATE&api_key=YOUR_KEY&file_type=json
```

**Response:**
```json
{
  "realtime_start": "2024-11-01",
  "realtime_end": "2024-11-01",
  "seriess": [
    {
      "id": "UNRATE",
      "title": "Unemployment Rate",
      "observation_start": "1948-01-01",
      "observation_end": "2024-10-01",
      "frequency": "Monthly",
      "frequency_short": "M",
      "units": "Percent",
      "units_short": "%",
      "seasonal_adjustment": "Seasonally Adjusted",
      "seasonal_adjustment_short": "SA",
      "last_updated": "2024-11-01 07:41:02-05",
      "popularity": 95,
      "notes": "The unemployment rate represents..."
    }
  ]
}
```

---

### 3. Series Search

#### `GET /fred/series/search`
Search for series by keywords.

**Parameters:**
| Parameter       | Type   | Required | Default        | Description |
|----------------|--------|----------|----------------|-------------|
| `search_text`  | string | Yes      | -              | Keywords to search. |
| `search_type`  | string | No       | `full_text`    | `full_text` or `series_id`. |
| `order_by`     | string | No       | `search_rank`  | `search_rank`, `series_id`, `title`, `units`, `frequency`, `seasonal_adjustment`, `realtime_start`, `realtime_end`, `last_updated`, `observation_start`, `observation_end`, `popularity`, `group_popularity`. |
| `sort_order`   | string | No       | `asc`          | `asc` or `desc`. |
| `limit`        | int    | No       | 1000           | Max results (max 1000). |
| `offset`       | int    | No       | 0              | Pagination offset. |
| `filter_variable` | string | No    | -              | `frequency`, `units`, `seasonal_adjustment`. |
| `filter_value` | string | No       | -              | Value to filter on (e.g., `Monthly`). |
| `tag_names`    | string | No       | -              | Semicolon-delimited tags to filter (e.g., `gdp;quarterly`). |

**Example:**
```
https://api.stlouisfed.org/fred/series/search?search_text=consumer+price+index&api_key=YOUR_KEY&file_type=json&limit=5
```

**Response:**
```json
{
  "realtime_start": "2024-11-01",
  "realtime_end": "2024-11-01",
  "order_by": "search_rank",
  "sort_order": "asc",
  "count": 1256,
  "offset": 0,
  "limit": 5,
  "seriess": [
    {
      "id": "CPIAUCSL",
      "title": "Consumer Price Index for All Urban Consumers: All Items in U.S. City Average",
      "observation_start": "1947-01-01",
      "observation_end": "2024-09-01",
      "frequency": "Monthly",
      "units": "Index 1982-1984=100",
      "seasonal_adjustment": "Seasonally Adjusted",
      "popularity": 95
    }
  ]
}
```

---

### 4. Category Lookup

#### `GET /fred/category`
Get info for a specific category.

**Parameters:**
| Parameter    | Type | Required | Description |
|-------------|------|----------|-------------|
| `category_id`| int | Yes      | Category ID (0 = root). |

**Example:**
```
https://api.stlouisfed.org/fred/category?category_id=0&api_key=YOUR_KEY&file_type=json
```

#### `GET /fred/category/children`
Get child categories.

**Example:**
```
https://api.stlouisfed.org/fred/category/children?category_id=0&api_key=YOUR_KEY&file_type=json
```

#### `GET /fred/category/series`
Get all series in a category.

**Parameters:**
| Parameter    | Type | Required | Description |
|-------------|------|----------|-------------|
| `category_id`| int | Yes      | Category ID. |
| `limit`     | int  | No       | Max results (max 1000). |
| `offset`    | int  | No       | Pagination offset. |

**Example:**
```
https://api.stlouisfed.org/fred/category/series?category_id=125&api_key=YOUR_KEY&file_type=json
```

---

### 5. Releases

#### `GET /fred/releases`
Get all economic data releases.

**Example:**
```
https://api.stlouisfed.org/fred/releases?api_key=YOUR_KEY&file_type=json
```

#### `GET /fred/release/series`
Get all series in a specific release.

**Parameters:**
| Parameter   | Type | Required | Description |
|------------|------|----------|-------------|
| `release_id`| int | Yes      | Release ID. |

**Example:**
```
https://api.stlouisfed.org/fred/release/series?release_id=53&api_key=YOUR_KEY&file_type=json
```

---

### 6. Tags

#### `GET /fred/tags`
Get all tags and their frequency of use.

#### `GET /fred/series/search/tags`
Get tags matching a series search.

**Example:**
```
https://api.stlouisfed.org/fred/series/search/tags?series_search_text=mortgage+rate&api_key=YOUR_KEY&file_type=json
```

---

## Commonly Used Series IDs

| Series ID     | Description |
|--------------|-------------|
| `GDP`        | Gross Domestic Product (quarterly, billions $) |
| `GDPC1`     | Real GDP (chained 2017 dollars) |
| `A191RL1Q225SBEA` | Real GDP growth rate (annualized quarterly) |
| `UNRATE`    | Unemployment Rate (monthly, %) |
| `PAYEMS`    | Total Nonfarm Payrolls (monthly, thousands) |
| `CPIAUCSL`  | CPI All Urban Consumers (monthly, index) |
| `CPILFESL`  | Core CPI (excl. food & energy) |
| `PCEPI`     | PCE Price Index |
| `PCEPILFE`  | Core PCE Price Index |
| `FEDFUNDS`  | Federal Funds Effective Rate (monthly, %) |
| `DFF`       | Federal Funds Effective Rate (daily) |
| `DGS10`     | 10-Year Treasury Constant Maturity Rate (daily) |
| `DGS2`      | 2-Year Treasury Rate (daily) |
| `T10Y2Y`    | 10Y-2Y Treasury Spread |
| `MORTGAGE30US` | 30-Year Fixed Mortgage Rate (weekly) |
| `M2SL`      | M2 Money Stock (monthly) |
| `HOUST`     | Housing Starts (monthly, thousands) |
| `RSAFS`     | Retail Sales (monthly, millions $) |
| `INDPRO`    | Industrial Production Index |
| `UMCSENT`   | U. of Michigan Consumer Sentiment |
| `SP500`     | S&P 500 Index (daily) |
| `VIXCLS`    | CBOE Volatility Index (daily) |
| `DEXUSEU`   | USD/EUR Exchange Rate (daily) |
| `DCOILWTICO`| WTI Crude Oil Price (daily) |
| `BOPGSTB`   | Trade Balance (monthly, millions $) |
| `GFDEBTN`   | Federal Debt Total Public Debt |

## Notes
- Real-time periods: FRED supports vintage data. The `realtime_start`/`realtime_end` parameters let you retrieve data as it was known at a specific point in time (useful for analyzing data revisions).
- The `units` parameter for transformations is very powerful -- it avoids having to compute percent changes client-side.
- Values are returned as strings; `"."` means missing/unavailable.
- For FRED bulk data, they offer a download API at `https://api.stlouisfed.org/geofred/` for geographic/regional data.
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