FQLite
Open sourceActive
FQLite is a Java-based, open-source tool that finds and restores deleted records in SQLite databases by examining entries marked as deleted, with a graphical interface. Its README cites a 2026 paper on AI-based SQL query generation for SQLite databases in mobile forensics and highlights support for rollback journals, WAL archives, freelist pages, unallocated space, dropped tables and SQLCipher databases, plus decoding of bplist, protobuf and Base64 cell values.
Facts
| Website | staff.hs-mittweida.de |
|---|---|
| Vendor | Dirk Pawlaszczyk and contributors |
| Licence | Open source (Apache-2.0) |
| Category | Recovery and carving |
| Functions | Recovery, Parsing, Analysis, Decoding |
| Targets | Android, iOS |
| Runs on | Windows, macOS, Linux |
| Pricing | Free [github.com] |
| Users | Research, Law enforcement, Open-source DFIR community |
| Last activity | 2026-10 · Release 5.0 (2026-10-01) [github.com] |
| GitHub activity | pawlaszczyk/fqlite · 188 stars · last push 2026-11-05 · latest release 5.2 (2026-11-05) · checked 2026-11-10 |
Capabilities
- Finds and restores deleted records in SQLite databases by examining entries marked as deleted, and can browse and recover freelist page content and records in all database pages, including unallocated space and free blocks. [github.com]
- Supports rollback journals and WAL archives, recovery of dropped tables, UTF-8/UTF-16 encodings, multibyte columns, overflow pages and SQLCipher-encrypted databases. [github.com]
- Decodes bplist, protobuf and Base64 cell values and detects BLOB types such as PNG, BMP, GIF, JPEG, TIFF, HEIC and PDF. [github.com]
- Exports recovered data to CSV/TSV, HTML, a new SQLite database and CASE/UCO JSON-LD; includes a hex viewer, an SQL analyser and PRAGMA display. [github.com]
- Since version 4.0 an optional AI assistant generates SQL from text using a locally downloaded model; a 2026 paper by the developers on AI-based SQL query generation in mobile forensics is cited in the README. [github.com]
Limitations
- The README states that with version 2.0 the support for command line mode was cancelled; the tool is operated through its graphical interface. [github.com]
- The optional AI text-to-SQL feature requires downloading a separate language model of roughly 2.3 GB to 6 GB; the models are not bundled. [github.com]
Links
Related tools
- Forensic Toolkit for SQLite · Analysis
- DB Browser for SQLite · Utilities and libraries
- Undark · Recovery and carving
- SQLite Deleted Records Parser · Recovery and carving
- iLEAPP · Artefact parsers
- ALEAPP · Artefact parsers
Sources
- FQLite README (github.com)
- FQLite 5.0 release (github.com)
Reviewed . Spotted an error? See the corrections policy.