Skip to content

Tabletist Your databases, native and fast

A database client for PostgreSQL, MySQL, MariaDB, SQLite and BigQuery. Written in Rust, for Linux, macOS and Windows.

Tabletist in its macOS look: a table's data grid, the sidebar of tables on the left and the row panel on the right Tabletist in its macOS look: a table's data grid, the sidebar of tables on the left and the row panel on the right
🗄️

Four databases

PostgreSQL, MySQL (MariaDB too), SQLite and BigQuery, with the same grid, row panel and SQL editor for each.

🛡️

Careful with production

PostgreSQL, MySQL and SQLite keep read-only themselves, not a guess from the SQL. A production connection opens read-only unless you say otherwise, and a save to production asks first, with its SQL on screen.

Two looks, one app

The picture above is the macOS look, and Windows gets a close relative of it. On Linux, Tabletist takes the Omarchy look: square, keyboard first, with vim keys and the desktop’s monospace font throughout. On Omarchy it follows the desktop’s theme and recolors when you switch themes. Each system can have the other look too: Settings › Appearance › Interface switches between the classic look and the Omarchy one at once. Read about the Omarchy look and Tabletist on macOS.

Tabletist in its Omarchy look: the same table in a dark, square, keyboard-first layout with key hints along the bottom

A closer look

Review SQL open above the bar of pending changes
Read the SQL of your changes before it runs.
The question about a row that changed on the server
See what changed on the server before you decide.
The completion list in the SQL editor
Write SQL with completion for tables and columns.
The connection picker with connections tagged by environment
Keep every connection, tagged with its environment.

Quick far away, careful up close

Most of the wait on a remote database is the network. Tabletist sends what each step needs together, so on PostgreSQL, MySQL and MariaDB opening a table, loading a page, counting rows and running a read-only SELECT usually take one round trip (a MySQL table with a FLOAT column takes more). Through a network that adds 200 ms to each round trip, a table opens in about 0.2 seconds.

It is careful with what you trust it with: passwords stay in the system keyring, PostgreSQL, MySQL and SQLite keep read-only themselves, and an update installs only once its signature checks out. Read about speed and security.

Try it without a database

Start Tabletist with --demo and it opens a sample database, so you can look around before you connect to your own. Get started.

Released under the MIT License. Listed on MacPip