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

ClinicalTrials.gov (v2 API)

Base URL

https://clinicaltrials.gov/api/v2/

Auth

No API key required. Fully public.

Key Endpoints

API version and data freshness

GET /version

Check dataTimestamp before time-sensitive retrievals to confirm the daily refresh has completed. ClinicalTrials.gov notes that data is generally refreshed Monday through Friday by 9 a.m. ET / 14:00 UTC.

ClinicalTrials.gov modernized its data ingest on August 26, 2025. For reproducible comparisons against older exports, note that some rich text markup fields and location/geopoint data may differ from the legacy pipeline.

Search studies

GET /studies

Key parameters:

  • query.cond — condition/disease (e.g. breast cancer)
  • query.intr — intervention/treatment (e.g. pembrolizumab)
  • query.term — general search terms
  • query.spons — sponsor
  • query.id — NCT ID
  • filter.overallStatus — pipe-delimited: RECRUITING|COMPLETED|ACTIVE_NOT_RECRUITING|...
  • filter.advanced — Essie expression, e.g. AREA[Phase]PHASE3; there is no filter.phase parameter
  • filter.geo — distance(lat,lon,dist) e.g. distance(38.89,-77.03,50mi)
  • fields — comma-separated field list to reduce payload
  • sort — e.g. LastUpdatePostDate:desc
  • pageSize — results per page (default 10, max 1000)
  • pageToken — cursor for next page (from nextPageToken in response)
  • countTotal=true — include total count

Example — recruiting Phase 3 breast cancer trials:

/studies?query.cond=breast+cancer&filter.overallStatus=RECRUITING&filter.advanced=AREA%5BPhase%5DPHASE3&pageSize=5&countTotal=true

Response structure:

{
  "totalCount": 1234,
  "studies": [
    {
      "protocolSection": {
        "identificationModule": {"nctId": "NCT05123456", "briefTitle": "..."},
        "statusModule": {"overallStatus": "RECRUITING"},
        "designModule": {"phases": ["PHASE3"], "enrollmentInfo": {"count": 500}},
        "conditionsModule": {"conditions": ["Breast Cancer"]},
        "eligibilityModule": {"minimumAge": "18 Years", "sex": "ALL"}
      }
    }
  ],
  "nextPageToken": "CAYQAg"
}

Single study by NCT ID

GET /studies/{nctId}

Example: /studies/NCT05123456

Study count

GET /studies?query.cond={condition}&filter.overallStatus=RECRUITING&pageSize=1&countTotal=true

Read totalCount from the first response. /stats/size accepts no search parameters and reports registry-wide statistics, not a filtered count.

Field metadata

GET /studies/metadata

Pagination

Uses cursor-based pagination via pageToken (NOT numeric offsets). Include countTotal=true on first request to get total.

Rate Limits

No API key. Be reasonable — a few requests per second.

Bulk download

Prefer the v2 /studies API with pageToken pagination for programmatic retrieval. The former bulk URL https://clinicaltrials.gov/AllAPIJSON.zip returns 404 and must not be used.

For a full-registry XML dump, use:

https://clinicaltrials.gov/AllPublicXML.zip

That path redirects to https://clinicaltrials.gov/api/legacy/public-xml?format=zip and returns Content-Type: application/zip (ctg-public-xml.zip). Confirm the redirect still yields a zip before large downloads; CSV / pipe-delimited export options are documented under ClinicalTrials.gov Data API “Download” pages when XML is not appropriate.