Back to browse
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

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

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.
Target Audience

Self-quantification enthusiasts and data analysts

Similar To

healthkit-to-sqlite · Datasette

Similar Projects