SQLite Query Analyzer

SQLite Query Analyzer is a lightweight and efficient desktop utility designed to simplify the process of managing SQLite databases.

It provides an intuitive interface for executing queries and direct table editing, making database operations seamless and straightforward.

Features

• Cross platform - Runs natively on Windows, MacOS, and Linux
• Easy-to-use interface for executing SQL queries
• Fast table data editing
• Persists application state and reloads last session on startup
• Export database schema as CREATE TABLE statements
• Export data as an SQL script containing INSERT statements or as CSV files
• Zoom the query editor and database tree independently, each with its own size, using Ctrl +/- on the focused pane or Ctrl + mouse wheel over it. The query result grid, Messages pane and Table Data grid zoom together with the query editor, and answer both gestures themselves
• Desktop color theme awareness with automatic switching between dark/light themes
• Command line interface for automation and scripting

Installation

Quick Install

Windows (PowerShell)

Invoke-RestMethod https://christianhelle.com/sqlitequery/install.ps1 | Invoke-Expression

Linux / macOS (Bash)

curl -fsSL https://christianhelle.com/sqlitequery/install.sh | bash

Download Pre-built Binaries

Pre-built binaries for all platforms are available on the GitHub Releases page.

For more detailed installation instructions, visit the Documentation Website.

CLI Usage

SQLite Query Analyzer can be used as a command line tool for automating database operations without the GUI. The application supports several command line options for exporting data, executing SQL scripts, and more.

Help Text

$ sqlitequery --help
Usage: sqlitequery [options] database
A fast and lightweight cross-platform command line and GUI tool for querying and manipulating SQLite databases

Options:
  -h, --help              Displays help on commandline options.
  --help-all              Displays help, including generic Qt options.
  -v, --version           Displays version information.
  -p, --progress          Show progress during copy
  -e, --export-csv        Export data to CSV.
  -d, --target-directory  Target directory for export.
  -r, --run-sql           Execute SQL file.

Arguments:
  database                Database file to open.

Usage Examples

Opening a database in GUI mode

sqlitequery /path/to/database.db

Exporting data to CSV files

# Export all tables to CSV files in the current directory
sqlitequery --export-csv /path/to/database.db

# Export with progress indicator
sqlitequery --export-csv --progress /path/to/database.db

# Export to a specific directory
sqlitequery --export-csv --target-directory /path/to/export/folder /path/to/database.db

Executing SQL scripts

# Execute a SQL script file against a database
sqlitequery --run-sql /path/to/script.sql /path/to/database.db

CLI Features

• Export to CSV: Export all database tables to individual CSV files
• Execute SQL Scripts: Run SQL scripts from files against a database
• Progress Reporting: Show progress indicators for long-running operations
• Flexible Output: Specify custom directories for exported files

Screenshots

Here are some screenshots of SQLite Query Analyzer in action:

Windows

MacOS

Linux (Ubuntu)

Building

Prerequisites

• Git 😄
• CMake 3.16 or later - Install from official website
• Qt 6.4.2 or later, 6.11.2 recommended - Install from official website
• Powershell Core (Optional)

Clone the repository

git clone https://github.com/christianhelle/sqlitequery.git
cd sqlitequery

Build the project

Use the Makefile on Linux and macOS, or the cross-platform PowerShell script on Windows:

# Linux / macOS
make

# Windows
pwsh build.ps1

The build output folder is under build on all platforms. On Linux, make also installs into ./linux/.

Building on Linux

Install CMAke and Qt6 and XKB

sudo apt-get update
sudo apt-get install -y cmake qt6-base-dev libxkbcommon-dev

Build project

make

Create installable packages (DEB, RPM, 7Z, ZIP, and compressed archives)

make package

Install a sqlitequery symlink to ~/.local/bin

make install

Building on MacOS

Install CMake and Qt6. It's recommended to install Qt using the official installer

brew update
brew install cmake
brew install qt@6

Build project

make

Build MacOS disk image (Optional).

There is a bug in the Homebrew distribution of Qt which causes the use of macdeployqt to fail.

make package

Building on Windows

Build the project (These instructions assumes that Qt root folder is C:\Qt)

cd src
cmake . -DCMAKE_PREFIX_PATH=C:/Qt/6.11.2/msvc2022_64 -DCMAKE_CXX_STANDARD=17 -DCMAKE_CXX_FLAGS="/Zc:__cplusplus /permissive-" -B build
cmake --build build --config Release
C:\Qt\6.11.2\msvc2022_64\bin\windeployqt.exe .\build\Release\SQLiteQueryAnalyzer.exe

Build the installer project using Inno Setup (Optional)

../deps/innosetup/ISCC.exe dist/setup.iss

Contributing

We welcome contributions to SQLite Query Analyzer! If you have any ideas, suggestions, or bug reports, please open an issue or submit a pull request on GitHub.