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.
Searchreplace
Find and replace text in query editors, supporting regular expressions with callbacks. This dialog also supports searching and replacing in table rows!
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
Save the result of any data grid to CSV, HTML, XML, LaTeX, Wiki markup or PHP files.
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
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.
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.