1. Import URL

While creating a connection to the databases, if remembering username and password is a hassle for you, try this feature from TablePlus. Choose the driver, then copy and paste the database URL to import. Done!

Import URL

2. Open Anything

You can expect this feature to run as the Search Spotlight on Mac. TablePlus will search for databases, tables, views, snaps, functions. To open an item from the result list, double-click on the item or use the up arrow and down arrow key to select the item then hit enter.

Open anything

3. History & Favorite

TablePlus logs all executed queries from the query editor. You can see the log and reuse the queries by selecting from the history tab in the right sidebar.

History

To add a frequently used query to favorite, select the query from the editor or from the history, right click then add to favorite.

TablePlus supports favorite keyword binding, which you can assign a favorite query to a specific keyword and quickly call from the query editor when you need it.

Favorite

4. Inline edit

With the spreadsheet-like view, you can easily modify data using inline editing feature. The most common way is to double-click on the cell and hit enter once the edit is completed. Don’t forget to hit cmd + S to commit the change to the server.

Inline edit

5. Filter

The filter can be used to narrow down the data in your table. It will display only the certain rows that meet the criteria that you specify and hide the unwanted parts of it from the current view. You can use multiple filters all at once.

Data Filter

6. Show selected column

If data filter feature is to display a certain number of rows, this feature is to show a certain number of columns from the table and hide the rest.

Show selected columns

7. Multi-tabs - multi-windows

The chances are, you’ll be working with a lot of connections/databases/tables at the same time. So this feature will help you navigate faster without having to close and reopen each of them.

Multi Tabs

8. Code review

Afraid that you made a mistake accidentally? Code review will take care of it. Code review will log all the changes that you made and show them to you then you can make the decision whether to commit the changes to the server or discard them.

Code Review

9. Split tab

There are two approaches to this. Either you can split query editor into two screens to write and run queries separately or you can write multiple queries on the same screen then split the results into different tabs. This can be really easy to compare the results placed next to each other.

Split Tabs

10. Shortcut keys

Shortcut keys save tons of time. Period. Every functionality in TablePlus is assigned to a shortcut key so that you can get things done much faster. Learn more about the shortcut key here

11. Dark theme

This feature is available for the registered account only. If you are like most developers, working with a dark theme would help you be more focused and boost your productivity. You can enable the dark theme from the app’s preference.

Dark theme