Ads were blocked by your webbrowser.

This is not a 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. Collect custom session background colors via OnGetColors event of TColorBox, do not mix it in the code for refreshing the session tree. Also refresh custom colors each time a session is focused, so it has new colors.

    Gravatar image committed: 20 Jul 2019 17:29 compiled: 20 Jul 2019 17:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  2. Giving up on high DPI readiness - remove tweaks which mostly don't work as expected, and even differently on various computers. Instead, let Windows blur fonts.

    Gravatar image committed: 18 Jul 2019 20:53 compiled: 18 Jul 2019 20:57

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  3. Issue #718: Fonts may still be too large because the monitor on which a form is created has DPI > 100%. Calculate DpiScaleFactor based on that first monitor. See https://www.heidisql.com/forum.php?t=34230

    Gravatar image committed: 18 Jul 2019 19:08 compiled: 18 Jul 2019 19:11

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  4. Issue #718: Fonts may be too large because they get scaled before the window gets moved to the wanted screen. So, this moves the code for scaling fonts to FormShow, so we can scale fonts according to the screen's DPI setting.

    Gravatar image committed: 18 Jul 2019 07:52 compiled: 18 Jul 2019 08:05

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  5. High DPI: Scale up font size when applying font to query editors and result grids
    Todo: mouse wheel zooming seems broken on dpi > 100%

    Gravatar image committed: 17 Jul 2019 22:15 compiled: 17 Jul 2019 22:17

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  6. High DPI:
    * remove ParentFont flag from forms again (introduced in 9cdcd631454f6f9e999893ea89fcf502d994474c for #213). This just inherits from default Windows settings.
    * instead, scale font size in InheritFont(), and move that to the new TExtForm class
    * mark app with PerMonitorV2 support

    Gravatar image committed: 17 Jul 2019 21:59 compiled: 17 Jul 2019 22:02

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  7. Make search for libraries case insensitive. Closes #716

    Gravatar image committed: 17 Jul 2019 07:02 compiled: 17 Jul 2019 07:24

    Downloads: 32bit build (7.8 MB)64bit build (8.3 MB)32+64bit installer (19.1 MB)

  8. Changed 10.2 GroupProj to point to the 10.2 packages instead of XE5 ones

    Gravatar image committed: 16 Jul 2019 19:15 compiled: 16 Jul 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  9. Changed 10.3 GroupProj to point to the 10.3 packages instead of XE5 ones

    Gravatar image committed: 16 Jul 2019 19:15

  10. Add "Multi column filter" item to "Go to" menu. Closes #681. Also, "Switch between query/results" now switches between filter and grid in Data tab.

    Gravatar image committed: 14 Jul 2019 19:46 compiled: 14 Jul 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  11. Add "Switch to query/results" item to "Go to" menu. Closes #698

    Gravatar image committed: 14 Jul 2019 19:27

  12. Revert a part of 1c76c2ecc0ed7d87cda822228802bedf48a143fe, which disabled the port input for MS SQL / TCP connections if the host is a named instance. According to #714 you can still use the port for named instances. Closes #714.

    Gravatar image committed: 14 Jul 2019 17:38 compiled: 14 Jul 2019 17:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  13. Issue #513: add a theme preview dialog, which loads the selected theme png file from heidisql.com

    Gravatar image committed: 13 Jul 2019 15:59 compiled: 13 Jul 2019 16:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  14. Append system error message to error dialog popping up when tabs.ini is not writable. See https://www.heidisql.com/forum.php?t=34044

    Gravatar image committed: 12 Jul 2019 18:25 compiled: 12 Jul 2019 18:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  15. Issue #360: add unique session colors only to the background color selector, and label them "Custom color". See https://www.heidisql.com/forum.php?t=34168#p34194

    Gravatar image committed: 12 Jul 2019 18:23

  16. Add custom colors from sessions to background color selector. See https://www.heidisql.com/forum.php?t=34168

    Gravatar image committed: 11 Jul 2019 21:38 compiled: 11 Jul 2019 22:10

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  17. Issue #677: select first available library if default or configured one is not available.

    Gravatar image committed: 10 Jul 2019 22:05 compiled: 10 Jul 2019 22:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  18. Issue #498: Increase completion threshold for pulling language files from 10% to 20%. Old translations now get deleted before fresh copies get downloaded, so deleted languages should really get removed from the compiled application.

    Gravatar image committed: 10 Jul 2019 20:24 compiled: 10 Jul 2019 20:37

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

  19. Restore tabs feature crashes often on old XP systems, so we activate it by default only on Vista and newer. See https://www.heidisql.com/forum.php?t=34044

    Gravatar image committed: 10 Jul 2019 16:25 compiled: 10 Jul 2019 16:54

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

  20. Disable tab restore/store when tabs.ini is not writable. See https://www.heidisql.com/forum.php?t=34044#p34148

    Gravatar image committed: 10 Jul 2019 11:46 compiled: 10 Jul 2019 15:24

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

  21. Silence reoccurring error dialogues due to non-writable portable_settings.txt, by introducing a portable-read-only mode as soon as an update to that file fails

    Gravatar image committed: 10 Jul 2019 11:05

  22. Make mysql_fetch_field() available. Helps in debugging #697.

    Gravatar image committed: 08 Jul 2019 20:25 compiled: 08 Jul 2019 20:53

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

  23. Issue #677:
    * drop workaround for application crash on WinXP, when loading newer libmariadb (see #79)
    * raise TDbLib's own exception instead of baking an own one with less details. Probably helps in debugging: https://www.heidisql.com/forum.php?t=34044
    * rename EDatabaseError to EDbError, to overcome naming conflict in DB unit
    * load libpq.dll always with path, which should anyway work better than without it. See http://www.heidisql.com/forum.php?t=22514

    Gravatar image committed: 08 Jul 2019 20:23

  24. High DPI: fix growing window dimensions on each opening. Related to #378

    Gravatar image committed: 07 Jul 2019 21:22 compiled: 07 Jul 2019 21:53

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

  25. Fix wrong calculated height and width of tool buttons after DPI change / move between monitors. Closes #446

    Gravatar image committed: 07 Jul 2019 09:42 compiled: 07 Jul 2019 09:53

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

  26. High DPI: fix wrong height of status bar, by not setting it to what GetTextHeight returns. Maybe also related to #483.

    Gravatar image committed: 06 Jul 2019 16:03 compiled: 06 Jul 2019 16:24

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

  27. Issue #677: provide a new library combobox in MySQL mode, for selecting any of the libmysql/mariadb.dll files from the application directory

    Gravatar image committed: 05 Jul 2019 06:44 compiled: 05 Jul 2019 06:53

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

  28. Fix new crash in ConnectionInfo (mouse over server version status panel)

    Gravatar image committed: 30 Jun 2019 08:59 compiled: 30 Jun 2019 09:23

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

  29. Escape double quotes in SSH password for plink command. Closes issue #261

    Gravatar image committed: 29 Jun 2019 08:02 compiled: 29 Jun 2019 08:24

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

  30. Use UnescapeString() to remove more escape sequences than a duplicated single quote. Move ExtractLiteral() to TDBConnection, as UnescapeString() depends on the connection type. Closes #690.

    Gravatar image committed: 26 Jun 2019 19:52 compiled: 26 Jun 2019 20:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

  31. Fix some suspicious places which can cause exceptions when data tab is open and current connection is being closed. Probably closes #615.

    Gravatar image committed: 24 Jun 2019 21:45 compiled: 24 Jun 2019 21:54

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

  32. Use the same new dll loading mechanism also for PostgreSQL's libpq.dll

    Gravatar image committed: 22 Jun 2019 17:57 compiled: 22 Jun 2019 18:24

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

  33. Refactor: rename mysql_structures unit neutrally to dbstructures

    Gravatar image committed: 22 Jun 2019 14:26 compiled: 22 Jun 2019 14:54

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

  34. Fix wrong data shown in data tab, when switching between a table/database with the same name on different servers

    Gravatar image committed: 22 Jun 2019 14:16

  35. Use mysql_optionsv to tell newer MySQL servers HeidiSQL's program_name, visible then in performance_schema.session_connect_attrs

    Gravatar image committed: 19 Jun 2019 22:47 compiled: 19 Jun 2019 22:58

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

  36. Fix duplicated application directory prepended on library path

    Gravatar image committed: 19 Jun 2019 22:45

  37. Experimental: introduce TDbLib and descendant TMySQLLib, and outsource dll loading mechanism there, out of DoBeforeConnect

    Gravatar image committed: 19 Jun 2019 21:15

  38. Quick filter: only unique cell values in "IN (...)" generation

    Gravatar image committed: 19 Jun 2019 17:51 compiled: 19 Jun 2019 17:53

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

  39. Bump version for v10.2 release

    Gravatar image committed: 15 Jun 2019 07:57 compiled: 15 Jun 2019 08:04

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

  40. Issue #296: enhance checkbox phrasing, and move it above to the other checkboxes

    Gravatar image committed: 12 Jun 2019 20:34 compiled: 12 Jun 2019 20:53

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

  41. Fix compiler warnings, and add documentation

    Gravatar image committed: 12 Jun 2019 20:15 compiled: 12 Jun 2019 20:25

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

  42. Cleartext syntax changes

    Gravatar image committed: 11 Jun 2019 23:17 compiled: 12 Jun 2019 20:23

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

  43. Add cleartext option to sessions

    Gravatar image committed: 11 Jun 2019 21:57 not compilable

  44. Issue #578: prefer Invalidate over Repaint, as the lists may not be displayed at all and may crash when forcing a repaint

    Gravatar image committed: 11 Jun 2019 07:16 compiled: 11 Jun 2019 07:25

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

  45. Table editor: root nodes in indexes and foreign key list are defined in BeforePaint event, so repaint these explicitly when table properties have been read. Closes #578.

    Gravatar image committed: 11 Jun 2019 07:11 compiled: 11 Jun 2019 07:23

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

  46. Define default values for port and username of all supported server types. Also, do not change them in the session manager, when user selects a different sub type of the same server.

    Gravatar image committed: 09 Jun 2019 09:27 compiled: 09 Jun 2019 09:53

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

  47. Issue #140: restore width and height of query tab editors along with their filename

    Gravatar image committed: 09 Jun 2019 08:39 compiled: 09 Jun 2019 08:53

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

  48. Report active theme name, so we are once probably able to remove some of them which are mostly unused, to speed up application start

    Gravatar image committed: 08 Jun 2019 09:19 compiled: 08 Jun 2019 09:23

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

  49. Remove unused variable

    Gravatar image committed: 08 Jun 2019 08:49 compiled: 08 Jun 2019 08:55

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

  50. Fix wrong position of dropped column on index tab. Closes #385.

    Gravatar image committed: 08 Jun 2019 08:48 compiled: 08 Jun 2019 08:53

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