Download HeidiSQL 8.0 stable

HeidiSQL runs fine on Windows (XP, Vista, 7, 8) and on any Linux with Wine. On Windows 2000 you might run into some "illegal function call into KERNEL.DLL", which is caused by the newer libmysql.dll which dropped Win2k support. You can fix that by downloading this older one and place it in the HeidiSQL directory, overwriting the original. Previous releases can be downloaded at Google Code.

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.

Link to latest build   RSS Feed Changes Feed

Revision Committed Notes Compiled .EXE Installer
4400 13 hours ago

Put session name into caption of login-on-demand dialog, so applications like Keepass can identify it. Fixes issue #3180.

Application form 6,669 KB
293 downloads
Package 4,052 KB
161 downloads
4399 14 hours ago

Do not restore previous state of checkbox options "Drop database" and "Drop tables", leave them off when calling the export sql dialog. Fixes issue #3197.

Application form 6,669 KB
11 downloads
Package 4,052 KB
6 downloads
4398 14 hours ago

Leave SQL help action disabled as long as there is no selected connection. Fixes issue #3200.

Application form 6,669 KB
6 downloads
Package 4,052 KB
5 downloads
4397 2 days ago

Introduce server specific quote characters, so ParseTableStructure() and DeQuoteIdent() do not remove too much.
* bug report: http://www.heidisql.com/forum.php?t=12685
* broken in r4368, for fixing issue #2496

Application form 6,668 KB
980 downloads
Package 4,052 KB
629 downloads
4396 7 days ago

Modify installer sidebar image for the next release.

Application form 6,667 KB
1,713 downloads
Package 4,051 KB
3,086 downloads
4395 7 days ago

Prepare release: Update major version to 8

Application form 6,667 KB
44 downloads
Package 4,075 KB
72 downloads
4394 7 days ago

Support default values of BIT columns in table editor and SQL export. Fixes issue #2544.

Application form 6,667 KB
17 downloads
Package 4,075 KB
11 downloads
4393 1 week ago

Give the datagrid-truncation cast a length of 256 in MSSQL, so we don't just get the CAST default of 30 chars. Fixes issue #3186.

Application form 6,667 KB
1,240 downloads
Package 4,075 KB
610 downloads
4392 2 weeks ago

Expect dots in database and table names, when parsing SHOW GRANTS results. See http://www.heidisql.com/forum.php?t=12640

Application form 6,667 KB
4,242 downloads
Package 4,075 KB
2,300 downloads
4391 2 weeks ago

Turn column default text memo into a TButtonedEdit, and use a right button drop down menu which displays ENUM and SET values. Fixes the ENUM+SET part of issue #1160.

Application form 6,667 KB
858 downloads
Package 4,075 KB
400 downloads
4390 1 month ago

Use internal flag to remember whether we have a NULL value when copying and pasting in grid fields. Fixes issue #3171.

Application form 6,654 KB
9,740 downloads
Package 4,070 KB
6,720 downloads
4389 1 month ago

Add "Global" column to ListVariables, and highlight values different to their session pendant.

Application form 6,654 KB
4,588 downloads
Package 4,069 KB
2,403 downloads
4388 1 month ago

Use "times" symbol × instead of the letter x. See http://www.heidisql.com/forum.php?t=12543

Application form 6,652 KB
1,225 downloads
Package 4,069 KB
523 downloads
4387 1 month ago

Block "Empty tables" action if neither dbtree nor dbtab has focus. Fixes issue #3166.

Application form 6,652 KB
323 downloads
Package 4,069 KB
138 downloads
4386 1 month ago

Append number of columns and rows in query result tab caption. See http://www.heidisql.com/forum.php?t=12543

Application form 6,652 KB
88 downloads
Package 4,069 KB
37 downloads
4385 1 month ago

Fix repeated column comment in table editor. See http://www.heidisql.com/forum.php?t=12540

Application form 6,652 KB
893 downloads
Package 4,069 KB
336 downloads
4384 1 month ago

Fix wrong offset in db.table string when checking for foreign key match. Fixes issue #3160.

Application form 6,652 KB
552 downloads
Package 4,069 KB
349 downloads
4383 1 month ago

Try a new approach in TDBConnection.ParseRoutineStructure(). Should fix stripped backslashes from routine body, issue #3107.
* Use SHOW CREATE PROCEDURE/FUNCTION result again, instead of code from IS.ROUTINES
* Remove every known CREATE PROCEDURE/FUNCTION clause and use remaining text as routine body.
* Respect MS SQL function options, taken from http://msdn.microsoft.com/en-us/library/ms186755.aspx
* Introduce helpers.ExtractComment() for usage in ParseRoutineStructure() and ParseTableStructure

Application form 6,636 KB
1,651 downloads
Package 4,062 KB
739 downloads
4382 1 month ago

Revert helpers.RemoveComments(), accidentally committed in r4110

Application form 6,636 KB
67 downloads
Package 4,062 KB
30 downloads
4381 2 months ago

MSSQL stored routine editor:
* Extend TAdoDBConnection.GetCreateCode for stored routines
* Extract the relevant routine code in TDBConnection.ParseRoutineStructure
* Match database name against ROUTINES.ROUTINE_CATALOG (not ROUTINE_SCHEMA). See http://www.heidisql.com/forum.php?t=12435 .

Application form 6,612 KB
5,763 downloads
Package 4,051 KB
3,254 downloads
4380 2 months ago

Auto apply distinct accelerator chars to buttons on TTaskDialog. Fixes issue #3150.

Application form 6,610 KB
1,006 downloads
Package 4,050 KB
444 downloads
4379 2 months ago

Grid export: Remove zero padding to avoid octal => integer conversion in PHP. Fixes issue #3149.

Application form 6,610 KB
1,630 downloads
Package 4,049 KB
653 downloads
4378 2 months ago

Accept column rename when it has the same name as a deleted column. Fixes issue #3137.

Application form 6,610 KB
1,031 downloads
Package 4,050 KB
429 downloads
4377 2 months ago

Mark table key as modified after editing its contained column names, so such changes get posted to the server when clicking "Save". Fixes issue #3144.

Application form 6,610 KB
10 downloads
Package 4,050 KB
14 downloads
4376 2 months ago

Ignore errors due to non existent columns in IS.ROUTINES on MSSQL. See http://www.heidisql.com/forum.php?t=12435

Application form 6,610 KB
17 downloads
Package 4,050 KB
17 downloads
4375 2 months ago

Check KeepAskingSetting in MessageDialog() on older Windows versions. Broken since r4302. Fixes issue #3147.

Application form 6,610 KB
1,378 downloads
Package 4,050 KB
653 downloads
4374 2 months ago

Propose column names from selected table in filter panel. Fixes issue #3140.

Application form 6,609 KB
2,406 downloads
Package 4,049 KB
1,149 downloads
4373 2 months ago

Return focused tree item in GetFocusedObjects() even if tree is not focused, in cases where database tab does not has focus. Fixes issue #3146.

Application form 6,609 KB
31 downloads
Package 4,049 KB
23 downloads
4372 2 months ago

Same as r4304: Fix broken drop down buttons on main toolbar, now that MainFormOnTaskBar is missing.

Application form 6,589 KB
3,389 downloads
Package 4,043 KB
1,841 downloads
4371 2 months ago

Remove MainFormOnTaskBar, revert r3763, to fix issue #2640. Disables support for Windows Flip3D, but who cares.

Application form 6,589 KB
36 downloads
Package 4,043 KB
40 downloads
4370 2 months ago

Cast TEXT columns as VARCHAR in data grid selection, as MSSQL supports only VARCHAR in LEFT() function. Fixes issue #3141.

Application form 6,589 KB
2,686 downloads
Package 4,043 KB
1,258 downloads
4369 2 months ago

Issue #2697: Make database + table tree filter case insensitive. See pm from Martin Bedrač.

Application form 6,589 KB
482 downloads
Package 4,043 KB
242 downloads
4368 2 months ago

Issue #2496: Revert r4366, do not trim definition of MS SQL views. Instead, let the regex in ParseViewStructure() expect CREATE at any point instead of the very beginning of the code. That way the view definition may contain a BOM or any space at the start.

Application form 6,589 KB
98 downloads
Package 4,043 KB
69 downloads
4367 2 months ago

Move code from several action events to new functions GetFocusedObjects and DBTreeClicked. Detect here whether tree or database tab was the one where user clicked the context menu, instead of just checking which of both is focused. See http://www.heidisql.com/forum.php?t=12351

Application form 6,589 KB
570 downloads
Package 4,044 KB
311 downloads
4366 2 months ago

Issue #2496: Trim definition of MS SQL VIEWS before passing to ParseViewStructure(), so its regex may expect CREATE at the very beginning.

   
4365 2 months ago

Issue #2496: Remove square brackets per TDBConnection.DeQuoteIdent()

   
4364 2 months ago

Issue #2496: Support square brackets in MSSQL as an alternative way to quote identifiers.

   
4363 2 months ago

Vtree does not focus cell after tab pressing. Do that by hand in TMainForm.AnyGridFocusChanged. Fixes issue #3139.

   
4362 3 months ago

Rename translation as done in dfm file in r4312

   
4361 3 months ago

Distinct between traditional and simplified Chinese, add zh_TW translated by jeff.tu.

   
4360 3 months ago

Complete list of contributers in about dialog

   
4359 3 months ago

Rename local variable to what it stands for.

   
4358 3 months ago

Display number of selected nodes from ListTables in status bar. Fixes issue #3127.

   
4357 3 months ago

Include database name in GetCreateViewCode(). Fixes issue #3098.

   
4356 3 months ago

Issue #2697: Move pnlTreeFilter to top.

   
4355 3 months ago

Add missing translation string for r4350.

   
4354 3 months ago

Make use of property writer SetCreateCode, and display errors in SQL log when GetCreateCode failed.

   
4353 3 months ago

Indicate previously selected tables with a non-ghosted icon in the tree, while leaving never selected ones ghosted.

   
4352 3 months ago

Display timestamp in very right status bar panel when executing a query. See http://www.heidisql.com/forum.php?t=12287

   
4351 3 months ago

Issue #2496: Retrieve VIEW definition from IS.VIEWS, so ParseViewStructure() can parse that code. TODO: Support ALTER command.

   
4350 3 months ago

Add right click menu item for clearing data tab filter on current table. Fixes issue #3125.

   
4349 3 months ago

Fix updating empty binary column value.

   
4348 3 months ago

Make usage of query history optionally. Fixes issue #3122.

   
4347 3 months ago

Add missing DATE and TIME datatypes for MS SQL. Fixes issue #2957.

   
4346 3 months ago

Remove code from TDBQuery.GetKeyColumns which gracefully allows result editing with a partially selected primary key. Fixes issue #2974.

   
4345 3 months ago

Add missing translation strings for db and table filter

   
4344 3 months ago

Turn comboDatabaseFilter into a TButtonedEdit, and place a second one besides it, for filtering tables. Fixes issue #2697.

   
4343 3 months ago

Support BIT data type in MS SQL. Fixes issue #2955.

   
4342 3 months ago

Reposition default value editor so it's not outside the main form. Fixes issue #2868.

   
4341 3 months ago

Make detection of active grid or editor in search/replace dialog more stable.

   
4340 3 months ago

Detect primary and unique keys on MS SQL tables. Makes grid updates safer, and these keys show up in the table designer. Fixes issue #2946.

   
4339 3 months ago

Store last sessions also when connecting to an additional session, not only when closing the program. See http://www.heidisql.com/forum.php?t=12149

   
4338 3 months ago

Add missing translation string, for r4322.

   
4337 3 months ago

Let ParseRoutineStructure() cache values from IS.ROUTINES into TDBObject members. Fixes issue #3108.

   
4336 3 months ago

Grid export: Export quoted empty string when blob value is empty (SQL INSERTS/REPLACES). Fixes issue #2941.

   
4335 3 months ago

Create database dialog: Remove charset pulldown, leave collation pulldown alone. Init collation pulldown with the server variable "collation_server".

   
4334 3 months ago

Support old style "TYPE BTREE" in table index code. See http://www.heidisql.com/forum.php?t=12150

   
4333 3 months ago

Get everything except routine parameters from IS.ROUTINES, to fix another regular expression problem in ParseRoutineStructure. Fixes issue #3114.

   
4332 3 months ago

Add missing tool tip hint for disconnect button.

   
4331 3 months ago

Create save/open dialogs per code, not per dfm file. That way, I can remove strings like "SQL files (*.sql)..." from the translation, and only let "SQL files" get translated. Avoids translation errors.

   
4330 3 months ago

SQL export dialog: Arrange controls so translated items fit.

   
4329 3 months ago

Enable OK button when checking "Reset autoincrement" check box. See http://www.heidisql.com/forum.php?t=12143

   
4328 3 months ago

Fix setting for name of selected database, which must be a session setting, not a global one. See http://www.heidisql.com/forum.php?t=12101

   
4327 3 months ago

Finally fix ramshackle detection of routine body. Fixes issue #3103, #3104.

   
4326 4 months ago

Work around empty body detected in ParseRoutineBody, and get it from information_schema.ROUTINES in that case. See http://www.heidisql.com/forum.php?t=12075 .

   
4325 4 months ago

Issue #400: Compare data types and unsigned flags of source and reference columns, when leaving foreign column editor. Introduce a more helpful error message when these do not match, as a replacement for the servers poor message "Foreign key constraint is incorrectly formed".

   
4324 4 months ago

Increase height of memoFindText from 26 to 60 pixels. Accidentally resized to a minimum in r4254. See http://www.heidisql.com/forum.php?t=12064

   
4323 4 months ago

Hide non-InnoDB tables in foreign key editor. See http://www.heidisql.com/forum.php?t=11816

   
4322 4 months ago

Make foreign values drop down optionally. See http://www.heidisql.com/forum.php?t=11816

   
4321 4 months ago

No need to rethink height of SQL memos and SQL log when window is minimized. Fixes issue #3093.

   
4320 4 months ago

r4185 broke Host > Variables tab for MSSQL. Introduce SQL specifity for SHOW VARIABLES to fix that. Fixes issue #3100.

   
4319 4 months ago

Strip routine body early in ParseRoutineStructure, so later regular expressions don't get confused by keywords in user SQL. Fixes issue #3085.

   
4318 4 months ago

Display child count on group nodes. Fixes issue #2912.

   
4317 4 months ago

Enable right click options for creating new objects when one of the grouping nodes is focused. Fixes issue #2964.

   
4316 4 months ago

Launch command line: Escape double quotes in password, and fix broken replacement with stars if password contains double quotes. See http://www.heidisql.com/forum.php?t=11976

   
4315 4 months ago

Revert *.res inclusion from previous commit, to fix compile error "E1026 File not found: 'VirtualTreesR.res'"

   
4314 4 months ago

Update VirtualTree component code to 5.1.0 (r450)

   
4313 4 months ago

Quote db and table name in new function TDBObject.QuotedDbAndTableName, which also adds "dbo" for MS SQL inbetween. Plus, run SELECT in SQL export through ApplyLimitClause, to fix an SQL error on MS SQL. See http://www.heidisql.com/forum.php?t=11956

   
4312 4 months ago

Support search/replace in data and result grids. Fixes issue #2979.

   
4311 4 months ago

Ignore error at connection time on MS Azure servers without sysprocesses table. Fixes issue #3087.

   
4310 4 months ago

Disallow to drag a session folder somewhere below itself, which would end up in an infinite folder structure, theoretically. Fixes issue #3086.

   
4309 4 months ago

Fix minor memory leak

   
4308 4 months ago

Remove "Created" date/time from SQL export header. Fixes issue #3083.

   
4307 4 months ago

Ensure row count step + maximum settings are never "0". Fixes issue #3080.

   
4306 4 months ago

Fix broken SynEdit compilation: Include added files in project files.

   
4305 4 months ago

Update SynEdit component sources to r100 from https://synedit.svn.sourceforge.net/svnroot/synedit/SynEdit

   
4304 5 months ago

Work around broken ToolButton with Style=tbsDropDown after translation: https://sourceforge.net/tracker/index.php?func=detail&aid=902470&group_id=74086&atid=539908
Fixes issue #3066.

   
4303 5 months ago

Add new translation strings, forgotten in previous commit.

   
4302 5 months ago

Introduce "KeepAskingSetting" parameter to MessageDialog(), which activates a verification checkbox left besides the dialog buttons. Use that when confirming to close a query tab, so the user can disable the dialog within the dialog itself, without the need to disable this setting in Preferences > SQL. Fixes issue #3065, which was broken since r4283.

   
4301 5 months ago

Ensure we do not send an empty query, if a single query is larger than the max_allowed_packet setting. This way, we most probably get disconnected anyway, but that clearly leaves responsibility to the user to make the query smaller.