host
, port
, username
, and password
to get connected.database username
and password
are stored securely in your Keychain. We never sync any of your data to our server.Create a New Connection
at the bottom, or right-click on the connection view and choose New
.Create
⌘ + P
, including database, table, schema, view, function…Space
.Commit
icon near the top left segment panel or use ⌘ + S
to commit the changes to the database.⌘ + S
.⌘ + Return
(or ⌘ + E
) to open query editor. TablePlus will open the editor with the most recent script. SQL Query features.Run All
button, or use ⌘ + Enter
, and TablePlus will execute all the SQL code in the editor.Run Current
from the dropdown near Run All
, Tableplus will only run the statement under the cursor.New Table
, or you can use + Table
button near the bottom left to create a new table.Commit
icon near the top left segment panel or use ⌘ + S
to commit the changes to the database.Column
button at the bottom of the workspace window and choose which columns to show.⌘ + F
Each filter contains there simple boxes:equal
, contain
, IS NULL
,…File > Import CSV
from the menu barImport CSV
Command + R
to reload current workspace.Export Table
. Note that if you right-click on the data browser view, it will export only the current page of results, not the whole table.