Loading repository data…
akhil-dara / repository
Single-file desktop GUI for searching, browsing, and analyzing SQLite databases. Python + tkinter. No install required.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
A fast, zero-dependency desktop GUI for searching, browsing, and forensically analyzing SQLite databases -- including hidden WAL (Write-Ahead Log) data that standard tools miss.
Built with Python and tkinter. Zero dependencies. Read-only -- your data is never modified.
Perfect for forensic investigators, developers, data analysts, and anyone who needs to quickly explore SQLite databases without writing SQL.
Most SQLite viewers choke on large databases, require SQL knowledge, or need complex installations. This tool is different:
python sqlite_gui_analyzer.py?mode=ro)Search your entire database with a single query. Results stream in live.
Browse any table with sortable columns, row filtering, and pagination.
[JPEG 1.2 KB])Tree view of every table, view, index, and trigger.
Dedicated tab for analyzing SQLite Write-Ahead Log (WAL) files at the binary level. Recovers data that standard SQLite tools cannot see.
✓ Same as DB | ≠ Different from DB | ∅ Not in DB | ★ WAL-only tableDouble-click any row for a detailed view.
Numeric values are automatically decoded in the Row Detail view:
pip install Pillowpython sqlite_gui_analyzer.py
Open a database directly:
python sqlite_gui_analyzer.py path/to/database.db
That's it. No pip install, no virtual env, no config files.
| Shortcut | Action |
|---|---|
Ctrl+O | Open database |
Ctrl+F | Focus search bar |
Enter | Start search / Open row detail |
Escape | Cancel running search |
Double-click | Open row detail / WAL record detail |
Right-click | Schema tree context menu |
One combined SQL query per table:
SELECT rowid, * FROM "table_name"
WHERE col1 LIKE ? OR col2 LIKE ? OR ... LIMIT 500
BLOB columns are excluded by default. Enable Deep BLOB mode to include them.
Two-phase approach for speed:
sre_parseLIKE '%hint%' narrows rows at the DB level before Python regexDelivers regex search in 3-5 seconds on million-row tables.
Tested with a 3.3 GB WhatsApp database (272 tables, 2.4M+ messages):
| Search Type | Example | Time |
|---|---|---|
| Case-insensitive | "hello" | ~5s |
| Email regex | [a-zA-Z0-9._%+-]+@... | ~3-5s |
| URL regex | https?://[^\s]+ | ~3-4s |
| Phone regex | \d{3}-\d{3}-\d{4} | ~4s |
Works with any valid SQLite database, including:
msgstore.db, wa.db, whatsapp_status.db).db, .sqlite, .sqlite3, or .db3 file| Language | Python 3.8+ |
| GUI | tkinter / ttk |
| DB Access | sqlite3 with URI read-only mode |
| WAL Parser | Pure binary parser with mmap |
| Architecture | Modular (8 source files), multi-threaded |
| Regex Engine | AST-based hint extraction via sre_parse |
| BLOB Detection | Signature-based (14+ formats) |
| Unicode | Full UTF-8 including emoji |
sqlite_gui_analyzer.py Entry point
src/
app.py Main application window
database.py SQLite connection and schema introspection
wal_parser.py Binary WAL file parser
dialogs.py Help, Scope, BlobViewer, RowWin dialogs
widgets.py ToolTip, TreeviewTooltip, theme setup
utils.py Utility functions, schema HTML generator
constants.py Shared constants, colors, BLOB signatures
Screenshots/
search.png Search tab
browse.png Browse tab
schema.png Schema sidebar
wal_tab.png WAL forensic analysis tab
wal-search.png WAL search results
test_data/
wal_demo.db Demo database with WAL forensic data
A demo database with WAL forensic data is included for testing:
python sqlite_gui_analyzer.py test_data/wal_demo.db
The demo includes 18 tables, views, indexes, triggers, and a WAL file with committed, uncommitted, and overwritten records -- ideal for exploring the forensic analysis features.
Will this tool modify my database?
No. The database is opened in read-only mode (?mode=ro). Your data is never changed.
Does it handle WAL mode databases? Yes. WAL databases are supported at two levels:
?mode=ro which reads committed WAL data normally..db-wal file exists. This uses a pure binary parser (not sqlite3) to read ALL WAL data including uncommitted transactions, rolled-back data, and overwritten frames that standard SQLite APIs hide.Will it destroy my WAL file?
No. The WAL file is automatically backed up (as .db-wal.bak) before any connection is opened.
Can it handle large databases? Yes. Tested on databases over 5 GB with hundreds of tables and millions of rows.
Do I need to know SQL? No. All functionality is available through the GUI.
What about encrypted databases? Standard unencrypted SQLite databases only. Encrypted databases (SQLCipher, etc.) must be decrypted first.
Contributions, bug reports, and feature requests are welcome.
MIT
Selected from shared topics, language and repository description—not editorial ratings.
serptail /
A desktop app for searching YouTube captions across channels or videos, viewing transcripts synced to a video player, downloading clips around matched timestamps, and rendering them into a single file. Also includes a CLI for scripting and automation.
71/100 healthsalmanrahman7 /
File Organizer is a lightweight, single-file desktop application built with Python. It helps you automatically declutter your workspace by sorting files into predefined categories like Images, Videos, and Documents with a single click. The simple Tkinter GUI provides an intuitive and efficient user experience.
44/100 healthPhakapholDherachaisuphakij /
A Single-File, Lightweight, and High-Performance Desktop GUI for the TruffleHog Security Scanner. Built with Python and CustomTkinter for a modern, dark-themed experience.
59/100 healthanxntbhardwaj /
A pure-Python, single-file, desktop calculator built with Tkinter (GUI) and SQLite (history storage) from the standard library. No external services, fully offline.
69/100 healthUtkarshVashist /
The uploaded file quotation.exe is a Windows desktop application developed using Python and the Tkinter GUI framework, packaged as a standalone executable with PyInstaller. It contains the Python runtime, graphical user interface components, and the application's source code bundled into a single file.
49/100 healthanxntbhardwaj /
A pure-Python, single-file, desktop To-Do List application built entirely with Tkinter (GUI) and SQLite (storage) from the standard library. It self-installs a couple of optional helper packages the first time you run it, so setup is just one command.
69/100 health