Common

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](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](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](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 | cohortid, name, createdat | | persons | Core person identity | personid, ssn, demographics | | patients | PatientSim entities | patientid, mrn, personid | | members | MemberSim entities | memberid, mbi, personid | | rxmembers | RxMemberSim entities | rxmemberid, rxid, personid |

Related Skills

• [Generation Skills](../generation/SKILL.md) - Profile and journey building
• [PopulationSim](../populationsim/SKILL.md) - Reference data and population targeting
• [NetworkSim](../networksim/SKILL.md) - Provider network modeling

---

Part of HealthSim Workspace Infrastructure

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: mark64oswald
• Source: mark64oswald/healthsim-workspace
• License: Apache-2.0

Install and usage instructions live in the source repository linked above.