Download HeidiSQL 7.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
4393 1 day 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,034 downloads
Package 4,075 KB
489 downloads
4392 1 week 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,230 downloads
Package 4,075 KB
2,286 downloads
4391 1 week 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
854 downloads
Package 4,075 KB
397 downloads
4390 4 weeks 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,728 downloads
Package 4,070 KB
6,702 downloads
4389 1 month ago

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

Application form 6,654 KB
4,582 downloads
Package 4,069 KB
2,395 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,220 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
135 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
70 downloads
Package 4,069 KB
35 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
334 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
347 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,637 downloads
Package 4,062 KB
730 downloads
4382 1 month ago

Revert helpers.RemoveComments(), accidentally committed in r4110

Application form 6,636 KB
66 downloads
Package 4,062 KB
25 downloads
4381 1 month 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,755 downloads
Package 4,051 KB
3,249 downloads
4380 1 month ago

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

Application form 6,610 KB
1,002 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,628 downloads
Package 4,049 KB
651 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,028 downloads
Package 4,050 KB
427 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
9 downloads
Package 4,050 KB
12 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
15 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,375 downloads
Package 4,050 KB
651 downloads
4374 2 months ago

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

Application form 6,609 KB
2,401 downloads
Package 4,049 KB
1,145 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
28 downloads
Package 4,049 KB
18 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,382 downloads
Package 4,043 KB
1,840 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
29 downloads
Package 4,043 KB
39 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,681 downloads
Package 4,043 KB
1,245 downloads
4369 2 months ago

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

Application form 6,589 KB
480 downloads
Package 4,043 KB
239 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
88 downloads
Package 4,043 KB
66 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
562 downloads
Package 4,044 KB
307 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.

Application form 6,588 KB
56 downloads
Package 4,043 KB
57 downloads
4365 2 months ago

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

Application form 6,588 KB
288 downloads
Package 4,042 KB
115 downloads
4364 2 months ago

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

Application form 6,588 KB
653 downloads
Package 4,043 KB
225 downloads
4363 2 months ago

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

Application form 6,588 KB
1,109 downloads
Package 4,042 KB
422 downloads
4362 2 months ago

Rename translation as done in dfm file in r4312

   
4361 2 months ago

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

   
4360 2 months ago

Complete list of contributers in about dialog

   
4359 2 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 3 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 3 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 3 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 3 months ago

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

   
4322 3 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 4 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.

   
4300 5 months ago

Read and write snippet files in a subdirectory of the application directory when in portable mode. Fixes issue #2980.

   
4299 5 months ago

Add missing item captions for translation, from "New" drop down button on session manager. See issue #557.

   
4298 5 months ago

Ignore TFont when translating main form, so "Default" does not get broken, for XP users. Fixes issue #3064.

   
4297 5 months ago

Add new caption introduced by second to last commit.

   
4296 5 months ago

Fix file open dialog file filter, so it gets translated like its similar dialogs.

   
4295 5 months ago

Preparation for issue #3002: Move startup script and local time zone options together with SSL settings to a new "Advanced" tab.

   
4294 5 months ago

Widen "Bold" checkbox in highlighter options dialog, so translations fit into it. See issue #557.