SQLite DB Truncation Recovery

概要

This skill provides a comprehensive methodology for extracting data from SQLite databases that are inaccessible through standard tools due to binary truncation or header corruption. It guides users through initial file assessment, hex dump analysis, and structured binary parsing of SQLite's internal page architecture, including varint decoding and cell extraction. By following a modular, phase-based approach, it ensures maximum data recovery while minimizing errors in complex manual parsing tasks.

主な機能

• 16 GitHub stars
• Systematic binary format analysis for truncated database files
• Guidance on decoding variable-length integers (varints) and serial types
• Best practices for validating extracted data to prevent record corruption
• Structured four-phase recovery workflow from assessment to verification
• Modular parsing logic for SQLite page headers and leaf table cells

ユースケース

• Recovering data from a .db file that cannot be opened with standard SQLite libraries
• Extracting records from databases where the file has been truncated mid-operation
• Manual forensic analysis of SQLite binary data when headers are damaged or missing