Apple Health CSV

Query Apple Health data exported as CSV files from iOS apps like Simple Health Export or Health Auto Export. Supports 30+ health metrics including heart rate...

Security Scan

The skill is internally consistent with its purpose — it parses local Apple Health CSV exports and does not request credentials or network access — but there is a small documentation vs code mismatch to be aware of.

Purpose & Capability

Name/description match the actual behavior: the code reads Apple Health CSV exports and computes summaries for many metrics. The SKILL.md says a default data directory of ~/.openclaw/workspace-butler/health-data/, but the script's DATA_DIR default is a relative ../health-data path (or set by HEALTH_DATA_DIR). This doc-vs-code mismatch could cause confusion for less technical users.

Instruction Scope

Runtime instructions and the script keep operations local: reading CSV files from the stated data directory, parsing, grouping, and printing or emitting JSON. The instructions do not ask the agent to read arbitrary system files or transmit data externally.

Install Mechanism

No install spec is present (instruction-only). The skill ships with a Python script and tests; nothing is downloaded or installed automatically, which minimizes install-time risk.

Credentials

The SKILL.md documents an optional HEALTH_DATA_DIR env var and the code honors an env var, so environment access is minimal and proportional. There are no required credentials or secrets. Note again the default path mismatch between docs and code.

Persistence & Privilege

The skill is not always-enabled and does not request elevated or persistent platform privileges. It does not modify other skills or system-wide configuration.

Assessment

This skill appears to do what it says: it reads Apple Health CSV exports from a local folder and produces summaries, with no network calls or secret requirements. Before installing: (1) Confirm where your CSVs must live — SKILL.md mentions ~/.openclaw/workspace-butler/health-data/ but the script defaults to a relative ../health-data; you can set HEALTH_DATA_DIR to point to your files. (2) Review the included scripts yourself (they are local Python code) if you want to be sure they only access the CSV folder. (3) Run the tool on a test CSV set first to confirm output and that it reads the intended files. If you need the agent to operate autonomously, remember this skill can be invoked by the agent but it does not request any special privileges or credentials.

Apple Health CSV Skill

Query Apple Health data from CSV exports. Works with any iOS app that exports HealthKit data as CSV (Simple Health Export, Health Auto Export, etc.).

Setup

1. Export health data from your iPhone using an app like Simple Health Export (free)
2. Transfer the CSV files to your Mac (via AirDrop, iCloud, or USB)
3. Place them in the skill data directory:

# Default location (auto-detected)
~/.openclaw/workspace-butler/health-data/

# Or specify a custom path
export HEALTH_DATA_DIR="/path/to/your/csv/files"

Usage

# List available health metrics
python3 scripts/health_query.py list

# Get a comprehensive daily health summary
python3 scripts/health_query.py summary

# Query a specific metric (last 7 days by default)
python3 scripts/health_query.py query HeartRate
python3 scripts/health_query.py query StepCount --days 14
python3 scripts/health_query.py query SleepAnalysis --days 7
python3 scripts/health_query.py query OxygenSaturation --days 30

# JSON output for programmatic use
python3 scripts/health_query.py query HeartRate --days 7 --json
python3 scripts/health_query.py summary --json

Supported Metrics

Category	Metrics
Heart	HeartRate, RestingHeartRate, WalkingHeartRateAverage, HeartRateVariabilitySDNN
Activity	StepCount, ActiveEnergyBurned, BasalEnergyBurned, AppleExerciseTime, AppleStandTime, FlightsClimbed
Distance	DistanceWalkingRunning, DistanceCycling, DistanceSwimming
Vitals	OxygenSaturation, RespiratoryRate, BodyTemperature
Sleep	SleepAnalysis (with stage breakdown: REM/Core/Deep/Awake)
Body	BodyMass, BodyFatPercentage, BodyMassIndex, Height, LeanBodyMass
Walking	WalkingSpeed, WalkingStepLength, WalkingAsymmetryPercentage, WalkingDoubleSupportPercentage
Audio	EnvironmentalAudioExposure, HeadphoneAudioExposure
Performance	VO2Max, SixMinuteWalkTestDistance, AppleWalkingSteadiness
Other	DietaryWater, AppleSleepingWristTemperature

Tips for Agents

1. Start with summary to get a quick overview of today's health
2. Use --json flag when you need structured data for analysis
3. Sleep data is grouped by night (cross-midnight sessions handled correctly)
4. Blood oxygen values are auto-converted from 0-1 decimal to percentage
5. Cumulative metrics (steps, calories, exercise time) show daily totals
6. Rate metrics (heart rate, SpO2) show daily averages with min/max range