Last Updated: September 19, 2018
· tungtono

10 features make TablePlus the best GUI Tool for MySQL, Postgres, SQLite

TablePlus is a modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis.
Came out recently and TablePlus is proving itself to be the go-to tool when it comes to GUI Tool for MySQL, PostgreSQL, SQLite and several other relational databases.

These are some highlights of TablePlus.

1. The native build.

TablePlus is a native application which was built using Swift, Objective-C, C/C++, Perl for OSX, C# for Windows and Golang for Server Side. So it takes advantage of the os features to provide fast performance and a high degree of reliability. If you compare the performance of TablePlus to that of any other tools such as Sequel Pro or Navicat or Querious, TablePlus plays the trump card.

2. Easy to use

For the new coming users, it doesn’t require much effort in learning how the app works, the design is just so intuitive and easy to use. It’s like “we know it when we see it”. TablePlus did a great job of identifying the key functions and design the app to focus on those features alone. That helps the app to run effectively without being so bulky.

Editing inline

3. Multiple drivers support

If you use Sequel Pro for MySQL, that’s a great tool. But the chances are, you have several other databases to connect to, such as PostgreSQL, SQLite or SQL Server. Then you probably need to switch to another app to get the job done. TablePlus is a one tool rules all with multiple drivers support: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis. So you can handle everything within one app.

Multiple Drivers

4. Shortcut key

For some of us, getting our hands off the keyboard for the mouse or touchpad is a trivial action and studies show that using keyboard shortcuts allows working 10 times faster than working with the mouse. TablePlus supports keyboard shortcut for every function in the app so your life would be easier with it.

5. Modern interface

It’s an inevitable fact that we prefer something beautiful over the ugly ones. It sets the mood for us. TablePlus creates a pleasant experience working with databases with a total fresh UI design pack which is clean and organized beautifully.

Open anything

6. Filter

Quickly find the records you need with the multiple filters in TablePlus. Similar to the "Group by" command, the filter allows you to gain different perspectives on the data rows you saved in your database by narrowing down the display to only those records that met the certain specified criteria. You can use multiple filters at the same time.


7. Highlight syntax

As developers, we spend most of our time looking at our code. We want the code to look legibly and beautifully. We want the same with writing SQL queries. TablePlus has its own syntax highlighting engine to make the value judgment about our code.

8. Auto-completion

Autocomplete shows the completion popup as we type, so you can fill a long word by typing a few characters, calling a function without having to remember the exact name. It’s enabled by default in TablePlus.

Auto completion

9. Code review

Requiring code review before committing to the server ensures that no change is made by accident and avoids trivial errors.

Code review

10. Dark theme

If you are spending the majority of your daytime looking at the screen, you have to consider the screen glare reduction. By going with the dark UI, you might be saving a lot of pain caused by computer vision syndrome. So, TablePlus has a built-in dark theme to please your eyes.

Dark theme

Download TablePlus for free at: TablePlus website

7 Responses
Add your response


Excellent post! thanks

5 months ago ·

MySqL is database software like Access SQL server and Oracle it commonly uses with PHP for portal and web application. https://www.assignmentland.co.uk

3 months ago ·

Thanks for input the educational subject, by the method. https://www.assignmentmojo.co.uk/

3 months ago ·

thanks for sharing it is very helpful for SQL learning

about 2 months ago ·

The post is useful. I'm also learning about this issue. Thank you.[url=https://www.123moviesuk.to/]123movies[/url]

about 1 month ago ·