distal-attribute
distal-attribute
distal-attribute
distal-attribute

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 MySQL servers through an SSH tunnel, using plink.exe.

Usermanager

Usermanager

Administer 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 mofify VIEWs on newer MySQL servers.

Stored Routines

Stored Routines

Create and edit stored procedures and functions.


Trigger Editor

Trigger Editor

Create and mofify TRIGGERs on newer MySQL servers.

Event Editor

Event Editor

Create and mofify 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 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 MySQL'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.