Query Apple Health SQLite database for vitals, activity, sleep, and workouts. Supports Markdown, JSON, and FHIR R4 output formats. This skill should be used when analyzing health metrics, generating health reports, answering questions about fitness or sleep patterns, or exporting health data in stan

Apple Health Data Query Skill Query and analyze health data from the local SQLite database containing 6.3M+ records across 43 health metrics. Database Location Query Methods 1. Python Script (Recommended for Common Queries) Use scripts/health query.py for pre built queries with automatic formatting: Output formats: markdown , json , fhir , ascii 2. Direct SQL (For Custom/Ad hoc Queries) For flexible queries, run SQL directly against the database. See references/schema.md for table structures and query templates. Pre built Queries Daily Health Summary Get today's key metrics: Returns: steps, calories, heart rate (avg/min/max), exercise minutes, distance, activity ring status. Weekly Trends Compare week over week performance: Returns: average daily steps, resting HR, exercise minutes, workout count per week. Sleep Analysis Analyze sleep patterns: Returns: nightly duration, sleep stages (Core, Deep, REM), average sleep hours. Latest Vitals Get most recent vital readings: Returns: Heart Rate, HRV, Resting HR, Blood Oxygen, Respiratory Rate with timestamps. Activity Rings Track ring completion: Returns: daily ring values/goals, completion percentages, perfect day count. Workout History Review exercise sessions: Returns: workout type, duration, distance, calories, summary by type. Output Formats Markdown (default) Human readable tables and lists. Best for reports and summaries. JSON Structured data for programmatic use: FHIR R4 Healthcare interoperability format. Outputs as FHIR Bundle with Observation resources using LOINC codes. See references/fhir mappings.md for code mappings. ASCII Terminal friendly output with bar charts and statistics: Common SQL Patterns For ad hoc queries, use these patterns from references/schema.md : Heart rate by hour (circadian pattern): Steps per day this month: Sleep quality (deep + REM hours): Workout summary: Record Types Available The database contains 43 health metric types including: Vitals: Heart Rate, HRV, Resting HR, Blood Oxygen, Respiratory Rate, Blood Pressure Activity: Steps, Distance, Active Calories, Basal Calories, Flights Climbed, Exercise Time, Stand Time Mobility: Walking Speed, Step Length, Walking Asymmetry, Stair Speed, Walking Steadiness Body: Weight, BMI, Body Fat % Audio: Environmental Noise, Headphone Exposure Other: VO2 Max, Time in Daylight, UV Exposure Data Coverage Records: 6.3M+ measurements Date range: 2015 10 13 to present Workouts: 1,435 sessions Sleep sessions: 40,514 records Activity days: 1,875 daily summaries Resources scripts/ health query.py Main query tool with Markdown/JSON/FHIR output references/ schema.md Database schema, record type mappings, SQL query templates fhir mappings.md LOINC codes and FHIR R4 templates Troubleshooting Database not found: Ensure ~/data/health.db exists. Run the import script from /Users/server/apple health export/ : No data for date range: Check available date range: Outlier values: Filter physiologically valid ranges (e.g., heart rate 40 200 bpm):

health-data