TablePlus connects directly from your computer to your database server without making any interferences. It's end-to-end encrypted.
TablePlus never sends or stores any of your data to our server. Only you get access to your data, all database credentials are safely stored on your device's Keychain.
You need to prepare your database credentials including database driver, host, port, username, and password to get connected.
From the welcome screen, click
Create a new connection near the bottom
Choose the database driver and click
Configure your connection using standard properties such as like host, port, user credentials, etc.
You can choose to import from URL, copy and paste your URL. You can find and copy the URL from your server configuration.
For example, the URL for PostgreSQL will have this structure:
Beside standard properties, you can configure over SSH by entering your credentials or importing a SHH private key. TablePlus has a built-in native SSH.
When you use SSH config, you need to tick on
Use SSH key. TablePlus will use the
~/.ssh/config when you leave the private key empty.
When you create a new connection, you can assign a colour to the connection. This will help differentiate the connections, production vs staging for example.
You can change the colour by clicking on the connection status when you are connecting to it, or edit the connection form in the welcome screen.
You need to assign a tag to each connection during the creation. There are 5 current tags to use:
Normally, when you start TablePlus, it shows the welcome screen with a list of saved connections. After connecting to a database, the connection will be saved into your favourite list on the right side of the welcome screen. Double click on a saved connection to open it.
To edit a saved connection in TablePlus, right click on the connection and choose
You can config TablePlus to reopen the workspaces you were working on from the last session. To do this:
Go to TablePlus Preferences Setting (
⌘ + ,)
From General Preferences tab, tick on the option
Reopen closed workspaces at startup at the Application section.
You have to prepare the connection URL, you can get this by right clicking on a connection in TablePlus and choose
Copy as URL.
From the Terminal, run:
open "url" and hit return.
You can organize database connections into groups. For example, Project A, Project B, or Production Group, Staging group, etc.
From the welcome screen, right click and choose
Set group name and icon and save it.
To add a connection to a connection group, drag and drop it in to the group.
To remove a connection from the group, drag the connection out of the group.
To edit connection group: Right click on the group and choose
To delete connection group: Right click on the group and choose
In TablePlus, you can quickly export and import one or multiple connections using a TablePlus connection file. This can be incredibly helpful when you need to quickly share the connections between multiple devices.
You can export group name, image, connections' information into a local file:
Right click on the group and choose
Export all... to export all saved connections, or
Export this group... to export all connection within the selected connection group, or
Export this connections... to export one selected connection only.
Choose to include/exclude database passwords and server passwords in the export file.
Set a password for the export file and hit
TablePlus will export the connection information into a dump file with
You can import group name, image, connections' information from a local file:
Right click on the welcome screen, choose
Choose connection file, enter password (if required)
When connected to a database, to show the list of connection and make a switch, click on the Connections button on the top left panel, or use shortcut key
⌘ + ⇧ + K.
By default, TablePlus will ping the servers every 30 seconds to keep the connection active and avoid being disconnected. If you want to turn this off:
In the Settings/Preferences dialog (
⌘ + ,), go to General tab
Keep connection alive to disable it.