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

Release date: 11 Dec 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. Detect foreign keys in MS SQL, and provide foreign values drop down in data grid. Closes #150

    Gravatar image committed: 26 Jan 2020 22:23 compiled: 26 Jan 2020 22:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  2. Enable cut/paste actions when any control is focused, except read-only SQL editors. Closes #592.

    Gravatar image committed: 25 Jan 2020 20:04 compiled: 25 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  3. Rename "Save as" menu item more intuitively to "Duplicate / save as". Closes #865

    Gravatar image committed: 23 Jan 2020 20:56 compiled: 23 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  4. Bring back table keys on MS SQL. See https://www.heidisql.com/forum.php?t=35446

    Gravatar image committed: 23 Jan 2020 20:48 compiled: 23 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  5. Issue #12: fix empty "ALTER code" tab on table editor for SQLite

    Gravatar image committed: 22 Jan 2020 15:20 compiled: 22 Jan 2020 15:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  6. Fix TDBConnection.GetTableColumns to get the length/set of a column on MSSQL and PG. Closes #864

    Gravatar image committed: 22 Jan 2020 15:19

  7. Issue #12: fix row count always -1 on SQLite, in "copy table" dialog

    Gravatar image committed: 22 Jan 2020 13:04 compiled: 22 Jan 2020 13:28

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  8. Performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest. Closes #804

    Gravatar image committed: 21 Jan 2020 20:39 compiled: 22 Jan 2020 12:27

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

  9. In SQL foreground and background color dropdown, set NoneColorColor to "clNone", to activate that "None" color. Also, include system colors in both dropdowns. Closes #840

    Gravatar image committed: 21 Jan 2020 19:33 compiled: 21 Jan 2020 19:57

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

  10. Mask SSH key passphrase in user prompt. Closes #863

    Gravatar image committed: 21 Jan 2020 19:21 compiled: 21 Jan 2020 19:27

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

  11. Detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema. Closes #842

    Gravatar image committed: 21 Jan 2020 19:13

  12. Add some debug log output to TMySQLConnection.GetTableKeys for debugging #856

    Gravatar image committed: 21 Jan 2020 18:55

  13. Fix always empty comment on PostgreSQL columns. Closes #859

    Gravatar image committed: 20 Jan 2020 19:48 compiled: 20 Jan 2020 19:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  14. Issue #12: remove "database." part from reference table in foreign key code, as this throws an error: near ".": syntax error. Makes "Create table copy" dialog compatible to SQLite, except for indexes yet

    Gravatar image committed: 19 Jan 2020 20:45 compiled: 19 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  15. Prefer CREATE code from SHOW CREATE TABLE in MySQL again, which includes table options which are yet unsupported in the generic TDBConnection.GetCreateCode .

    Gravatar image committed: 19 Jan 2020 13:48 compiled: 19 Jan 2020 13:56

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

  16. Issue #12: clear internal cache when closing an SQLite connection

    Gravatar image committed: 19 Jan 2020 13:26

  17. Finally, remove ParseTableStructure method, and use a text format of TTableColumn in the remaining caller "Paste columns"

    Gravatar image committed: 19 Jan 2020 13:25

  18. Issue #12: Support "find text on server" tool with compatible queries in SQLite

    Gravatar image committed: 19 Jan 2020 08:04 compiled: 19 Jan 2020 08:26

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  19. Issue #12: SQLite allows any column type declaration, even custom types.
    * support those declarations which are commonly used in other database systems, and for which Heidi has a fitting grid editor
    * move UNIQUEIDENTIFIER from text group to binary group
    * remove useless native type ids and empty descriptions

    Gravatar image committed: 19 Jan 2020 07:26 compiled: 19 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  20. Issue #12: detect UNIQUEIDENTIFIER column type, and sort that into the text type group

    Gravatar image committed: 18 Jan 2020 18:18 compiled: 18 Jan 2020 18:27

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

  21. Add missing CHAR datatype to SQLite column detection. Closes #858

    Gravatar image committed: 18 Jan 2020 08:19 compiled: 18 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  22. MSSQL: Fix not displayed column names of current table in data grid filter proposal, due to .QuotedName adding the Schema and detecting that as the database name

    Gravatar image committed: 18 Jan 2020 08:09

  23. Assign table columns and keys from the connection's database cache. Reduces internal queries to the minimum per table. Closes #852.

    Gravatar image committed: 17 Jan 2020 08:07 compiled: 17 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  24. Unify name and case of information_schema, per connection. Finally. Closes #855

    Gravatar image committed: 16 Jan 2020 08:03 compiled: 16 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  25. Issue #852: Implement Assign method on TTableColumnList and friends, TDBObject.LoadDetails and .UnloadDetails, and cross fingers that assigning details to Mainform.FActiveDbObj reduces the number of internal queries

    Gravatar image committed: 16 Jan 2020 07:40 compiled: 16 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  26. Issue #12: detect SQLite data type TEXT on result columns without rows. sqlite3_column_decltype() and sqlite3_column_type() already failed in such cases.

    Gravatar image committed: 16 Jan 2020 06:27 compiled: 16 Jan 2020 06:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  27. Issue #12: detect SQLite data type of non-table result columns, using sqlite3_column_type(). See https://stackoverflow.com/questions/59749418/sqlite-c-api-equivalent-to-typeofcol

    Gravatar image committed: 15 Jan 2020 22:48 compiled: 15 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  28. Issue #852: Return copy of once queried columns, keys and foreign keys object lists in TDBObject, instead of re-querying from database each time.

    Gravatar image committed: 15 Jan 2020 21:17 compiled: 15 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  29. Sort column names in data grid by their ordinal position. Closes #854

    Gravatar image committed: 15 Jan 2020 19:55 compiled: 15 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  30. Detect SQLite BOOL columns as TINYINT

    Gravatar image committed: 14 Jan 2020 21:15 compiled: 14 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  31. Separate join in TDBConnection.GetTableForeignKeys into two separate and faster queries. Closes #852

    Gravatar image committed: 14 Jan 2020 20:59

  32. Issue #12: Add support for foreign key dropdown in SQLite grid fields. Note that SQLite does not support LEFT(), while MSSQL does not support SUBSTR(), so here's a template per network type: spFuncLeft.

    Gravatar image committed: 13 Jan 2020 21:56 compiled: 13 Jan 2020 22:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  33. Fix some crashes, where the caller frees the result of GetTableColumns/Keys/ForeignKeys. Probably fixes #849 and #848

    Gravatar image committed: 13 Jan 2020 19:44 compiled: 13 Jan 2020 19:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  34. Detect static date/time values as text type, not expression. See https://www.heidisql.com/forum.php?t=35370

    Gravatar image committed: 13 Jan 2020 14:27

  35. Fix crash in suggest popup without table or view. Closes #848

    Gravatar image committed: 13 Jan 2020 14:13

  36. Issue #12: detect foreign keys of SQLite tables

    Gravatar image committed: 13 Jan 2020 12:17 compiled: 13 Jan 2020 12:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  37. Detect empty string without quotes as text default type. See https://www.heidisql.com/forum.php?t=35365

    Gravatar image committed: 13 Jan 2020 11:53 compiled: 13 Jan 2020 11:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  38. Issue #12: Implement TDBConnection.GetTableForeignKeys, failing on all db systems except MySQL. Closes #845

    Gravatar image committed: 12 Jan 2020 19:56 compiled: 12 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  39. Add sqlite file extension to database selector

    Gravatar image committed: 10 Jan 2020 20:30 compiled: 10 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  40. Issue #12: Implement TPgConnection.GetTableKeys, and now call GetTableColumns and GetTableKeys from GetCreateCode. TMySQLConnection should also use that, at least for tables.

    Gravatar image committed: 10 Jan 2020 08:11 compiled: 10 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  41. Issue #12: Get column comments in MSSQL back. See http://www.heidisql.com/forum.php?t=19576

    Gravatar image committed: 09 Jan 2020 21:27 compiled: 09 Jan 2020 21:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  42. Issue #12: restore compatibility to MySQL pre-5.0 servers, which have no IS.columns table

    Gravatar image committed: 09 Jan 2020 20:50 compiled: 09 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  43. Issue #12: restore compatibility to MySQL pre-5.5 servers, which have no "Index_comment" column in IS.columns

    Gravatar image committed: 09 Jan 2020 20:19 compiled: 09 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  44. Issue #12: Implement TDBConnection.GetTableColumns and .GetTableKeys (todo: .GetTableForeignKeys), as a replacement for the error prone ParseTableStructure. SQLite columns and keys should be parsed correctly now, MS SQL and PostgreSQL may now have some glitches to fix.

    Gravatar image committed: 08 Jan 2020 15:28 compiled: 08 Jan 2020 15:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  45. Restore previous logic: Allow empty result in TableName(Column), which is the case for data tab TEXT columns with LEFT(..) clause. Other columns may have a table name in that case. Closes #837

    Gravatar image committed: 03 Jan 2020 18:45 compiled: 03 Jan 2020 18:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  46. Do not set DataTypeCompatibility=80 in ADO connection string with old SQLOLEDB driver. Probably solves some connection issues, see https://www.heidisql.com/forum.php?t=35208

    Gravatar image committed: 03 Jan 2020 16:32 compiled: 03 Jan 2020 16:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  47. Issue #12: Proper implementation of TSQLiteQuery.ColIsPrimaryKeyPart()

    Gravatar image committed: 01 Jan 2020 19:12 compiled: 01 Jan 2020 19:27

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)

  48. Overload TDBQuery.TableName with TableName(Column), for future usage in ColIsPrimaryKeyPart and friends

    Gravatar image committed: 01 Jan 2020 18:51

  49. Issue #12: Call sqlite3_total_changes() after at least one call to sqlite3_step(), otherwise SQLite does not seem to execute a non-result query. Should make updates in data and query grid working now.

    Gravatar image committed: 01 Jan 2020 17:40 compiled: 01 Jan 2020 17:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  50. Add two newer header constants for MySQL/SSL, yet unused by HeidiSQL

    Gravatar image committed: 01 Jan 2020 11:59 compiled: 01 Jan 2020 12:28

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)