WebMD Drug Reviews Query Skill

SkillDatabases & data

Query the WebMD Drug Reviews dataset (~362 k patient reviews, 2007, 2020). Use whenever the user asks about patient-reported drug effectiveness, ease of use, satisfaction ratings, side effects, or reviews for a specific drug or medical condition.

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the WebMD Drug Reviews Query Skill skill

What this skill tells your AI

The instructions your AI receives, as published by qsong-github/drugclaw in skills/drug_review/webmd/SKILL.md and read by ahel’s review.

Search patient reviews by drug name or medical condition. Auto-fallback: if no drug matches, searches conditions.

Input ExampleMatch Logic
Lipitorsubstring on Drug column
High Blood Pressuresubstring on Condition column
any texttry Drug first → fall back to Condition

API

FunctionInputReturns
load_reviews(path)CSV path (default DATA_PATH)list[dict]
search(rows, entity)single entity stringlist[dict]
search_by_drug(rows, drug)drug name stringlist[dict]
search_by_condition(rows, cond)condition stringlist[dict]
search_batch(rows, entities)list of entity stringsdict[str, list[dict]]
summarize(hits, entity)matched rows + labelcompact text (counts, avg ratings, top conditions/drugs)
to_json(hits)matched rowslist[dict]

Usage

See if __name__ == "__main__" block in 10_WebMD_Drug_Reviews.py for runnable examples covering: single drug lookup, single condition lookup, batch search, and JSON output.

Data

  • Source: webmd.csv (Kaggle – rohanharode07/webmd-drug-reviews-dataset)
  • Columns: Drug, Condition, Reviews, Side, Age, Sex, Effectiveness, EaseofUse, Satisfaction
  • Ratings: 1-5 star scale for Effectiveness, EaseofUse, Satisfaction
  • Path: DATA_PATH variable in 10_WebMD_Drug_Reviews.py (resources_metadata/drug_review/WebMDDrugReviews/webmd.csv)

Signals

GitHub stars
116
Forks
3
Last commit
Aug 2026
Advanced
Item type
skill
Key
webmd-drug-reviews
Source
github.com/qsong-github/drugclaw