Repodb

---
name: repodb-query
description: >
  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, UMLS CUI, NCT ID) in RepoDB.
---

# 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`