Download HeidiSQL 10.2

Release date: 15 Jun 2019.

• Installer, 32/64 bit combined
• Portable version (zipped): 32 bit , 64 bit
• Microsoft Store App, 32 bit
• Sourcecode
• Previous installers
  • HeidiSQL 10.1 (26 Jan 2019)
  • HeidiSQL 10.0 (23 Jan 2019)
  • HeidiSQL 9.5 (19 Dec 2017)
  • HeidiSQL 9.4 (20 Oct 2016)

Please disable your adblocker and reload the page to enable HeidiSQL downloads.

Or, if you can't overcome the temptation, rightclick the anchor and click "copy link" to get it. Don't blame anyone for waking up on the dark side afterwards.

Compatibility notes

• HeidiSQL runs fine on Windows XP, Vista, 7, 8 and 10. Using Wine, it mostly runs fine on Linux and MacOS.
• Connecting to TLS 1.2 enabled MS SQL Servers requires an updated OLE DB Driver 18 for SQL Server to be installed.
• Wine users: For MS SQL connections, avoid using Wine 3.15 up to 4.1. Instead, use Wine 3.14 or 4.2 - these should work.
• Connecting to PostgreSQL may require to have Visual C++ Redistributable Package installed

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. Revision
   10.2.0.5751

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

   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. Revision
   10.2.0.5750

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

   committed: 13 Nov 2019 14:29

3. Revision
   10.2.0.5749

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

   committed: 13 Nov 2019 12:56

4. Revision
   10.2.0.5748

   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

   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. Revision
   10.2.0.5747

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

   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. Revision
   10.2.0.5746

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

   committed: 12 Nov 2019 19:50

7. Revision
   10.2.0.5745

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

   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. Revision
   10.2.0.5744

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

   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. Revision
   10.2.0.5743

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

   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. Revision
    10.2.0.5742

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

    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. Revision
    10.2.0.5741

    Update SynEdit component to latest sources from their master branch

    committed: 10 Nov 2019 08:57

12. Revision
    10.2.0.5740

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

    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. Revision
    10.2.0.5739

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

    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. Revision
    10.2.0.5738

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

    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. Revision
    10.2.0.5737

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

    committed: 04 Nov 2019 20:05

16. Revision
    10.2.0.5736

    Update MySQL/MariaDB function list and their help texts

    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. Revision
    10.2.0.5735

    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

    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. Revision
    10.2.0.5734

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

    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. Revision
    10.2.0.5733

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

    committed: 01 Nov 2019 13:42

20. Revision
    10.2.0.5732

    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.

    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. Revision
    10.2.0.5731

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

    committed: 01 Nov 2019 12:37

22. Revision
    10.2.0.5730

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

    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. Revision
    10.2.0.5729

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

    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. Revision
    10.2.0.5728

    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

    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. Revision
    10.2.0.5727

    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

    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. Revision
    10.2.0.5726

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

    committed: 27 Oct 2019 11:59

27. Revision
    10.2.0.5725

    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

    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. Revision
    10.2.0.5724

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

    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. Revision
    10.2.0.5723

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

    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. Revision
    10.2.0.5722

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

    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. Revision
    10.2.0.5721

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

    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. Revision
    10.2.0.5720

    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.

    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. Revision
    10.2.0.5719

    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.

    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. Revision
    10.2.0.5718

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

    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. Revision
    10.2.0.5717

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

    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. Revision
    10.2.0.5716

    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.

    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. Revision
    10.2.0.5715

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

    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. Revision
    10.2.0.5714

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

    committed: 13 Oct 2019 14:35

39. Revision
    10.2.0.5713

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

    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. Revision
    10.2.0.5712

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

    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. Revision
    10.2.0.5711

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

    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. Revision
    10.2.0.5710

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

    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. Revision
    10.2.0.5709

    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.

    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. Revision
    10.2.0.5708

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

    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. Revision
    10.2.0.5707

    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

    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. Revision
    10.2.0.5706

    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.

    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. Revision
    10.2.0.5705

    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

    committed: 03 Oct 2019 12:09

48. Revision
    10.2.0.5704

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

    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. Revision
    10.2.0.5703

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

    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. Revision
    10.2.0.5702

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

    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)

Imprint