Most SQL tools are commercial, locked behind subscriptions, or built for Windows. The CLI alternatives are a bit clunky for complex work. This is a list of SQL UI’s that are open source, local, and work well on Linux. Predominantly web-based as they look cleaner than GUI apps. Guis on Linux rely on toolkits like GTK or Qt, which often introduce visual inconsistency, and thus not pleasant to work in.

Most of these require docker:

sudo pacman -S docker docker-compose

Web-based

Apache Superset

Open source BI alternative to Power BI/Tableau. SQL-centric via sql-lab:

git clone --depth=1  https://github.com/apache/superset.git
docker compose up --build

Visit http://localhost:8088:

username: admin
password: admin

CloudBeaver

Querybook

By pintrest

GUI

https://github.com/mgramin/awesome-db-tools#gui