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. 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)

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

    Gravatar image committed: 13 Nov 2019 14:29

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

    Gravatar image committed: 13 Nov 2019 12:56

  4. 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)

  5. 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)

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

    Gravatar image committed: 12 Nov 2019 19:50

  7. 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)

  8. 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)

  9. 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)

  10. 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)

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

    Gravatar image committed: 10 Nov 2019 08:57

  12. 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)

  13. 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)

  14. 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)

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

    Gravatar image committed: 04 Nov 2019 20:05

  16. 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)

  17. 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)

  18. 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)

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

    Gravatar image committed: 01 Nov 2019 13:42

  20. 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)

  21. 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

  22. 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)

  23. 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)

  24. 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)

  25. 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)

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

    Gravatar image committed: 27 Oct 2019 11:59

  27. 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)

  28. 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)

  29. 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)

  30. 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)

  31. 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)

  32. 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)

  33. Issue #144: Prefer emptying selection in TCustomEdit's via EM_REPLACESEL message, which we can prepare to support undo. Unfortunately, not so in TComboBox, which does nothing then.

    Gravatar image committed: 19 Oct 2019 16:59 compiled: 19 Oct 2019 17:26

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

  34. Issue #144: New approach for supporting Ctrl+Backspace in edit + combobox controls, now in the ApplicationEvents.OnShortCut event

    Gravatar image committed: 19 Oct 2019 14:07 compiled: 19 Oct 2019 14:26

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

  35. Issue #140: Be sure to write tab backup files in UTF8 without BOM

    Gravatar image committed: 15 Oct 2019 07:07 compiled: 15 Oct 2019 07:27

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

  36. Issue #140: Prefer TStreamWriter over TFileStream, in SaveUnicodeFile(). Also, use its own Write() method instead of StreamWrite(), which encodes UTF8 first, so the new approach is probably faster. Probably also helps with non-writable tab backups on some systems.

    Gravatar image committed: 13 Oct 2019 16:38 compiled: 13 Oct 2019 16:56

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

  37. Issue #704: detect pre-authentication banner messages as informational (not as error) in plink output

    Gravatar image committed: 13 Oct 2019 14:48 compiled: 13 Oct 2019 14:57

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

  38. Issue #704: check result of "SHOW ssl" for whether SSL is really being used

    Gravatar image committed: 13 Oct 2019 14:35

  39. Issue #704: escape backslashes in SSL certificate files for PostgreSQL connections

    Gravatar image committed: 11 Oct 2019 07:53 compiled: 11 Oct 2019 07:57

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

  40. Remove the SHAutoComplete() call to revert the solution for #144 - this introduces too many new bugs.

    Gravatar image committed: 08 Oct 2019 19:26 compiled: 08 Oct 2019 19:56

    Downloads: 32bit build (7.9 MB)64bit build (8.4 MB)32+64bit installer (20.1 MB)

  41. Update libmariadb.dll and various plugins, add 2 new ones: client_ed25519 and auth_named_pipe. Probably solves #754

    Gravatar image committed: 08 Oct 2019 19:05 compiled: 08 Oct 2019 19:27

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

  42. Revert 355db1403aff5c7d061962f3ca21c62bcd8001f8 for #144, which makes the Tab key ineffective. Closes #765

    Gravatar image committed: 07 Oct 2019 20:27 compiled: 07 Oct 2019 20:57

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

  43. Issue #762: add informational message when foreign key'd column has too many rows in the connected table, and raise limit from 1000 to 10000.

    Gravatar image committed: 05 Oct 2019 14:09 compiled: 05 Oct 2019 14:26

    Downloads: 32bit build (7.9 MB)64bit build (8.4 MB)32+64bit installer (21.4 MB)

  44. To retrieve a column default value, prefer pg_attrdef.adbin column over pg_attrdef.adsrc. PostgreSQL 12 does not have adsrc. Closes #763

    Gravatar image committed: 05 Oct 2019 12:08 compiled: 05 Oct 2019 12:26

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

  45. Issue #62: distinct between TIMEZONE (without time zone) and TIMEZONETZ (with time zone). And modify GetDatatypeByName() so it deletes the longest detected datatype string PostgreSQLDatatypes.Names . This solves empty/undetected column comments in ParseTableStructure(). See https://www.heidisql.com/forum.php?t=23211#p34709

    Gravatar image committed: 05 Oct 2019 08:04 compiled: 05 Oct 2019 08:27

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

  46. Fix glitch in previous commit for #62: never escape \, and don't overwrite text with escaped joker chars. So we just escape %, _ and ' now in Postgres mode.

    Gravatar image committed: 03 Oct 2019 12:19 compiled: 03 Oct 2019 12:27

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

  47. Remove "E" prefix from escaped strings, which caused an empty result in ExtractLiteral(). Instead, let EscapeString() escape just \, % and _ with backslash, and ' by a second '. Closes #62

    Gravatar image committed: 03 Oct 2019 12:09

  48. Check if (old) grid result is in a valid state before checking for an url. Closes #759

    Gravatar image committed: 01 Oct 2019 19:35 compiled: 01 Oct 2019 19:57

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

  49. Issue #541: apply KeyPress event to all other writable SQL editors, so the auto-uppercase feature is available everywhere

    Gravatar image committed: 30 Sep 2019 20:44 compiled: 30 Sep 2019 20:57

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

  50. Issue #712: final solution for intuitive result tab captions and line/char panel

    Gravatar image committed: 29 Sep 2019 12:34 compiled: 29 Sep 2019 12:58

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