Apple Health Query Skill

Use this skill to analyze Apple Health data already synced into local SQLite by the collector.

Tools to use

• - Shell tool: run scripts/query_health.py to pull fresh JSON data.
• HTTP tool: optionally verify collector availability with /healthz before troubleshooting missing data.

Workflow

1. 1. (Optional health check) Verify collector is reachable when user reports stale/missing data:

1. 2. Query the local database via shell (preferred default):

1. 3. Adjust parameters to user intent:

1. 4. Summarize with numbers and timestamps, then give practical next steps.
2. Always include safety framing: informational only, not medical advice; suggest clinician contact for extreme/persistent readings.

Output expectations

Base your answer on the returned JSON fields:

• - generated_at, user_id, INLINECODE10
• INLINECODE11 entries with INLINECODE12
• INLINECODE13 entries with INLINECODE14

Response style guardrails

• - Cite the exact time window used (for example: “last 24 hours” and “last 7 nights”).
• Highlight notable thresholds carefully (e.g., glucose outside typical 70–180 mg/dL range).
• Tie suggestions to observed values; avoid generic advice.
• Never hardcode user IDs or DB paths—scripts/query_health.py already reads .env.

Live Heart Rate

The collector stores real-time BLE heart rate events from Wahoo HR straps (and compatible sensors) in the live_events table. Use this for workout monitoring, recent-activity check-ins, or comparing live readings against resting baseline.

Tools to use

• - Shell tool: run scripts/query_live_hr.py to pull live HR events and per-session summaries.

Workflow

1. 1. Query recent live HR events (default: last 60 minutes):

1. 2. Narrow to the last workout or a specific timeframe:

1. 3. Filter to a specific session (use a session UUID from a previous query):

1. 4. Filter to a specific device (useful when multiple sensors are paired):

Output fields

Base your answer on the returned JSON:

• - summary — aggregate stats for the queried window:

• - sessions[] — per-session breakdown with session_id, event_count, start_ts, end_ts, device_name, avg_bpm, min_bpm, INLINECODE44
• INLINECODE45 — individual readings with ts, value (BPM), session_id, seq, device_id, INLINECODE51

Guidance

• - Workout summary: report avg_bpm, max_bpm, and duration (start_ts → end_ts of the session).
• Zone coaching: map latest_zone to practical advice (e.g., elevated zone during recovery warrants attention).
• Unusual readings: flag sustained HR >150 or <40 bpm; recommend clinician contact if persistent.
• Data freshness: if count is 0, the sensor may not be paired or the session may not have started — advise the user to open the Live HR screen on their iPhone.