K-Dense-AI/scientific-agent-skills / skills/database-lookup
database-lookup
VerifiedQueries 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.
references/tcga-gdc.md
View on GitHub# TCGA / GDC Data Portal API
## Base URL
```
https://api.gdc.cancer.gov
```
## Auth
No auth for public data. Token needed only for controlled-access downloads.
## Key Endpoints
All search endpoints accept GET or POST (POST preferred for complex filters).
| Endpoint | Description |
|----------|-------------|
| `/projects` | List/filter cancer projects (e.g. TCGA-BRCA) |
| `/cases` | Search cases (patients/samples) |
| `/files` | Search/filter files (BAM, VCF, expression) |
| `/genes` | Search gene-level data |
| `/ssms` | Search simple somatic mutations |
| `/ssm_occurrences` | Mutation occurrences across cases |
| `/files/{uuid}` | File metadata by UUID |
| `/data/{uuid}` | Download file by UUID |
## Filter Syntax (POST body)
```json
{
"filters": {
"op": "in",
"content": {"field": "cases.project.project_id", "value": ["TCGA-BRCA"]}
},
"fields": "file_id,file_name,data_type",
"format": "JSON",
"size": 10
}
```
Operators: `in`, `=`, `!=`, `>`, `<`, `>=`, `<=`, `is`, `not`, `and`, `or`
## Example Calls
```
# List projects
https://api.gdc.cancer.gov/projects?size=5&fields=project_id,name,primary_site
# BRCA1 mutations (POST)
curl -X POST https://api.gdc.cancer.gov/ssms \
-H "Content-Type: application/json" \
-d '{"filters":{"op":"in","content":{"field":"consequence.transcript.gene.symbol","value":["BRCA1"]}},"fields":"ssm_id,genomic_dna_change","size":5}'
# Cases in TCGA-LUAD
https://api.gdc.cancer.gov/cases?filters=%7B%22op%22%3A%22in%22%2C%22content%22%3A%7B%22field%22%3A%22project.project_id%22%2C%22value%22%3A%5B%22TCGA-LUAD%22%5D%7D%7D&size=3&fields=submitter_id,disease_type
```
## Pagination
`from` (offset) and `size` (limit, max 10000). Default size is 10.
## Rate Limits
No fixed metadata rate guarantee is assumed. Honor throttling, inspect `data.pagination`, and use the GDC Data Transfer Tool for large downloads. Controlled-access authorization is file-specific; a successful public metadata search does not authorize its files.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |