Translate Clinical Inquiries into Standard OMOP SQL
Specialized AI assistant for epidemiologists, biostatisticians, and healthcare researchers. Standardized phenotyping, ancestor concept mapping, and multi-dialect SQL generation for observational health cohorts.
Core Capabilities
Built Specifically for OHDSI Cohorts
Combines clinical domain knowledge with rigorous OMOP CDM v5.4 constraints to eliminate SQL syntax and concept mapping errors.
Standard Concept Discovery
Automatic lookup and validation against SNOMED CT, RxNorm, LOINC, and CPT4 vocabularies with concept ancestor hierarchy expansion.
Multi-Dialect Synthesis
Generates verified native SQL for Google BigQuery, PostgreSQL, Snowflake, SQL Server (T-SQL), Oracle, MySQL, Databricks, and DuckDB.
Rigorous CDM Constraints
Enforces continuous observation periods, primary diagnosis flags, washout intervals, and person-level distinct cohort identification.
Pre-Validated Phenotypes
Sample Cohort Queries
Select a pre-configured clinical cohort question to explore concept discovery and generated SQL queries.
Adult T2D Patients on Metformin
→"Find all adult patients diagnosed with Type 2 Diabetes after Jan 1, 2020 who were prescribed Metformin within 30 days."
ACE Inhibitors & Angioedema
→"Identify patients with essential hypertension who experienced angioedema within 30 days of initiating an ACE inhibitor."
HbA1c Glycemic Control
→"Count patients with at least one HbA1c measurement above 8.5% in the last 12 months, stratified by gender."
Heart Failure Inpatient Stays
→"Select heart failure patients with an inpatient hospitalization lasting more than 5 days during 2022."
Request Access
Request Clinical Evaluator Access
Join our evaluation cohort to test the SOGIRE OMOP SQL Agent against real-world observational research workflows.