SQLite Deleted Records Parser

Mari DeGrazia · also known as sqlparse; SQLite-Parser

Open sourceUnmaintained

Last commit 2015-06-22; no activity since the repository was last pushed in 2016-04.

SQLite Deleted Records Parser (sqlparse) is a Python script by Mari DeGrazia that recovers deleted entries from SQLite databases and writes them to a TSV or text file. The author's blog post says she wrote it because she saw many SQLite databases in mobile phone exams, and its documented examples use mmssms.db and smsmms.db. The repository was last changed in 2015.

Facts

Websitegithub.com
VendorMari DeGrazia
LicenceOpen source (GPL-3.0-or-later (per the licence header in sqlparse_v1.3.py; GitHub reports no licence file))
CategoryRecovery and carving
FunctionsRecovery, Parsing
TargetsAndroid, iOS
Runs onWindows, Linux, macOS
PricingFree
UsersOpen-source DFIR community, Research
Last activity2015-06 · Last commit (README typo fix, 2015-06-22); latest tagged release v.1.1 (2014-09-02) [github.com]
GitHub activitymdegrazia/SQLite-Deleted-Records-Parser · 198 stars · last push 2016-04-12 · latest release v.1.1 (2014-09-02) · checked 2026-11-10

Capabilities

  • Script to recover deleted entries in an SQLite database and place the output in a TSV file or, with -r, a text file; an optional -p switch prints re-purposed B-leaf pages. [github.com]
  • The repository ships the Python script, a command-line Windows executable and a GUI build (sqlparse_v1.3.py, sqlparse_CLI_v1.3.exe, sqlparse_GUI_1_3.zip). [github.com]
  • The author's blog post explains that leaf table b-tree pages can hold deleted data in unallocated space and freeblocks; output lists the type (allocated or freeblock), offset, length and data. [az4n6.blogspot.com]

Limitations

  • The author states she stripped tabs, white space and non-printable characters from the output to keep it readable, and that the script was tested on Python 2.6.4. [az4n6.blogspot.com]
  • The README directs help and bug reports to the author by email, the last commit is dated 2015-06-22 and the latest tagged release is v.1.1 (2014-09-02). [github.com]

Related tools

Sources

  1. SQLite-Deleted-Records-Parser repository and README (github.com)
  2. sqlparse_v1.3.py (licence header) (github.com)
  3. Another Forensics Blog: Python Parser to Recover Deleted SQLite Database Data (az4n6.blogspot.com)
  4. GitHub: mdegrazia/SQLite-Deleted-Records-Parser commits (github.com)

Reviewed . Spotted an error? See the corrections policy.