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

View on GitHub
# Crystallography Open Database (COD) API

## Base URL

```
https://www.crystallography.net/cod
```

## Authentication

**None required.** COD is fully open-access with no API key needed.

## Key Endpoints

### Search by formula

```
GET /result?formula=Fe2%20O3&format=json
```

Formula format uses spaces between elements: `Fe2 O3`, `Si O2`, `C6 H12 O6`. URL-encode spaces as `%20`.

### Search by elements

```
GET /result?el1=Fe&el2=O&format=json
```

Use `el1`, `el2`, `el3`, etc. for element filters. Use `strictmin=2&strictmax=2` to restrict the number of distinct elements to exactly two. `nel1`, `nel2`, etc. exclude individual elements; they are not element counts.

### Search by cell parameters

```
GET /result?amin=5.0&amax=6.0&bmin=5.0&bmax=6.0&cmin=5.0&cmax=6.0&format=json
```

Cell parameter filters:
- `amin`, `amax` — a-axis length (Angstroms)
- `bmin`, `bmax` — b-axis length
- `cmin`, `cmax` — c-axis length
- `alpmin`, `alpmax` — alpha angle (degrees)
- `betmin`, `betmax` — beta angle
- `gamin`, `gamax` — gamma angle
- `vmin`, `vmax` — unit cell volume (A^3)

### Search by space group

```
GET /result?space_group_number=225&format=json
```

### Search by text (author, journal, title)

```
GET /result?text1=perovskite&format=json
```

### Combined search example

```
GET /result?el1=Ti&el2=O&strictmin=2&strictmax=2&space_group_number=136&format=json
```

### Retrieve a specific CIF file

```
GET /1526463.cif
```

COD IDs are 7-digit integers. Append `.cif` for the crystallographic information file, or `.html` for the web page.

### Retrieve entry metadata as JSON

```
GET /result?id=1526463&format=json
```

### Output formats

- `format=json` — JSON array of matching entries
- `format=csv` — CSV output
- `format=lst` — list of COD IDs only
- Default (no format) — HTML page

## Response Format

JSON is an array of entries; `[]` means no matching entry. The `file` string is the COD ID. Cell parameters and other numbers may also be strings, with unavailable fields null. The live `1526463` record (2026-09-30) has `sgNumber="60"`, `a="12.1005"` and formula `- Li2.78 O12 P3 V1.8 Zr0.2 -`; it is not hematite. Fetch full structural data from `https://www.crystallography.net/cod/{file}.cif`.

Use the current search form's parameter names: unknown names can be ignored and yield an unintended broad query. Formula comparison follows COD's Hill-formatted formula conventions; validate the returned formula rather than treating element presence as exact stoichiometry.

## Rate Limits

- No formal rate limits documented
- Be courteous: avoid bulk-downloading thousands of entries rapidly
- For bulk access, COD provides downloadable database dumps at https://www.crystallography.net/cod/archives/

## Notes

- COD contains published crystal structures; record the retrieved entry revision for reproducibility.
- All data is open-access under public domain / open licenses
- The search API returns metadata; use the CIF endpoint for full structural data
- Alternative access: MySQL database dumps and SVN access are available for bulk use
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