SQLiteBrowser
SQLiteBrowser is a visual GUI tool for creating, designing, and editing SQLite database files using a spreadsheet-like interface. It enables users to manage databases without needing to learn SQL commands.
Description
SQLite Database Browser is a QT-based visual tool for SQLite databases, intended for users and developers who want to create, edit, and search data through a familiar spreadsheet interface. It provides controls and wizards to create and compact database files, manage tables and indexes, browse and modify records, and perform searches. Additional features include importing and exporting records as text, tables to/from CSV, and databases to/from SQL dumps, as well as issuing SQL queries and examining command logs.
The tool does not require SQL knowledge and is not a shell for the sqlite command-line utility. It supports SQLite 3.x databases and is useful in scenarios like forensics, data analysis, or application development where SQLite files need inspection or modification. The light GUI editor version is invoked via the sqlitebrowser command.
How It Works
SQLiteBrowser operates as a standalone QT application providing a graphical interface for SQLite database operations. It translates user interactions in the spreadsheet-like view into underlying SQLite commands, handles database file I/O, table/index/record management, and SQL query execution without exposing raw SQL to the user unless explicitly used. It logs all issued SQL commands and supports import/export via CSV, text, and SQL dump formats.
Installation
sudo apt install sqlitebrowserFlags
Examples
sqlitebrowsersqlitebrowser example.dbsqlitebrowser /path/to/forensic.dbsqlitebrowsersqlitebrowser dump.sqlsqlitebrowser evidence.dbman sqlitebrowser