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)
- Transfer the CSV files to your Mac (via AirDrop, iCloud, or USB)
- Place them in the skill data directory:
CODEBLOCK0
Usage
CODEBLOCK1
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 - Use
--json flag when you need structured data for analysis - Sleep data is grouped by night (cross-midnight sessions handled correctly)
- Blood oxygen values are auto-converted from 0-1 decimal to percentage
- Cumulative metrics (steps, calories, exercise time) show daily totals
- Rate metrics (heart rate, SpO2) show daily averages with min/max range
Apple Health CSV 技能
从CSV导出文件中查询Apple Health数据。适用于任何将HealthKit数据导出为CSV格式的iOS应用（如Simple Health Export、Health Auto Export等）。
设置
- 1. 使用Simple Health Export（免费）等应用从iPhone导出健康数据
- 将CSV文件传输到Mac（通过AirDrop、iCloud或USB）
- 将文件放入技能数据目录：
bash
默认位置（自动检测）
~/.openclaw/workspace-butler/health-data/
或指定自定义路径
export HEALTH
DATADIR=/path/to/your/csv/files
使用方法
bash
列出可用的健康指标
python3 scripts/health_query.py list
获取全面的每日健康摘要
python3 scripts/health_query.py summary
查询特定指标（默认最近7天）
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格式输出，便于程序化使用
python3 scripts/health_query.py query HeartRate --days 7 --json
python3 scripts/health_query.py summary --json
支持的指标
| 类别 | 指标 |
|---|
| 心脏 | 心率、静息心率、步行平均心率、心率变异性SDNN |
| 活动 |
步数、活动能量消耗、基础能量消耗、Apple运动时间、Apple站立时间、爬楼层数 |
|
距离 | 步行跑步距离、骑行距离、游泳距离 |
|
生命体征 | 血氧饱和度、呼吸频率、体温 |
|
睡眠 | 睡眠分析（含阶段细分：快速眼动/核心/深度/清醒） |
|
身体 | 体重、体脂率、身体质量指数、身高、去脂体重 |
|
步行 | 步行速度、步长、步行不对称百分比、双足支撑百分比 |
|
音频 | 环境音频暴露、耳机音频暴露 |
|
表现 | 最大摄氧量、六分钟步行测试距离、Apple步行稳定性 |
|
其他 | 饮水量、Apple睡眠腕温 |
代理使用提示
- 1. 从summary开始，快速了解今日健康概况
- 需要结构化数据进行分析时使用--json标志
- 睡眠数据按夜晚分组（跨午夜时段已正确处理）
- 血氧值自动从0-1小数转换为百分比
- 累积指标（步数、卡路里、运动时间）显示每日总计
- 速率指标（心率、血氧饱和度）显示每日平均值及最小/最大范围
