FQLite

Dirk Pawlaszczyk and contributors · also known as FQLite - SQLite Forensic Toolkit

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

Websitestaff.hs-mittweida.de
VendorDirk Pawlaszczyk and contributors
LicenceOpen source (Apache-2.0)
CategoryRecovery and carving
FunctionsRecovery, Parsing, Analysis, Decoding
TargetsAndroid, iOS
Runs onWindows, macOS, Linux
PricingFree [github.com]
UsersResearch, Law enforcement, Open-source DFIR community
Last activity2026-10 · Release 5.0 (2026-10-01) [github.com]
GitHub activitypawlaszczyk/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]

Related tools

Sources

  1. FQLite README (github.com)
  2. FQLite 5.0 release (github.com)

Reviewed . Spotted an error? See the corrections policy.