HeidiSQL versions

Connects to various SQL-based engines and manages their content
May 13, 2023
Apr 13, 2022
Review
Jun 1, 2021
Review
Jan 24, 2021
Review
Mar 19, 2020
Review
Apr 22, 2020
Review
Dec 13, 2019
Review
Jun 17, 2019
Review
9.5
Dec 30, 2017
Editorial review
rating
9.4
Oct 23, 2016
Review
9.3
Aug 10, 2015
Review
9.2
May 2, 2015
Review
9.1
Nov 14, 2014
Review
8.3
Jan 27, 2014
Review
8.2
Dec 17, 2013
8.1
Oct 3, 2013
Review
8.0
May 19, 2013
Review
7.0
Feb 12, 2012
Review
6.0
Nov 21, 2010
Review
5.1
Apr 15, 2010
4.0
Nov 29, 2008
Nov 2, 2008
3.2
Mar 2, 2008
May 20, 2010
3.1
Jul 26, 2008
3.0
Mar 1, 2008
Jul 26, 2008
1.0
Jan 21, 2015
Review

What's new

v12.0 [Apr 13, 2022]
3rd party updates:
- Update SQLite libraries to v3.38.0.
- Update VirtualTrees component source to v7.6.1.
- Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode).
- Update libmariadb.dll and plugins to current stable versions.
New stuff:.
- Experimental support for high DPI in default Windows theme/style.
- Experimental support for Interbase and Firebird connections (issue #1169).
- Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (issue #362).
- SQL export: add new menu item "Copy mysqldump command line" in "Options".
- Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini.
- Create editor commands for moving line up/down (Alt Up, Alt Down, "Edit" menu).
- Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285).
- New context menu items "Close query tabs to the right", and "Close all query tabs" (issue #710).
- New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360).
- New grid export format: SQL UPDATEs (issue #125).
- New grid export format: Jira Textile (issue #1013).
- Empty-tables-confirmation supports disabling foreign key checks (issue #1491).
- Support renaming SQLite tables in database tab (#1427).
- Editor highlights all occurrences of selected word, similar to Notepad (issue #670).
Bugfixes and enhancements:.
- Loading an sql file does not activate its tab, e.g. when loading multiple files. Fix crash happening when active tab is not a query tab in such cases..
- Remove closing PHP tag from export as PHP array.
- Performance enhancement with many opened query tabs.
- Fix some potential file related exceptions in text file import.
- Support filenames with accented chars in text file import dialog (issue #1387).
- New query tab uses the same memo height as the current tab.
- Session background color now used on query result tabs, and in query gutter (issue #932).
- Fix various style/theme related crashes, for instance when closing the grid export dialog.
- Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns.
- Fix missing SET TIME_ZONE.. on export target server (issue #1457).
- Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (issue #1417).
- Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (issue #1259).
- Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See https://www.heidisql.com/forum.php?t=38150.
- Support UINT columns in SQLite mode (issue #1453).
- Update SynEdit's list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series (issue #1437).
- Run current query: Prefer query left to the current one, if current one contains no text (issue #603).
- SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables.
- Activate auto-suggest option "Find matches in middle of entered text" by default..
- Don't clear variable from --description cli parameter. (#1295).
- Quote column names for quick filter, when column name matches an SQL function (#1398).
- Session manager: Auto-expand session folder when user filter matches a child session.
- Fixes for handling virtual columns (#1210).
- Add option to turn off tab close by doubleclick/middleclick (#1151).
- Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (issue #1539).
- NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (issue #202).
- Binary values in foreign key pulldown now works with hex code, instead of binary garbage (issue #1540).
- Enhanced foreground/background colors for matching brace in dark themes. (issue #887).
- Fix EAbort error when copying text from SynMemo without highlighter.

v11.3 [Jun 1, 2021]
3rd party updates:
- Update SynEdit component code.
- Update VirtualTrees component code.
- Include Microsoft Visual C 2015-2019 Redistributable in installer, required for some 3rd party libraries (issue #1296).
- Update plink.exe to v0.75.
New stuff:
- Log DDL and/or DML queries per session to custom file path (issue #397).
- Grid text editor:.
- syntax highlighting for 64 code languages, including JSON and XML (issue #136).
- gutter with line numbers and marks for edited lines.
- now using search/replace dialog with regular expression support.
- Enable query timeout setting for MySQL and MariaDB (issue #1306).
- Show check constraints on MySQL, MSSQL and PostgreSQL (issue #1298).
- New menu Query > "Editor commands", revealing available quick actions for SQL editors.
- Create "Editor commands" menu in "Query" main menu, and populate it with all available editor commands.
- Add new preference option for displaying hexadecimal content in lowercase.

v11.2 [Jan 24, 2021]
Issue #136: fix OS crash with large cell text when reading FEdit.SelStart/Length.

v11.0 [Mar 19, 2020]
New features and enhancements in this version:
- Support connecting to SQLite database files.
- drop schema support for PostgreSQL.
- support foreign keys in PostgreSQL.
- support foreign keys in MS SQL.
- read-only mode for grid cell editors, if underlying query or table does not allow updates.
- support scram-sha-256 authentication on PostgreSQL.
- enhanced readability of release notes.
- enhanced readability of help links with dark themes.
- support column comments of PostgreSQL.
- support disabling "Full table status" on PostgreSQL.
- new filter edit box on session manager, for filtering sessions using regular expressions.
- close query tabs via middle mouse click.
- trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting.
- sort collation drop down on "Bulk table editor" alphabetically.
- place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable.
- performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
- widen buttons on search/replace dialog by one quarter, so translations fit better on them.
- use default library of given network type in command line receiver.
- refreshed application icon.
Bugfixes:
- fix crashes when restoring tabs: expect no UTF-8 BOM.
- Procedure body changes invisible when parameter tab is active.
- last active session was no longer scrolled into view area of session manager.
- crash when mouse moves over data grid with broken connection.
- clicking too fast on session folder opens connection instead of collapse.
- passphrase input for SSH tunnel now masked.
- detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema.
- fix crash when accessing data from data tab on a disconnected session.
- fix crash when active main tab changes and data grid is disabled (due to disconnect).
- make copy/cut safer against harmless crashes, and show occurring error messages in log panel.
- MSSQL: Remove surrounding parentheses from default value.
- fix state of checkboxes on the session manager's Advanced tab.
- fix crash by click on "Add column" in table editor, when columns list has a minimum height.
Third party libraries and components:
- update libmariadb.dll to v3.1.7.
- update libpq.dll to v10.0.11.
- introduce additional libpq.dll v12.0.1.
- update InnoSetup compiler to v6.0.3.
- update VirtualTree component to v7.3.
- introduce sqlite3.dll v3.30.1.

v11.0 [Apr 22, 2020]
#444: show initial captions and hints of TAction's on shortcut page in preferences dialog.

v10.3 [Dec 13, 2019]
New features and enhancements in this version:
- Theme preview in preferences dialog.
- "Library" dropdown in session manager, to enhance support for older and newer MySQL and MariaDB versions.
- Various new shortcuts in the "Go to" menu, e.g. for switching between result and query area.
- Support newer plink versions for SSH tunneled connections.
- Grid rightclick on cell: "Open in webbrowser" for fields containing a web url.
- Support for client_ed25519 MariaDB plugin.
- Support for SSH tunneled connections to PostgreSQL servers.
- Support for SSL on PostgreSQL servers.
- "Same text" background color in grid now applies to neigbour fields in selected row as well.
- Support for connections to Amazon Redshift (basically older PostgreSQL servers).
- Restored query tabs also restore bind parameters.
- New option in grid export dialog: "Remove linebreaks from data".
- New option to remove DEFINER clauses in SQL export option drop-down.
- Increase compatibility of table editor on PostgreSQL.
Bugfixes:
- Reverts earlier attempts for native high DPI support, so scaling is done by Windows again (blurry but less buggy).
- Auto-detected Chinese localization fixed.
- Compatibility to MySQL 4 restored.
- Various fixes for SSL on MySQL and MariaDB.
- Fixed broken "undo" after auto-uppercased SQL keyword.
- Fixed crash when switching to table/database with same name on different server.
- Fixed invisible column comments on PostgreSQL.
- Fixed unsupported def.adsrc on PostgreSQL 12.
- Ctrl Backspace in text boxes deletes left word, instead of writing cryptic character.
- Fixed update SQL for JSON columns in PostgreSQL.
- Fixed disappearing table comments after saving.
- Fixed warning about unsafe query when fooled with a commented WHERE clause.

v10.2 [Jun 17, 2019]
New features and enhancements in this version:
- High resolution icons from Icons8.
- Save and restore query tabs automatically.
- PostgreSQL connection over SSH tunnel.
- Configurable web search engine for help links in footer of message dialogs.
- Support for DATETIMEOFFSET data types on MSSQL.
- Table designer: Support for custom expressions in column default values.
- Caching of "SELECT 1234::regclass" queries on PostgreSQL connections.
- New data grid menu item "Duplicate row with keys" (besides the old one "Duplicate row without keys).
- Support for TLS versions up to 1.3 in MySQL connections.
Bugfixes:
- Text search on PostgreSQL works properly now.
- Auto-uppercase feature does not touch column names on table aliases.
- Enhanced Material theme colors.
- Artefacts in query editor when using non-default theme.

v9.5 [Dec 30, 2017]
-Expect regular expression in filter text on right panel, not a simple string. Keep searching case insensitive, as in prior logic. Add text hint to filter box so the user knows he can enter a regular expression here. Closes #45.
-Add new TAction for clearing query log, and assign it to the rightclick menu item of it. Give this new action the hotkey Ctrl+Q. Closes #25.
-Add custom setting for number of days to keep queries in the query history.
-Use the grid export dialog for setting values for copy-to-clipboard clicks on grids. Adds a new button in the lower left on that dialog.
-Support grouping by tree node type in "check xyz" menu items on table tools dialog. S
-Include ADO connection string in status bar connection details, shorten the lines reasonably and show the full lines in a message box when clicking on it.
-Support SQL security setting in view editor via drop down menu.
-Use the right SQL commands for killing a process on PostgreSQL.

v9.3 [Aug 10, 2015]
Added various missing translation strings.

v9.1 [Nov 14, 2014]
This is a maintenance release, which basically reintroduces support for legacy password encryption (pre-4.1 hash format).

v8.3 [Jan 27, 2014]
25 Jan HeidiSQL 8.3 released
This is a maintenance release, fixing a build update problem on Win64, along with various other fixes and the new comment field on the session manager.

v8.1 [Oct 3, 2013]
- Make snippets directory customizable.
- Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
- Introduce Win7 jump items on task button.
- Introduce the data option "Local number format"
- Remove "Run file" dialog, and use a standard Windows IProgressDialog instead when executing a SQL file.
- Added check option "FOR UPGRADE" to maintenance dialog.
- Provide edit box for custom NULL value, in grid export dialog.
- Support length of "max" in data types. Used in MSSQL.
- Added schema support in MSSQL.
- Added overlay icons for table engines Blackhole and MergeMyISAM.
- Added preference option and logic for alternating grid row background colors.
- Display values in grid columns which the user explicitly sets to be a UNIX timestamp in date/time format.
- Append instead of overwrite data grid filter when user has Shift pressed.
- Implement a simple search/replace dialog in the popup text editor.

v8.0 [May 19, 2013]
Available in 23 languages now. Thanks to all translators and Transifex hereby!
- Database tree: Introduce optional folders for tables, views, routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB 5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values different to their session pendant
- Add menu item for launching mysql.exe command line with current parameters.

v7.0 [Feb 12, 2012]
- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export;
- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created;
- Threaded query execution, including a button to stop long running queries;
- Add right click option to toggle visibility of horizontal scrollbar in SQL log .

v1.0 [Jan 21, 2015]
New features and enhancements in this version:
- Support connecting to sqlite database files.
- Drop schema support for postgresql.
- Support foreign keys in postgresql.
- Support foreign keys in MS SQL.
- Read-only mode for grid cell editors, if underlying query or table does not allow updates.
- Support scram-sha-256 authentication on postgresql.
- Enhanced readability of release notes.
- Enhanced readability of help links with dark themes.
- Support column comments of postgresql.
- Support disabling "Full table status" on postgresql.
- New filter edit box on session manager, for filtering sessions using regular expressions.
- Close query tabs via middle mouse click.
- Trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting.
- Sort collation drop down on "Bulk table editor" alphabetically.
- Place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable.
- Performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
- Widen buttons on search/replace dialog by one quarter, so translations fit better on them.
- Use default library of given network type in command line receiver.
- Refreshed application icon.
Bugfixes:
- Fix crashes when restoring tabs: expect no UTF-8 BOM.
- Procedure body changes invisible when parameter tab is active.
- Last active session was no longer scrolled into view area of session manager.
- Crash when mouse moves over data grid with broken connection.
- Clicking too fast on session folder opens connection instead of collapse.
- Passphrase input for SSH tunnel now masked.
- Detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema.
- Fix crash when accessing data from data tab on a disconnected session.
- Fix crash when active main tab changes and data grid is disabled (due to disconnect).
- Make copy/cut safer against harmless crashes, and show occurring error messages in log panel.
- MSSQL: Remove surrounding parentheses from default value.
- Fix state of checkboxes on the session manager's Advanced tab.
- Fix crash by click on "Add column" in table editor, when columns list has a minimum height.
Third party libraries and components:
- Update libmariadb.dll to v3.1.7.
- Update libpq.dll to v10.0.11.
- Introduce additional libpq.dll v12.0.1.
- Update innosetup compiler to v6.0.3.
- Update virtualtree component to v7.3.
- Introduce sqlite3.dll v3.30.1.

Alternative downloads

dbForge Studio for MySQL
dbForge Studio for MySQL
rating

The universal MySQL and MariaDB client for database management.

SQL Editor for Oracle
SQL Editor for Oracle
Free
rating

SQL Editor allows you to write any SQL statement and make database queries.

Data Sync for MySQL
Data Sync for MySQL
rating

Powerful tool for comparison of database contents.

Excel MySQL Import, Export & Convert Software
Excel MySQL Import, Export
rating

This program allows you to import and export excel tables to MySQUL databases.

EngInSite MySQL Client
EngInSite MySQL Client
rating

Helps you create, manage, and edit MySQL databases.