SQLite Deleted Records 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
| Website | github.com |
|---|---|
| Vendor | Mari DeGrazia |
| Licence | Open source (GPL-3.0-or-later (per the licence header in sqlparse_v1.3.py; GitHub reports no licence file)) |
| Category | Recovery and carving |
| Functions | Recovery, Parsing |
| Targets | Android, iOS |
| Runs on | Windows, Linux, macOS |
| Pricing | Free |
| Users | Open-source DFIR community, Research |
| Last activity | 2015-06 · Last commit (README typo fix, 2015-06-22); latest tagged release v.1.1 (2014-09-02) [github.com] |
| GitHub activity | mdegrazia/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]
Links
Related tools
- Undark · Recovery and carving
- FQLite · Recovery and carving
- Forensic Toolkit for SQLite · Analysis
- DB Browser for SQLite · Utilities and libraries
Sources
- SQLite-Deleted-Records-Parser repository and README (github.com)
- sqlparse_v1.3.py (licence header) (github.com)
- Another Forensics Blog: Python Parser to Recover Deleted SQLite Database Data (az4n6.blogspot.com)
- GitHub: mdegrazia/SQLite-Deleted-Records-Parser commits (github.com)
Reviewed . Spotted an error? See the corrections policy.