Skills
.Work. You
Rest

mimic-table-relationships

Community

Master MIMIC-IV joins for clean, linked data

Data & Analytics#clinical-research#sql-queries#mimiciv#mimic4#database-joins#data-linkage#icu-joins
Authorhannesill
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Understand MIMIC-IV table relationships, join patterns, and identifier hierarchy to ensure correct data linkage and avoid duplicates.

Core Features & Use Cases

  • Clarifies identifier hierarchy: subject_id -> hadm_id -> stay_id and core table relationships across hospital and ICU modules.
  • Guides correct join patterns to prevent duplicates and enable time-bounded analyses.
  • Use case: debugging complex queries that cross admissions and ICU stays, ensuring accurate cohort definitions.

Quick Start

Ask the AI to map a patient’s subject_id through hadm_id to stay_id to locate ICU events and link hospital and ICU data.

Dependency Matrix

Required Modules

None required

Components

Standard package

đŸ’» Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: mimic-table-relationships
Download link: https://github.com/hannesill/m4/archive/main.zip#mimic-table-relationships

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.