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.
Create Table
Visually generate and run a CREATE TABLE statement.
View Editor
Create and mofify VIEWs on newer MySQL servers.
Copy Table
Create exact copies of an existing table, within the same database or in another one.
Table
Field details of the selected table. Colorized bullets tell about indexes.
Field Editor
Modify or add fields, set datatype, default value and various flags.
Index Editor
Edit and create primary, unique, fulltext and "normal" indexes, assign fields to them.
Data
Table contents editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms.
Grideditors
Grid editing using various editors for text, hex/binary, enum, set, date/time columns.
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.
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.