mugi-query

Sql client for mysql, sqlite, postgresql, access and mssql databases

Features

Sessions
Autocompletion
Query history
Join helper
Data analysis tools: xy plot, distribution plot
Query result to sql expression converter

Screenshots

Main window

Join helper

Data import

Build

Windows

See build.bat and build-msys2.bat

Linux (Ubuntu)

# install qt6 and build tools
sudo apt install git build-essential cmake ninja-build qt6-base-dev libqt6svg6-dev libxkbcommon-dev

# build qwt
git clone https://git.code.sf.net/p/qwt/git qwt-git
cd qwt-git
qmake6
make
sudo install
cd ..

# install sql plugins
sudo apt install libqt6sql6-ibase libqt6sql6-mysql libqt6sql6-odbc libqt6sql6-psql libqt6sql6-sqlite

git clone https://github.com/mugiseyebrows/mugi-query.git
cd mugi-query
mkdir build
cd build
cmake -G Ninja ..
cmake --build .
sudo cmake --install .
cd ..
python3 desktop.py