Main Tabs

Table Structure

  • Cmd
  • 1

Table Content

  • Cmd
  • 2

Table Relations

  • Cmd
  • 3

Table Info

  • Cmd
  • 4

Custom Query

  • Cmd
  • 5

Table Triggers

  • Cmd
  • 6

General Shortcuts

New window (connection file)

  • Cmd
  • N

New tab (connection file)

  • Cmd
  • T

Add connection to favorites

  • Cmd
  • Shift
  • A

Open (connection file or SQL file)

  • Cmd
  • O

Open current connection file in new window

  • Cmd
  • Opt
  • O

Save (connection flie)

  • Cmd
  • S

Save as (connection file)

  • Cmd
  • Shift
  • S

Save query

  • Cmd
  • Ctrl
  • S

Close (connection file)

  • Cmd
  • W

Close all (connection file)

  • Cmd
  • Opt
  • W

Print

  • Cmd
  • P

Import

  • Cmd
  • Shift
  • I

Show console window

  • Cmd
  • Shift
  • K

Clear console

  • Cmd
  • K

Back in history

  • Ctrl
  • Opt
  • Left

Forward in history

  • Ctrl
  • Opt
  • Right

Select next tab

  • Ctrl
  • Tab

Select previous tab

  • Ctrl
  • Shift
  • Tab

Insert NULL value

  • Ctrl
  • Shift
  • N

Copy create table syntax

  • Cmd
  • Shift
  • C

Show create table syntax

  • Cmd
  • Opt
  • S

Refresh databases

  • Cmd
  • Shift
  • R

Choose database

  • Cmd
  • Shift
  • D

Show server variables

  • Cmd
  • Shift
  • V

Show server processes

  • Cmd
  • Opt
  • P

Refresh tables

  • Cmd
  • Ctrl
  • R

Flush privileges

  • Cmd
  • Shift
  • F

User accounts...

  • Cmd
  • U

Copy selection or selected row(s)

  • Cmd
  • C

Copy selected row(s) with column names

  • Cmd
  • Opt
  • C

Copy selected row(s) as SQL INSERT

  • Cmd
  • Opt
  • Ctrl
  • C

Show/hide toolbar

  • Cmd
  • Shift
  • T

Filter table content

  • Cmd
  • Ctrl
  • F

Filter tables

  • Cmd
  • Opt
  • Ctrl
  • F

Bundle editor

  • Cmd
  • Opt
  • Ctrl
  • B

Navigator

  • Cmd
  • Opt
  • Ctrl
  • N

Select

Select current word

  • Ctrl
  • W

Select current line

  • Ctrl
  • L

Select enclosing brackets

  • Cmd
  • Shift
  • B

Select all

  • Cmd
  • A

Table Structure Tab

Add a new field

  • Cmd
  • Opt
  • A

Delete selected field

  • Del

Duplicate selected field

  • Cmd
  • D

Refresh table structure

  • Cmd
  • R

Edit table details

  • Cmd
  • 4

Table Content Tab

Add a new row

  • Cmd
  • Opt
  • A

Delete selected row(s)

  • Del

Duplicate selected row

  • Cmd
  • D

Refresh table contents

  • Cmd
  • R

Custom Query Tab

Run all queries (1.0+) / Run current query or selection (<=0.9.9.1)

  • Cmd
  • Opt
  • R

Run current query or selection (1.0+) / Run all queries (<=0.9.9.1)

  • Cmd
  • R

Shift line or selection rightwards

  • Cmd
  • [

Shift line or selection leftwards

  • Cmd
  • ]

Toggle comment line or selection

  • Cmd
  • /

Toggle comment current query

  • Cmd
  • Opt
  • /

Spell checker completion (narrow-down list)

  • F5

Select current query

  • Ctrl
  • Y

Show MySQL help for current word or selection

  • Ctrl
  • H

Open query favorites popup menu

  • Cmd
  • Opt
  • F

Open query history popup menu

  • Cmd
  • Opt
  • Y

Insert previous history item (successively)

  • Ctrl
  • Up

Insert next history item (successively)

  • Ctrl
  • Down

Show all database names as completion list

  • Cmd
  • Opt
  • 1

Show all table and view names as completion list

  • Cmd
  • Opt
  • 2

Show all table names from current database as completion list

  • Cmd
  • Opt
  • 3