HeidiSQL keyboard shortcuts


defkey.com -
3 years ago
- Shortcuts

If you frequently browse or edit databases using HeidiSQL, you may want to take advantage of these useful keyboard shortcuts.

Ctrl + N

New window

Ctrl + T

New query tab

Ctrl + F4

Close query tab

Ctrl + C


Ctrl + V

Paste from clipboard

Ctrl + X


Alt + ⬅ Backspace


Ctrl + P





Full status refresh. Get full statistics refresh on table data

Ctrl + A

Select all items or text

Ctrl + I

Invert selection

Ctrl + Alt + F

Activate filter panel


Cancel running operation

Ctrl + S

Save as text file

Ctrl + D

Database tree

Ctrl + E

Table filter

Ctrl + 1

Go to tab 1

Ctrl + 2

Go to tab 2

Ctrl + 3

Go to tab 3

Ctrl + 4

Go to tab 4

Ctrl + 5

Go to tab 5

Ctrl + ↑   Shift + C

Copy selected rows in custom format

Ctrl + ↑   Shift + F

Search selected tables for text occurences


SQL help browser

Ctrl + ↑   Shift + ⭾ Tab

Go back to previous tab

Ctrl + ⭾ Tab

Go to next tab


Delete all rows in selected table(s)


Execute SQL query

Ctrl + F9

Execute selected SQL

Ctrl + ↑   Shift + F9

Run currently focused SQL query

Ctrl + O

Load SQL file


Save SQL to a text file

Ctrl + ↑   Shift + S

Save selected text to a file

Ctrl + W

Clear query editor

Ctrl + F

Find text

Ctrl + R

Replace text


Find or replace again

Ctrl + S

Save SQL to file

Ctrl + F8

Automatically reformat disordered SQL in active editor to make it more readable


Insert row

Ctrl + Insert

Duplicate row

Ctrl + Del

Delete selected row(s)

Ctrl + ⤶ Enter



Cancel editing

Ctrl + W

Clear filter editor


Apply filter

Alt + S

Reset sorting

Ctrl + Alt + Page Down

Show next 1.000 rows

Ctrl + Alt + End

Show all rows

Ctrl + ↑   Shift + N

Set focused cell to NULL

Ctrl + F2

Insert SQL function call in this grid cell. E.g. NOW()

Alt +

Previous result tab

Alt +

Next result tab

Ctrl + N

Insert line

Ctrl + T

Delete word

Ctrl + Y

Delete line

Ctrl + ↑   Shift + Y

Delete E O L

Ctrl + Z


Ctrl + ↑   Shift + Z


Ctrl + 0

Goto marker 0...9

Ctrl + ↑   Shift + 0

Set marker 0...0

Ctrl + ↑   Shift + N

Normal select

Ctrl + ↑   Shift + C

Column select

Ctrl + ↑   Shift + L

Line select

Ctrl + ↑   Shift + B

Match bracket

Ctrl + U

Uppercase block

Ctrl + L

Lowercase block

Share this page on:

Program information

Program name: HeidiSQL HeidiSQL (Developer tools)

HeidiSQL is a tool designed for web developers using MySQL server, Microsoft SQL databases and PostgreSQL. It allows you to browse and edit data, create and edit tables, views, procedures, triggers and more.

Web page: heidisql.com

Last update: 30 Jan 2020

Shortcut count: 68

How easy to press shortcuts: 85%

Platform detected: Windows or Linux (not macOS)

Similar programs


Join our mailing list!

Your email is kept private and we don't spam.