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