Show HN: Convert the raw HealthKit DB from an iPhone backup to SQLite

Category: devtools

Tags: healthkit, iphone-backup, sqlite, datasette, python

Score: 6.8/10 (Innovation: 6, Technical: 7, Documentation: 8, Utility: 6)

A Python tool that extracts and transforms the raw HealthKit database from an encrypted iPhone backup into a clean, queryable SQLite file, bypassing the slow on-device export. It resolves type enums, Apple-absolute timestamps, and unit normalization, making health data directly analyzable with tools like Datasette. This fills a gap for users wanting richer and faster access to HealthKit data without relying on the export.xml step.

Target audience: data engineers, backend devs, health data analysts

Repository: https://github.com/ninyawee/healthkit-from-backup-to-sqlite · Python · MIT

View on Hacker News