SQLite Query Analyzer

A lightweight and efficient desktop utility designed to simplify the process of managing SQLite databases

Get Started View on GitHub

$ sqlitequery --help

Usage: SQLiteQueryAnalyzer [options] database

A fast and lightweight cross-platform command line and GUI tool

for querying and manipulating SQLite databases

Options:

-e, --export-csv Export data to CSV

-r, --run-sql Execute SQL file

-p, --progress Show progress during copy

Features

🖥️

Cross Platform

Runs natively on Windows, MacOS, and Linux with full feature parity

⚡

Fast Query Execution

Easy-to-use interface for executing SQL queries with syntax highlighting

✏️

Table Data Editing

Fast table data editing with inline editing capabilities

💾

State Persistence

Persists application state and reloads last session on startup

📤

Data Export

Export database schema as CREATE TABLE statements and data as SQL scripts or CSV files

🌙

Theme Awareness

Desktop color theme awareness with automatic switching between dark/light themes

⌨️

Command Line Interface

CLI for automation and scripting with support for CSV export and SQL execution

Screenshots

See SQLite Query Analyzer in action across different platforms and themes

SQL Query Execution

Execute SQL queries with syntax highlighting and result display

Table Data Editing

Edit table data directly with an intuitive interface

Dark Mode Support

Automatic theme switching with system preferences

Native macOS Experience

Seamless integration with macOS design principles

Cross-Platform Consistency

Consistent functionality across all supported platforms

Linux Native Support

Full feature support on Linux distributions

Installation

Quick Install

Recommended

Use our automated installation scripts for the easiest way to install SQLite Query Analyzer:

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

Download from GitHub Releases

Download the appropriate binary for your platform and run directly. No installation required.

Platform-Specific Notes

Windows

The installer will add SQLite Query Analyzer to your Start Menu and create a desktop shortcut. The PowerShell install script handles everything automatically.

macOS

Download the DMG file, open it, and drag the app to your Applications folder. The install script handles this automatically.

Linux (Ubuntu/Debian)

For manual installation, you may need to install dependencies first:

sudo apt-get update
sudo apt-get install -y libqt6gui6 libqt6core6 libxkbcommon0

Then download and run the Linux binary from the releases page.

Usage

GUI Mode

                            # Open a database file in GUI mode
sqlitequery /path/to/database.db

# Or launch GUI and use File > Open to select database
                        

Command Line Mode

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

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

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

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

Ready to start managing your SQLite databases?

Download Now

Building from Source

Prerequisites

Git
CMake 3.16 or later
Qt 6.9.0 or later
qt6-base-dev (Qt6 development packages for building from source)
libxkbcommon-dev (XKB development library)
PowerShell Core (optional)

Quick Build

                            # Clone the repository
git clone https://github.com/christianhelle/sqlitequery.git
cd sqlitequery

# Build using PowerShell script (cross-platform)
cd src/project
pwsh build.ps1
                        

Manual Build

                            # Linux/macOS
cd src/project
cmake .
cmake --build . --config Release

# Windows (adjust Qt path as needed)
cmake . -DCMAKE_PREFIX_PATH=C:/Qt/6.9.0/msvc2022_64 -DCMAKE_CXX_STANDARD=17 -B build
cmake --build build --config Release
                        