AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

database-lookup

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.

Original source
K-Dense-AI
License
MIT
Pinned revision
5f2bc0341354fd5590aef76a533ada1e1e5b4e62

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

Ask your assistant

Use Agentic Memory skills to read k-dense-ai--database-lookup at revision 5f2bc0341354fd5590aef76a533ada1e1e5b4e62, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 83

references/tcga-gdc.md

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)

{
  "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.