Free & Open Source SQL Client

Desktop SQL client for Windows, macOS and Linux. Edit results and review the generated SQL before applying the changes.

Version
0.4.2
License
MIT or Apache-2.0
Databases
PostgreSQL, MySQL, MariaDB
Systems
Windows, macOS, Linux
Rowly DB in light theme: schema explorer, SQL files, a query in the editor and its result grid Rowly DB in dark theme: schema explorer, SQL files, a query in the editor and its result grid

Edit results, read the SQL, then apply

Changes made in the result grid are not written right away. Rowly DB turns them into statements and shows them first.

  • DELETE removed rows
  • UPDATE edited cells
  • INSERT new rows
  1. Edit in the grid

    Change cells, add rows with Ctrl I, mark rows with Ctrl Delete.

  2. Review the statements

    Each change becomes an INSERT, UPDATE or DELETE you can read before it runs.

  3. Apply

    The statements run together. If one fails, none is applied. On production connections, every write asks for confirmation.

Result grid with an edited email, a row marked for deletion and two new rows Result grid with an edited email, a row marked for deletion and two new rows
Pending edits stay marked in the grid.
Pending changes dialog listing one DELETE, one UPDATE and two INSERT statements Pending changes dialog listing one DELETE, one UPDATE and two INSERT statements
The same four edits as SQL, before anything is written.

An editor that reads your schema

Suggestions and warnings come from the tables, columns and foreign keys of the connected database.

  • Ctrl Enter runs the statement under the cursor
  • Ctrl L formats the SQL
Autocomplete offering a JOIN to customers with its ON condition from the foreign key Autocomplete offering a JOIN to customers with its ON condition from the foreign key

Joins from foreign keys

Tables, columns and complete JOIN conditions.

A misspelled column marked in the editor with the suggestion to change it to email A misspelled column marked in the editor with the suggestion to change it to email

Unknown names, marked

With the likely name. Alt Enter applies it.

Consoles, results and a terminal

Put consoles and result tabs side by side, and open a shell in the connection's SQL folder.

Two SQL consoles side by side above two result grids side by side Two SQL consoles side by side above two result grids side by side

Mosaic

Ctrl Alt M tiles the next console or result tab; Ctrl Alt W merges it back.

Integrated terminal running git log and ls in the folder of the connection's SQL files Integrated terminal running git log and ls in the folder of the connection's SQL files

Terminal

Ctrl T opens your shell in the folder of your .sql files, for git or migration tools.

Also included

The everyday parts of a SQL client.

Export
TSV, CSV, JSON, Markdown, SQL INSERT
Query history
Ctrl H
SQL files
A folder per connection, saved with Ctrl S
Column filters
Run on the server, so paging and counts follow them
Parameters
Asked for before the query runs
Passwords
In the system keyring
Connections
TLS with certificate verification
Themes
8 families, light and dark
Languages
English, Español, Português, Français, Deutsch
Shortcuts
All listed with F1, and rebindable
Updates
From Settings, as signed packages
Account
None needed

Supported databases

Each release listed passes the full SQL test matrix against a real server in CI. Other releases connect and are marked as unverified.

EngineVerified releasesVersion lines
MySQL8.0.46, 8.4.11, 9.7.25.7, 8.0, 8.4, 9
MariaDB10.6.28, 11.8.910.3, 10.6, 11.7
PostgreSQL13.23, 14.24, 15.19, 16.15, 17.11, 18.610, 11, 12, 14, 15, 16, 17, 18

Download

macOS

Your system

Apple menu → About This Mac shows your chip.

Not notarized by Apple, so macOS blocks the first launch. Open System Settings → Privacy & Security and choose Open Anyway.

Install from the terminal (Linux)

Debian, Ubuntu (apt)

curl -LO https://github.com/anderson-andres-dev/rowly-db/releases/download/v0.4.2/Rowly.DB_0.4.2_amd64.deb
sudo apt install ./Rowly.DB_0.4.2_amd64.deb

apt installs the libraries it needs.

Fedora (dnf)

sudo dnf install https://github.com/anderson-andres-dev/rowly-db/releases/download/v0.4.2/Rowly.DB-0.4.2-1.x86_64.rpm

dnf downloads the package and its dependencies.

Arch Linux (pacman)

curl -LO https://github.com/anderson-andres-dev/rowly-db/releases/download/v0.4.2/rowly-db_0.4.2_x86_64.pkg.tar.zst
sudo pacman -U ./rowly-db_0.4.2_x86_64.pkg.tar.zst

pacman installs the libraries it needs.

AppImage

curl -LO https://github.com/anderson-andres-dev/rowly-db/releases/download/v0.4.2/Rowly.DB_0.4.2_amd64.AppImage
chmod +x Rowly.DB_0.4.2_amd64.AppImage
./Rowly.DB_0.4.2_amd64.AppImage

Nothing to install. Keep the file wherever you want to run it from.

Already installed? New versions arrive in Settings → Updates, and update packages are signed. You can also build it from source.

Open source, on GitHub

Dual licensed MIT or Apache-2.0. No account, no paid edition.

Questions

Is it free?

Yes. No account, no paid edition, and the source is public under MIT or Apache-2.0.

Why does my system warn about the installer?

The Windows installer is not code-signed and the macOS app is not notarized, so SmartScreen or Gatekeeper may stop the first launch. The steps to continue are next to each download.

How do updates work?

New versions appear in Settings → Updates and install when you choose. Update packages are signed.

Which databases does it support?

PostgreSQL, MySQL and MariaDB. New engines are tested against real servers before they are listed.