Screenshots and features of HeidiSQL

Connection

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

Usermanager

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

Host Variables

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

Variable Editor

Editable server variables, either for session or global scope.

Host Processlist

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

Host Commandstats

Graphical statistics on the amount of all different SQL commands.

Database

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

Create Db

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

Table Editor

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

View Editor

Create and mofify VIEWs on newer MySQL servers.

Stored Routines

Create and edit stored procedures and functions.

Trigger Editor

Create and mofify TRIGGERs on newer MySQL servers.

Event Editor

Create and mofify scheduled scripts (EVENTs).

Unicode1

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

Unicode2

... and within grids.

Copy Table

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

Data

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

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

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

Multiresults

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

Query

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

Export Sql

Pump database structures and data into a single dump file, one file per table or directly to another host.

Export Textfile

Save the result of any data grid to CSV, HTML and XML files.

Import Textfile

Import CSV or delimited files produced by spread sheet applications directly into a MySQL table.

Insert Files

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

Maintenance

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

Find Text On Server

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

Print

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

Sql Help

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

Updatecheck

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