kackerx/sqlmux: A tmux-style terminal database client with Vim keybindings for PostgreSQL, MySQL, Redis, and more.

If you live in tmux and vim,
your database client should too.

Made for people like you, by one of you.

Watch the 68-second tour (MP4): a SQLite table, the palette and quick SQL, split panes and sessions, Redis keys and the console.

Install

brew install kackerx/tap/sqlmux

| | | |---|---| | Homebrew (macOS, Linux) | brew install kackerx/tap/sqlmux | | npm (no Go needed) | npm install -g sqlmux, or npx sqlmux to try it | | Go 1.26+ | go install github.com/kackerx/sqlmux/cmd/sqlmux@latest | | Binaries | macOS and Linux, amd64 and arm64, on the Releases page, with checksums.txt |

The icons come from a Nerd Font. Without one they show up as boxes: put icons = "ascii" in ~/.config/sqlmux/config.toml.

Then open something:

sqlmux ./app.db                                       # a SQLite file
sqlmux "postgres://me@localhost:5432/app?sslmode=disable"   # or mysql://…
sqlmux                                                # no connections yet: a form to add one

The quickstart goes from here to editing your first row.

Features

• tmux inside. Sessions, windows, split panes and tabs, with SPC as the leader (SPC % splits, SPC c opens a window, SPC s lists sessions). Each session sees all your connections. The layout you quit from comes back next time, and you can save named layouts.
• Edit tables in place. Change cells, add and delete rows, then C-s saves everything in one transaction. Enum, boolean and time columns get pickers; long text and JSON open in a value editor.
• Table tabs. A WHERE input with completion, history and favorites; multi-column ORDER, LIMIT, paging, a column picker, transpose, filter by a cell's value, export to CSV or JSON.
• A vim editor for SQL, diff-tested against nvim: operators and text objects, VISUAL and block selection, registers, search, :s, formatting with gq. Results go to a bottom pane, one tab per query, which you can pin.
• Completion and signature hints. Tables, columns, keywords and functions as you type, with fuzzy matching; enum values where a value goes; a line above the cursor that says which column the value you are typing is for.
• Command palette (C-p) for every command, table, tab, window and session, with a DDL preview. Quick SQL (;) runs a one-off statement from anywhere.
• JSON view (gj) of a table page or a result, read-only with vim movement and search.
• Redis: a tree of databases, namespaces and keys read with SCAN; each key (string, hash, list, set, zset, stream, RedisJSON) as an editable table; a console with completion and signatures from the server's COMMAND DOCS. See Redis.
• Every key can be rebound, per pane type, plus vim-style maps (J = "5j"). vim = false gives plain editors and arrow keys.
• Passwords from the OS keychain, a command (pass, op, …) or an environment variable; SSH tunnels through ~/.ssh/config; read-only connections; manual transactions; themes; Nerd Font or ASCII icons; English or Chinese UI.

Safety

sqlmux edits live databases, so it has guards against mistakes. They are not a permission boundary: for production data, connect with a read-only database account.

• Read-only connections (read_only = true) are enforced twice. sqlmux refuses a whole run if any statement in it writes or would lift read-only, and the session is read-only on the server too (PostgreSQL default_transaction_read_only = on, MySQL SET SESSION TRANSACTION READ ONLY). Redis has no server-side switch, so there it is sqlmux's check alone, based on the server's COMMAND INFO; use ACLs (-@write) to really restrict it.
• Dangerous statements ask first: DELETE or UPDATE without WHERE, TRUNCATE, DROP, and Redis commands the server marks @dangerous (confirm_dangerous, on by default).
• Saves are one transaction, and each UPDATE carries the old values of the cells you changed: if someone changed that row after you loaded it, the save rolls back and names the row.
• Preview before save: C-s first shows the exact statements, values inlined, with the counts of changed, added and deleted rows ([grid] preview_save, on by default).
• Production connections (production = true) are drawn in a warning color, ask before every write (even with confirm_dangerous off; the save preview cannot be turned off there), and are read-only unless you also write read_only = false.
• No silent re-runs: after a dropped connection, a statement that may have reached the server is never re-run on its own; only requests that never left are retried.
• Tested on real databases: the integration tests run in CI against PostgreSQL 17, MySQL 8.4, SQLite and Redis Stack 7.4, not mocks.

Keys and configuration

• Keys: every action and its default keys. sqlmux keys prints the same list, and ? in any pane shows the keys that work there.
• Configuration: config.toml, connections.toml, keymaps.toml, themes and layouts. sqlmux keys --format toml writes a complete keymaps.toml to start from.
• Changelog: what changed in each version, and how to migrate. sqlmux is 0.x, so a minor version can change keys or config.

Build from source

With Go 1.26+ and just: just build puts the binary in bin/, and just --list shows the tests, lint and the sample databases (just db-up starts PostgreSQL and MySQL with sample data in Docker). Without just:

go build -o bin/sqlmux ./cmd/sqlmux

Built with Bubble Tea v2. The design notes are in specs/ (in Chinese).

License

MIT