Here is a quick review of TablePlus which is a lightweight app that all Mac users should fell in love with when it comes to querying SQL databases.

Open dialog box

I discovered this app several months ago and I never used it for real, except for testing a toy example before one of my latest course. TablePlus, in the spirit of Postico or Induction (RIP), is a minimalist frontend to MySQL where you can vizualise and query your records in just a few clicks. Although I primarily use a terminal to interact with my local SQL server (yes, I know, OVH does not allow remote connection and I’m reduced to making dump of my databases to work on them locally!), I found that TablePlus does things right. Compared to PHPMyAdmin, which I used on remote servers, TablePlus is a native and quite responsive app, which helps to focus on the data tables rather than the UI.

TablePlus works with standard SQL databases (MySQL, Postgres and SQLite) but it also supports NoSQL backends such as Redis, Cassandra, or Vertica. I only tested it with SQLite and MySQL databases.

Connectors

Below is a list of nice features, but you will probably learn more by following the online tutorial. It is possible to browse each table and edit records by double-clicking on the data cell and “comitting” the change. The SQL query editor allows to write specific SQL queries that can be sent to the database server. You can even save your query for later. There is a nice filtering option that allows to select and highlight only records that match a series of conditions. Lastly, it is as easy to import a CSV file into a given table or to export query results to CSV, JSON or SQL.

To give you an idea, here are a few screenshots that I took during my last session (on real data):

Selection SQL query

I recently noticed that their business plan has slightly evolved, otherwise it looks like a solid application for database management. I do ot know what is included in the full-featured (aka not free) version, but for ordinary use the free edition should be largely enouig to perform basic operations.