Screenshots and features of HeidiSQL

Connection

Connection

The very first dialog which asks for hostname and credentials. The list of wanted databases can be limited and sorted alphabetically.

Ssh Tunnel

Ssh Tunnel

Establishing connections to MariaDB/MySQL servers through an SSH tunnel, using plink.exe.

Usermanager

Usermanager

Administer MariaDB/MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything.

Host Variables

Host Variables

The list of server variables. Most of them are editable by doubleclick. Filterable.

Variable Editor

Variable Editor

Editable server variables, either for session or global scope.

Host Processlist

Host Processlist

The list of currently running processes. Used to analyze executed SQL and to kill bad processes.

Host Commandstats

Host Commandstats

Graphical statistics on the amount of all different SQL commands.

Database

Database

Details about tables and views. Switchable column headers. Used to rename, delete, empty and modify tables.

Create Db

Create Db

Create, modify databases and assign a character set + collation.

Table Editor

Table Editor

Visually create and edit tables, without hiding the CREATE/ALTER TABLE query.

View Editor

View Editor

Create and modify VIEWs on newer MariaDB/MySQL servers.

Stored Routines

Stored Routines

Create and edit stored procedures and functions.

Trigger Editor

Trigger Editor

Create and modify TRIGGERs on newer MariaDB/MySQL servers.

Event Editor

Event Editor

Create and modify scheduled scripts (EVENTs).

Favorites

Favorites

Mark tables and whatever as favorites.

Unicode1

Unicode1

International character support in editors, database tree, log panel ...

Unicode2

Unicode2

... and within grids.

Copy Table

Copy Table

Create exact copies of an existing table, within the same database or in another one.

Data

Data

Table contents editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms.

Imagepreview

Imagepreview

BLOBs can contain various file formats. HeidiSQL displays JPEG, PNG, GIF, BMP, PSD and some more image formats in a quick preview box.

Grideditors

Grideditors

Grid editing using various editors for text, hex/binary, enum, set, date/time columns.

Multiresults

Multiresults

Run a batch with multiple SQL queries and get one tab per query.

Query

Query

SQL query editing: Customizable syntax highlighting, snippet files, completion proposal pulldown and editable results.

Searchreplace

Searchreplace

Find and replace text in query editors, supporting regular expressions with callbacks. This dialog also supports searching and replacing in table rows!

Open Large Files

Open Large Files

When SQL files are bigger, HeidiSQL asks you to run these without loading them as a whole into the query editor

Import Large Files

Import Large Files

Importing a large file displays a progress dialog with nice statistics details

Export Sql

Export Sql

Dump selected databases and data into a single dump file, one file per table, directly to another host, to clipboard or to another database on the same server. Nearly as fast as mysqldump!

Export Textfile

Export Textfile

Save the result of any data grid to CSV, HTML, XML, LaTeX, Wiki markup or PHP files.

Import Textfile

Import Textfile

Import CSV or delimited files produced by spread sheet applications directly into a MariaDB/MySQL table. Users which are not allowed to execute LOAD DATA can activate a client-side parser.

Insert Files

Insert Files

Read lots of files per batch into BLOBs, using macros for neighbour fields. Binary safe.

Maintenance

Maintenance

Optimize, check, analyze and repair tables by a few mouseclicks.

Find Text On Server

Find Text On Server

Find text in a table, a database or even on the whole server.

Print

Print

Send any list of tables, columns, variables etc. to your printer. Switchable columns.

Sql Help

Sql Help

Browse through the topics in MariaDB's built in help system.

Updatecheck

Updatecheck

Keeps your HeidiSQL version up to date with the latest features and bugfixes. Can be invoked automatically by option.

Sequal Suggest

Sequal Suggest

Generate SQL queries through natural language, based on the API from https://sequal.dev/

Reformat-sql

Reformat-sql

Clean up SQL code by using an internal or one of the online reformatters

Shortcut-customizer

Shortcut-customizer

Override default keyboard hotkeys with your personal preferences

Files-and-tabs-preferences

Files-and-tabs-preferences

Reopens your previously used files, and lets you finetune your mouse-click actions on tabs