| name | cdw-query-cohorts |
| description | Systematically build and refine patient cohorts from CDW clinical data |
Use this skill when the user wants to identify a group of patients based on
clinical criteria (diagnoses, medications, lab results, procedures, encounter types).
When to activate
- User mentions "cohort", "patient population", "inclusion criteria", "exclusion criteria"
- User asks to find patients with specific conditions, treatments, or clinical characteristics
Approach
- Clarify the clinical definition of the cohort with the user
- Use
CDW-get_available_tables to identify relevant tables
- Use
CDW-explore_table_schema on candidate tables
- Build an initial SQL query and validate with
CDW-execute_cdw_query
- Iterate based on row counts and user feedback
- Present the final cohort size and sample records
Notes
- All queries are read-only against de-identified data
- Prefer date range filters to keep queries fast
- Always show the patient count before presenting full results