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

View on GitHub
# Google Data Commons API

## Base URL

```
https://api.datacommons.org
```

## Authentication

**API key required.** Obtain through https://apikeys.datacommons.org/.

Pass as query parameter: `&key=YOUR_KEY`

Or as header: `X-API-Key: YOUR_KEY`

All access to the base Data Commons requires a key. Custom Data Commons instances have their own base URL and do not accept the base-service key.

## Key Endpoints

### 1. Get Statistical Value (single observation)
```
GET /v2/observation
```
| Parameter    | Required | Description                                                |
|-------------|----------|------------------------------------------------------------|
| key          | Yes      | API key                                                    |
| entity.dcids | Yes     | Place DCID(s) (e.g., `country/USA`, `geoId/06`)          |
| variable.dcids| Yes    | Statistical variable DCID(s)                               |
| date         | No       | Specific date or `LATEST`                                 |
| select       | Yes       | Fields to select: `entity`, `variable`, `date`, `value`   |

Example:
```
https://api.datacommons.org/v2/observation?key=YOUR_KEY&entity.dcids=country/USA&variable.dcids=Count_Person&date=LATEST&select=entity&select=variable&select=date&select=value
```

### 2. Get Statistical Time Series
```
GET /v2/observation
```
Use same endpoint but omit `date` parameter (or set `date=''`) to get the full time series.

Example (population time series for USA):
```
https://api.datacommons.org/v2/observation?key=YOUR_KEY&entity.dcids=country/USA&variable.dcids=Count_Person&select=entity&select=variable&select=date&select=value
```

### 3. Node Info (property values of an entity)
```
GET /v2/node
```
| Parameter | Required | Description                                        |
|-----------|----------|----------------------------------------------------|
| key       | Yes      | API key                                            |
| nodes     | Yes      | DCID(s) of the node                               |
| property  | Yes      | Property expression: `->prop` (out), `<-prop` (in)|

Example (get properties of California):
```
https://api.datacommons.org/v2/node?key=YOUR_KEY&nodes=geoId/06&property=->*
```

Example (get name of a place):
```
https://api.datacommons.org/v2/node?key=YOUR_KEY&nodes=geoId/06&property=->name
```

### 4. Supported V2 operations

V2 provides `/observation`, `/node` and `/resolve`, each supporting GET and POST.
It does not expose `/v2/sparql`. For graph queries outside these operations,
consult the documented Data Commons BigQuery access.

### 5. Resolve Entities (map names/coords to DCIDs)
```
GET /v2/resolve
```
| Parameter  | Required | Description                                    |
|------------|----------|------------------------------------------------|
| key        | Yes      | API key                                        |
| nodes      | Yes      | Entity identifiers to resolve                 |
| property   | Yes      | `<-description` (name lookup) or coordinate-based |

Example (resolve by name):
```
https://api.datacommons.org/v2/resolve?key=YOUR_KEY&nodes=California&property=<-description->dcid
```

### 6. Search for statistical variables

Use `/v2/resolve` with `resolver=indicator` and `nodes` containing a natural-language
description. Resolve returns candidate DCIDs and match metadata; inspect the
candidates and variable definitions before retrieving observations.

```bash
# Illustrative authenticated request
curl --fail-with-body --get 'https://api.datacommons.org/v2/resolve' \
  -H "X-API-Key: $DATACOMMONS_API_KEY" \
  --data-urlencode 'nodes=unemployment rate' --data-urlencode 'resolver=indicator'
```

## Common DCIDs

### Places
| DCID              | Description          |
|-------------------|----------------------|
| country/USA       | United States        |
| country/GBR       | United Kingdom       |
| country/CHN       | China                |
| geoId/06          | California           |
| geoId/0667000     | San Francisco city   |
| geoId/06085       | Santa Clara County   |

### Statistical Variables
| DCID                                    | Description                    |
|-----------------------------------------|--------------------------------|
| Count_Person                            | Total population               |
| Count_Person_Employed                   | Employed persons               |
| UnemploymentRate_Person                 | Unemployment rate              |
| Median_Income_Person                    | Median income                  |
| Amount_EconomicActivity_GrossDomesticProduction_Nominal | Nominal GDP     |
| Mean_ConsumerPriceIndex                 | Consumer price index           |
| Count_Death                             | Number of deaths               |
| Count_Person_BelowPovertyLevelInThePast12Months | Persons in poverty  |
| Median_Age_Person                       | Median age                     |

## Response Format

### Observation response
```json
{
  "byVariable": {
    "Count_Person": {
      "byEntity": {
        "country/USA": {
          "orderedFacets": [
            {
              "facetId": "2176550201",
              "observations": [
                {
                  "date": "2020",
                  "value": 331449281
                },
                {
                  "date": "2021",
                  "value": 331893745
                }
              ]
            }
          ]
        }
      }
    }
  },
  "facets": {
    "2176550201": {
      "importName": "CensusACS5YearSurvey",
      "provenanceUrl": "https://www.census.gov/",
      "measurementMethod": "CensusACS5yrSurvey"
    }
  }
}
```

### Node response
```json
{
  "data": {
    "geoId/06": {
      "arcs": {
        "name": {
          "nodes": [
            {
              "value": "California"
            }
          ]
        }
      }
    }
  }
}
```

### Resolve and pagination

Resolve responses contain `entities`, each with the input `node` and a list of
`candidates`. For any paginated V2 response, repeat the same request with its
`nextToken` until no continuation token remains. Keep facet provenance with
observations; dates, units and measurement methods can differ across facets.

## Rate Limits

- Base-service requests require an API key; quota depends on the issued key.
- With API key: not formally published, but generally generous for normal use.
- Implement client-side throttling (1-2 requests/second recommended).
- Bulk data available via the Data Commons data download for large-scale analysis.

## Notes

- The V2 API (paths starting with `/v2/`) is the current recommended version.
- Older V1 endpoints (`/v1/bulk/observations/series`, `/stat/value`, etc.) still work but are deprecated.
- DCID = Data Commons Identifier. Every entity, statistical variable, and concept has a unique DCID.
- The knowledge graph includes data from US Census, World Bank, CDC, BLS, FBI, and many other sources.

Official contracts: [V2](https://docs.datacommons.org/api/rest/v2/), [resolve](https://docs.datacommons.org/api/rest/v2/resolve.html).
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