11 tips to boost your productivity with TablePlus
Tags: mysqlgui, postgresqlgui, sqlitegui, sqlservergui
Published: 2018-05-21 03:07:44

---
title: 11 tips to boost your productivity with TablePlus
published: true
description: Speed up your development by taking the most out of TablePlus app. Easier, faster and more secure working with relational databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis.
tags: MySQL gui, PostgreSQL gui, SQLite gui, SQL Server gui
---

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.

Download the app from the [official website](https://tableplus.com).


#### 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](https://thepracticaldev.s3.amazonaws.com/i/vgqxhj5gyacdccpi68ci.gif)

#### 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](https://tableplus.io/assets/images/11-tips/open-anything.gif)

#### 3. Favorite
You can quickly see the queries that you use frequently by adding them as the favorite, so you can get them with a click. You can see all your favorite queries from the Favorite tab in the left sidebar.
To add a query to favorite, select the query from the editor, right click then add to favorite.

![Favorite](https://tableplus.io/assets/images/11-tips/favorite.png)

#### 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](https://tableplus.io/assets/images/11-tips/edit-inline.gif)

#### 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. 

![Filter](https://tableplus.io/assets/images/11-tips/filter.gif)

#### 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](https://tableplus.io/assets/images/11-tips/show-column.gif)

#### 7. Multi-tabs - multiwindows
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 switch back and forth between them. 

![Multi tabs](https://tableplus.io/assets/images/11-tips/multi-tabs.gif)

#### 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](https://tableplus.io/assets/images/11-tips/code-review.png)

#### 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 Tab](https://tableplus.io/assets/images/11-tips/split-tab.png)

#### 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](https://tableplus.io/blog/2018/02/shortcut-keys.html)

#### 11. Dark theme
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. This feature is only available for the registered account only.

![Dark Theme](https://tableplus.io/assets/images/11-tips/dark-theme.png)