Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Download HeidiSQL 10.2

Release date: 15 Jun 2019.

Donate

Compatibility notes

Nightly Builds of heidisql.exe

Latest automatically compiled main executable and installers for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe. Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones.

  1. Break Plink wait loop when server has sent an "Access denied" error. Closes #774.

    Gravatar image committed: 08 Dec 2019 12:28 compiled: 08 Dec 2019 12:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  2. Add checkbox option to remove line breaks from field contents in grid export dialog. Closes #474

    Gravatar image committed: 08 Dec 2019 11:59 compiled: 08 Dec 2019 12:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  3. Disable some controls on VIEW editor, which the underlying server does not support, and don't generate SQL clauses for these. Closes #39.

    Gravatar image committed: 03 Dec 2019 20:47 compiled: 03 Dec 2019 20:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  4. Support very low max_allowed_packet setting in TMySQLConnection.MaxAllowedPacket, so it has to be >10K only, for not assuming 1M for SQL exports. See https://www.heidisql.com/forum.php?t=35046

    Gravatar image committed: 01 Dec 2019 11:13 compiled: 01 Dec 2019 11:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  5. Turn simple message box into a prompt when SSH tunnel asks for key passphrase. Closes #284.

    Gravatar image committed: 30 Nov 2019 18:05 compiled: 30 Nov 2019 18:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  6. Store and restore bind parameters per query tab in tabs.ini, including activation state. Closes #689

    Gravatar image committed: 30 Nov 2019 13:55 compiled: 30 Nov 2019 14:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  7. Do not trigger file reload prompt after file access. See https://www.heidisql.com/forum.php?t=15500

    Gravatar image committed: 29 Nov 2019 22:00 compiled: 29 Nov 2019 22:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  8. Add CURRENT_TIMESTAMP to function list, especially for the dropdown in the default editor. See https://github.com/HeidiSQL/HeidiSQL/issues/74#issuecomment-559321533

    Gravatar image committed: 28 Nov 2019 06:38 compiled: 28 Nov 2019 06:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  9. Use up to 70 characters on a main tab caption before adding ellipsis. Gives long table names more room.

    Gravatar image committed: 26 Nov 2019 21:12 compiled: 26 Nov 2019 21:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  10. Refactor code for query bind parameters

    Gravatar image committed: 24 Nov 2019 16:46 compiled: 24 Nov 2019 16:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  11. Support modifying columns per table designer in PostgreSQL mode, including rename. Closes #595

    Gravatar image committed: 24 Nov 2019 15:47 compiled: 24 Nov 2019 15:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  12. Let TConnectionParameters.NetTypeName and TConnectionParameters.IsCompatibleToWin10S rely on a correctly set FNetType property. So we can safely use GetNetTypeGroup on it, and need less parameter passing. Closes #812. The default FNetType should probably not be ntMySQL_TCPIP any longer, so such bugs get seen earlier.

    Gravatar image committed: 22 Nov 2019 20:00 compiled: 22 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  13. Display last system error when plink process could not be started for some reason. Helps in debugging. See https://www.heidisql.com/forum.php?t=34556#p35000

    Gravatar image committed: 20 Nov 2019 21:02 compiled: 20 Nov 2019 21:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  14. Fix unwanted wrapping in help label on find dialog

    Gravatar image committed: 19 Nov 2019 21:18 compiled: 19 Nov 2019 21:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  15. Add "Find text" item to context menu in data grid and query grids. Users may not be aware that find feature supports data grids, when it's only in the main menu.

    Gravatar image committed: 19 Nov 2019 21:13

  16. Suppress errors in GetLockedTableCount, which is not working on all servers: https://www.heidisql.com/forum.php?t=34984

    Gravatar image committed: 19 Nov 2019 06:45 compiled: 19 Nov 2019 06:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  17. On Amazon Redshift servers, display "Redshift PG x.y" in status bar. Closes #802

    Gravatar image committed: 17 Nov 2019 17:15 compiled: 17 Nov 2019 17:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  18. Issue #805: fall back to translated button captions if GetLocaleString returned an empty string. Setting an empty button caption raises an exception in TTaskDialogButtonItem

    Gravatar image committed: 14 Nov 2019 21:32 compiled: 14 Nov 2019 21:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  19. Issue #88: remove definer clause also for views and events, if wanted

    Gravatar image committed: 13 Nov 2019 14:40 compiled: 13 Nov 2019 14:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  20. SQL export: add drop down menu item for removing DEFINER clauses from triggers, procedures and functions

    Gravatar image committed: 13 Nov 2019 14:29

  21. Issue #88: consistently use DBObject.CreateCode also for trigger exporting

    Gravatar image committed: 13 Nov 2019 12:56

  22. Issue #685: Fix fatal performance bug, calling GetSQL on each examined character of a TSQLSentence. See report on https://www.heidisql.com/forum.php?t=34935

    Gravatar image committed: 13 Nov 2019 08:16 compiled: 13 Nov 2019 08:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  23. Issue #802: filter away not owned databases only on Redshift servers. See https://www.heidisql.com/forum.php?t=34635#p34946

    Gravatar image committed: 12 Nov 2019 19:56 compiled: 12 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  24. Issue #802: Detect Amazon Redshift via IsRedshift and give servers a fitting icon

    Gravatar image committed: 12 Nov 2019 19:50

  25. Issue #802: Redshift: modify query for retrieving accessible databases. See https://www.heidisql.com/forum.php?t=34635#p34937

    Gravatar image committed: 12 Nov 2019 07:47 compiled: 12 Nov 2019 07:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  26. Reactivate TSynHotKey again, after removing it accidentally in recent SynEdit update. Should fix a crashing preferences dialog.

    Gravatar image committed: 11 Nov 2019 19:22 compiled: 11 Nov 2019 19:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  27. Always use an empty query tab for loading an sql file. Don't load contents into a currently non-empty tab. Closes #270.

    Gravatar image committed: 10 Nov 2019 18:36 compiled: 10 Nov 2019 18:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  28. Reapply SingleLineMode feature for SynEdit, which we need in the SQL log panel

    Gravatar image committed: 10 Nov 2019 09:22 compiled: 10 Nov 2019 09:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  29. Update SynEdit component to latest sources from their master branch

    Gravatar image committed: 10 Nov 2019 08:57

  30. Alternative to pg_relation_size() for pre-8.1 PG servers. See https://www.heidisql.com/forum.php?t=34635

    Gravatar image committed: 07 Nov 2019 07:39 compiled: 07 Nov 2019 07:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  31. Never prepend "AND " in first quick filter. Closes #796

    Gravatar image committed: 07 Nov 2019 06:59 compiled: 07 Nov 2019 07:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  32. Refactor: rename helper function sstr() to something more readable, and optimize it slightly

    Gravatar image committed: 04 Nov 2019 20:15 compiled: 04 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  33. Display help text for SQL function as tooltip hint in query helpers tree.

    Gravatar image committed: 04 Nov 2019 20:05

  34. Update MySQL/MariaDB function list and their help texts

    Gravatar image committed: 03 Nov 2019 13:45 compiled: 03 Nov 2019 13:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  35. Update code from vcl-styles-utils to current master branch from Oct 10 2019. Closes #649. Also related to background color of selected VirtualTree nodes, reported in #789

    Gravatar image committed: 01 Nov 2019 15:56 compiled: 01 Nov 2019 16:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  36. Apply DBtree's OnPaintText code to dialog for selecting user privilege object, so we get bold focused path there as well. Related to #785

    Gravatar image committed: 01 Nov 2019 13:49 compiled: 01 Nov 2019 13:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  37. Set bold text for database tree nodes in focused path. Related to #785

    Gravatar image committed: 01 Nov 2019 13:42

  38. Centralize some code for checking validity of column number in current row of TDBQuery. Fixes a crash after canceling new row insertion, through ValidateControls(). Related to #788.

    Gravatar image committed: 01 Nov 2019 12:41 compiled: 01 Nov 2019 12:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  39. Fix crash when trying to add a new grid row while a first one was not yet saved. Closes #788

    Gravatar image committed: 01 Nov 2019 12:37

  40. Highlight same grid cell text also in current row, not only in current column. Closes #707

    Gravatar image committed: 30 Oct 2019 08:01 compiled: 30 Oct 2019 08:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  41. Don't fool detection of unsafe queries by comments. Closes #685

    Gravatar image committed: 29 Oct 2019 21:46 compiled: 29 Oct 2019 21:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  42. Fix definition of PostgreSQL Oid from Integer to Cardinal, as it is in postgres_ext.h . Should fix negative Oids in TPGQuery.TableName. See https://www.heidisql.com/forum.php?t=34819

    Gravatar image committed: 27 Oct 2019 22:26 compiled: 27 Oct 2019 22:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  43. Activate toVariableNodeHeight option in query helpers tree, which triggers FixVT() to set HintMode to hmHint. This in turn displays full queries on query history nodes. Closes #693

    Gravatar image committed: 27 Oct 2019 12:09 compiled: 27 Oct 2019 12:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  44. Restore previously used collation when creating new database. Closes #702

    Gravatar image committed: 27 Oct 2019 11:59

  45. After pressing save button on table editor, use the fresh DBObject from SHOW TABLE STATUS row, not the old one. This fresh one also has the new table comment. Closes #683

    Gravatar image committed: 27 Oct 2019 11:46 compiled: 27 Oct 2019 11:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  46. Populate target database drop-down only with unchecked database nodes in object tree, to prevent overwrites. Closes #775

    Gravatar image committed: 27 Oct 2019 08:38 compiled: 27 Oct 2019 08:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  47. Issue #777: Fix crash, happening in actToggleCommentExecute(), when commenting a line in the data tab filter

    Gravatar image committed: 23 Oct 2019 14:20 compiled: 23 Oct 2019 14:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  48. popupDataGridPopup is also used in query tab result grids, so here's a check for which grid is active. Closes #776

    Gravatar image committed: 22 Oct 2019 22:11 compiled: 22 Oct 2019 22:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  49. Issue #769: append ::text to JSON column names in PostgreSQL WHERE clauses. Fixes "Operator does not exist" errors

    Gravatar image committed: 20 Oct 2019 16:47 compiled: 20 Oct 2019 16:56

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.2 MB)

  50. Performance: Search libraries on system once per app instance and net type group. Cache these in TConnectionParameters.FLibraries. OLE DB providers take some time to collect.

    Gravatar image committed: 20 Oct 2019 09:47 compiled: 20 Oct 2019 09:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)