GitHub Repository

Convert the raw HealthKit database from an iPhone backup (healthdb_secure.sqlite) into a clean, queryable SQLite file for Datasette. The backup-store companion to dogsheep/healthkit-to-sqlite.

0 starsPython

Convert the raw HealthKit DB from an iPhone backup to SQLite

Name: Convert the raw HealthKit DB from an iPhone backup to SQLite
Availability: InStock
Author: circleoncircles

by circleoncircles·Jun 17, 2026·1 point·0 comments

Visit Project View on HN

AI Analysis

●●SolidNiche GemBig Brain

Bypasses slow on-device XML export by reading healthdb_secure.sqlite directly from backups.

Strengths

•Read-only access to raw Apple store avoids slow, failure-prone on-device Health app exports.
•Normalizes Apple-absolute timestamps, enum types, and units into human-readable SQLite schema.
•Companion to Simon Willison's healthkit-to-sqlite with clear differentiation on input source.

Weaknesses

•Requires encrypted iPhone backup extraction, adding friction for non-technical users.
•Niche audience limits broader adoption beyond Dogsheep ecosystem users.