repodb-query

Query the RepoDB drug repurposing database. Use whenever the user asks about drug-disease associations, drug repurposing candidates, or wants to look up any entity (drug name, indication, DrugBank ID,

SKILL.md

GitHub

RepoDB Query Skill

Search RepoDB records by any entity. Auto-detects type by prefix:

Input Pattern Detected As Match Logic
DB00584 DrugBank ID exact on drugbank_id
C0020538 UMLS CUI exact on ind_id
NCT00001234 Trial ID exact on NCT
anything else free text substring on drug_name OR ind_name

API

Function Input Returns
load_repodb(path) CSV path DataFrame
search(df, entity) single entity string DataFrame
search_batch(df, entities) list of entity strings dict[str, DataFrame]
summarize(hits, entity) DataFrame + label compact text
to_json(hits) DataFrame list[dict]

Usage

See if __name__ == "__main__" block in repodb_query.py for runnable examples covering: drug name, DrugBank ID, UMLS CUI, indication name, batch search, and JSON output.

Data

  • Source: full.csv (comma or tab separated, auto-detected)
  • Columns: drug_name, drugbank_id, ind_name, ind_id, NCT, status, phase, DetailedStatus
  • Path: DATA_PATH variable in repodb_query.py