← Back to Skills Marketplace
lanyasheng

Apple Health CSV

by _silhouette · GitHub ↗ · v1.0.0
cross-platform ✓ Security Clean
349
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install apple-health-csv
Description
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...
README (SKILL.md)

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
Usage Guidance
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.
Capability Analysis
Type: OpenClaw Skill Name: apple-health-csv Version: 1.0.0 The apple-health-csv skill is a legitimate tool for analyzing local Apple Health CSV exports. The Python script (health_query.py) uses standard libraries to parse data, handles complex logic like cross-midnight sleep analysis, and contains no network-reaching code, obfuscation, or unauthorized file access. The instructions in SKILL.md are consistent with the code's functionality and do not contain prompt-injection attacks.
Capability Assessment
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.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install apple-health-csv
  3. After installation, invoke the skill by name or use /apple-health-csv
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release: local CSV-based Apple Health data query with 35+ metrics, sleep analysis, JSON output, 43 unit tests
Metadata
Slug apple-health-csv
Version 1.0.0
License
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is 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... It is an AI Agent Skill for Claude Code / OpenClaw, with 349 downloads so far.

How do I install Apple Health CSV?

Run "/install apple-health-csv" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Apple Health CSV free?

Yes, Apple Health CSV is completely free (open-source). You can download, install and use it at no cost.

Which platforms does Apple Health CSV support?

Apple Health CSV is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Apple Health CSV?

It is built and maintained by _silhouette (@lanyasheng); the current version is v1.0.0.

💬 Comments