---

name: common description: Cross-product infrastructure for HealthSim — persistence (cohort save/load), identity correlation (SSN-based cross-product linking), and DuckDB database operations. Use when saving/loading cohorts, linking entities across products, or querying the database directly.

Common Skills - Master Reference

Cross-product infrastructure skills that enable persistence, identity correlation, and database operations across all HealthSim products.

Quick Start

# Save your current work
Save this cohort as "demo-patients"

# Load previous work
Load the cohort named "demo-patients"

# Find related entities
Find the member record for patient MRN-12345

# Query the database
Show me all cohorts created in the last week

Core Capabilities

State Management

Persist generated data across sessions with cohort save/load operations. Supports auto-persist for token-efficient batch generation.

Triggers: save, load, persist, resume, snapshot, restore Details: state-management.md

Identity Correlation

Link entities across products using SSN as the universal correlator. Track the same person as patient, member, rx member, and trial subject.

Triggers: find member, link patient, correlate, same person, cross-reference Details: identity-correlation.md

DuckDB Operations

Direct database access for advanced queries, schema exploration, and reference data access.

Triggers: query, SQL, schema, database, show tables Details: duckdb-skill.md

Cross-Product Architecture

Common skills enable data flow between products:

┌─────────────┐    ┌─────────────┐    ┌─────────────┐
│  PatientSim │    │  MemberSim  │    │ RxMemberSim │
│   (MRN)     │    │   (MBI)     │    │  (RxID)     │
└──────┬──────┘    └──────┬──────┘    └──────┬──────┘
       │                  │                  │
       └────────┬─────────┴─────────┬────────┘
                │                   │
         ┌──────▼───────┐   ┌───────▼──────┐
         │  Identity    │   │    State     │
         │ Correlation  │   │  Management  │
         │   (SSN)      │   │  (Cohorts)   │
         └──────────────┘   └──────────────┘
                │                   │
                └─────────┬─────────┘
                          │
                   ┌──────▼──────┐
                   │   DuckDB    │
                   │  Database   │
                   └─────────────┘

Database Schema

Common skills work with these core tables:

Table	Purpose	Key Columns
cohorts	Saved cohort metadata	cohort_id, name, created_at
persons	Core person identity	person_id, ssn, demographics
patients	PatientSim entities	patient_id, mrn, person_id
members	MemberSim entities	member_id, mbi, person_id
rx_members	RxMemberSim entities	rx_member_id, rx_id, person_id

Related Skills

• Generation Skills - Profile and journey building
• PopulationSim - Reference data and population targeting
• NetworkSim - Provider network modeling

---

Part of HealthSim Workspace Infrastructure