Desk log · 584 titles

Mac software news, brief and clear


TablePlus program icon
Mac Apps

TablePlus 6.8.0 Mac

Updated · Filed by Rosa Delgado

Download (91 MB) Earlier builds

From the photo desk

If you've spent any time in a terminal window typing SQL commands, you know the appeal of a clean graphical front end. TablePlus offers exactly that kind of relief, but with a newsroom's sense of urgency — everything is where you expect it, and nothing gets in the way of the story you're pulling from the data.

The application connects to MySQL, PostgreSQL, SQLite, and Microsoft SQL Server databases, presenting them inside a single window that can split into multiple tabs and workspaces. A script editor with built-in error reporting sits ready for writing and debugging queries, while a safe mode protects production databases from accidental writes. Keyboard shortcuts cover the common operations, keeping hands off the mouse for long stretches.

Built as a native Mac app with support for Apple Silicon, TablePlus doesn't wrap a web interface in a thin Cocoa shell. It runs directly on the metal, which shows in the responsiveness of large result sets and complex joins. The layout stays out of your way until you need it, then surfaces filters, sorting and export options without digging through menus.

The tool suits developers and analysts who manage more than one database engine and don't want to switch mental models between them. It doesn't try to be a server admin panel or a business intelligence suite. It does one thing — give you direct, fast access to your tables and queries — and leaves the rest to other tools.

Building a filtered export for weekly reporting

Suppose a support team needs a CSV of unresolved tickets from the past seven days. The workflow starts by opening a connection to the PostgreSQL instance that holds the ticketing data. In TablePlus, you'd right-click the database in the sidebar and choose "Open in New Tab" to keep other work undisturbed.

With the tab open, type a query into the script editor. Syntax highlighting marks keywords, strings and column names in different colors, so a missing comma or unbalanced quote catches the eye before you run anything:

SELECT ticket_id, customer_email, subject, status, created_at FROM tickets WHERE status != 'resolved' AND created_at > now() - INTERVAL '7 days' ORDER BY created_at DESC;

Hit ⌘R to execute. The result grid populates below. Use the column headers to check sorting — a click on the created_at column flips the order if needed. The filter row above the grid lets you narrow further, say by a keyword in the subject, without rewriting the query.

To export, click the export icon in the toolbar and choose CSV. A dialog asks for delimiters and whether to include column headers. Pick comma-delimited with headers, name the file, and save it to a shared folder. The whole sequence — connect, query, filter, export — runs under two minutes once the query is saved as a favorite in the tab's history panel.

One analyst's morning routine

A business analyst at a mid-sized e‑commerce firm starts each day checking order anomalies across two systems: a MySQL database for the web store and a SQLite file from the warehouse management tool. Before TablePlus, that meant launching two different clients and manually cross-referencing CSV dumps.

Now they open a saved workspace that restores three tabs — one for the MySQL connection, one for the SQLite file, and a scratch tab for ad‑hoc notes written as commented SQL. In the MySQL tab, a pre-saved query counts orders flagged for fraud review overnight. The SQLite tab pulls inventory levels for top-selling SKUs. A quick ⌘⇧F search across all open tabs finds any SKU that appears in both the low-inventory list and the flagged-orders list, connecting dots that previously took a separate spreadsheet session.

Safe mode stays on for the production MySQL connection by default. That means no accidental UPDATE or DELETE sneaks through while they're still on the first coffee. If they need to adjust a status, they toggle safe mode off for that tab, make the change, and toggle it back on — a deliberate step that prevents muscle-memory mistakes.

SSL errors when PostgreSQL wants TLS but the string neglects it

SSL connection failures. When a PostgreSQL server demands TLS and the connection string isn't set up for it, TablePlus throws an error rather than falling back silently. The fix is straightforward: open the connection editor, switch to the SSL tab, and enable TLS. The app uses native libraries, so certificates trusted by macOS Keychain work without extra configuration. If a self-signed certificate is in play, drop the certificate file into the connection's advanced settings and reconnect.

Large result sets slowing the grid. Pulling a million rows unfiltered can make the interface lag. The grid pages results by default, but if that setting got turned off, go to Preferences > Query and re-enable pagination. For one-off dumps, use the export button straight from the query result without waiting for the full grid to render — TablePlus streams the export in the background.

Plugin not loading after an update. A few users who rely on community drivers for less common databases such as Cassandra or Redis report that a plugin stops working after upgrading TablePlus. The remedy is to remove the old plugin from ~/Library/Application Support/TablePlus/Plugins and drop in the latest build from the developer's plugin repository. Restarting the app picks it up immediately, and the database type appears in the connection dialog again.

Tab clutter after long sessions. It's easy to end a debugging session with fifteen open tabs. Rather than closing them one by one, right-click any tab and choose "Close Other Tabs." The workspace can then be saved under a name — "March incident review" — so the exact set of connections and queries can be restored later without relying on memory.

Version
6.8.0
Download
91 MB
Developer
TablePlus Inc.
Languages
English
Activation
Included
Compatibility
macOS 12.6 or later
Architecture
Apple Silicon, Intel 64-bit

Questions readers asked

The documentation lists MySQL, PostgreSQL, SQLite, and Microsoft SQL Server, all manageable from a single interface.

Yes, the developer states that the application supports Apple Silicon chips natively.

It includes a safe mode designed to prevent accidental writes to production databases.

Letters to the desk 0

Sign in or open a desk account to write a letter.

No letters on this brief yet. They are read before they run.

More in Mac Apps

The whole section