Apple Health Bot

I wanted to make an Instagram post with my running stats for the year. Simple enough — except Apple Health makes it nearly impossible to get a straight answer. You can see a chart. You can tap through individual workouts. But "what was my total distance this year?" or "how does my October pace compare to July?" — forget it.

So I built a chatbot that understands Apple Health data. Export your data (Apple gives you a massive XML file), and the bot indexes it into a SQL database. Ask a question in plain English — "How many runs this year?" or "What was my average pace in November?" — and it translates that into a SQL query, runs it, and gives you the answer.

The approach is RAG over SQL. The LLM doesn't see your raw health data. It sees the schema, understands your question, generates a query, and returns the result. This keeps the context small and the answers precise — no hallucinated numbers.

I got my Instagram post. But the bot turned out to be useful beyond that — I still use it to check trends and answer questions that the Health app should answer but doesn't.