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.
Dark-mode-v13
Dark mode in v13 preview release
Linux Version Datagrid
Linux version data grid
Linux-dark
Ubuntu dark mode
Ssh Tunnel
Establishing connections to MariaDB/MySQL servers through an SSH tunnelusing plink.exe.
Usermanager
Administer MariaDB/MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything.
Macos Texteditor
macOS version data grid
Host Variables
The list of server variables. Most of them are editable by doubleclick. Filterable.
Variable Editor
Editable server variableseither 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.
Linux Fedora Mainscreen
Linux version running on Fedora
Database
Details about tables and views. Switchable column headers. Used to renamedeleteempty and modify tables.
Macos Dark
macOS dark mode
Macos Sqlexport
macOS SQL export
Create Db
Createmodify databases and assign a character set + collation.
Table Editor
Visually create and edit tableswithout hiding the CREATE/ALTER TABLE query.
View Editor
Create and modify VIEWs on newer MariaDB/MySQL servers.
Macos Proposal
macOS completion proposal
Stored Routines
Create and edit stored procedures and functions.
Trigger Editor
Create and modify TRIGGERs on newer MariaDB/MySQL servers.
Event Editor
Create and modify scheduled scripts (EVENTs).
Favorites
Mark tables and whatever as favorites.
Unicode1
International character support in editorsdatabase treelog panel ...
Unicode2
... and within grids.
Macos About
macOS About dialog
Copy Table
Create exact copies of an existing tablewithin 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 JPEGPNGGIFBMPPSD and some more image formats in a quick preview box.
Grideditors
Grid editing using various editors for texthex/binaryenumsetdate/time columns.
Multiresults
Run a batch with multiple SQL queries and get one tab per query.
Query
SQL query editing: Customizable syntax highlightingsnippet filescompletion proposal pulldown and editable results.
Searchreplace
Find and replace text in query editorssupporting regular expressions with callbacks. This dialog also supports searching and replacing in table rows!
Open Large Files
When SQL files are biggerHeidiSQL asks you to run these without loading them as a whole into the query editor
Import Large Files
Importing a large file displays a progress dialog with nice statistics details
Export Sql
Dump selected databases and data into a single dump fileone file per tabledirectly to another hostto clipboard or to another database on the same server. Nearly as fast as mysqldump!
Export Textfile
Save the result of any data grid to CSVHTMLXMLLaTeXWiki markup or PHP files.
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
Read lots of files per batch into BLOBsusing macros for neighbour fields. Binary safe.
Maintenance
Optimizecheckanalyze and repair tables by a few mouseclicks.
Find Text On Server
Find text in a tablea database or even on the whole server.
Send any list of tablescolumnsvariables etc. to your printer. Switchable columns.
Sql Help
Browse through the topics in MariaDB'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.
Reformat-sql
Clean up SQL code by using an internal or one of the online reformatters
Shortcut-customizer
Override default keyboard hotkeys with your personal preferences
Files-and-tabs-preferences
Reopens your previously used filesand lets you finetune your mouse-click actions on tabs