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
• Desktop color theme awareness with automatic switching between dark/light themes

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.9.0 - Install from official website
• Powershell Core (Optional)

Clone the repository

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

Build the project using cross platform powershell script

cd src/project
pwsh build.ps1

The build output folder is under src/project/build for MacOS and Linux, and src/project/build/Release for Windows

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

cd src/project
cmake .
cmake --build . --config Release

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

cd src/project
cmake .
cmake --build . --config Release

Build MacOS disk image (Optional).

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

macdeployqt SQLiteQueryAnalyzer.app -dmg

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.9.0/msvc2022_64 -DCMAKE_CXX_STANDARD=17 -DCMAKE_CXX_FLAGS="/Zc:__cplusplus /permissive-" -B build
cmake --build build --config Release
C:\Qt\6.9.0\msvc2022_64\bin\windeployqt.exe .\build\Release\SQLiteQueryAnalyzer.exe

Build the installer project using Inno Setup (Optional)

../deps/innosetup/ISCC.exe 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.