Connects, manages, and organizes the database structure for supported SQL-based applications like MySQL, Microsoft SQL, and PostgreSQL. Provides the tools to export the entire database structure locally, or remotely on the other supported servers and edit it accordingly (edit, copy, paste, table altering, procedures, scheduled events).
HeidiSQL it's a program developed by Ansgar Becker for developers and administrators that have to deal with MySQL databases at their working sites.
It comes wrapped in an old-fashioned interface, one that reminds of Windows XP, but which embeds lots of functions and commands and it's highly responsive to user commands. It has some font and background color customizations but unfortunately has no other themes than the default one. Also, another downside it's the miss of a built-in debugger.
Speaking about functionalities, the program offers a wide variety of facilities for database management. With HeidiSQL is possible to run and establish several databases at once, thus making creation and editing of tables much easier.
Moreover, the program offers the tools to create and run custom queries, where you can give permissions for every user to access the databases.
Besides that, you can export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array, write queries with customizable syntax-highlighting and code-completion or bulk edit tables.
HeidiSQL also offers the option to export and import settings with just one click, therefore exporting and synchronizing SQL databases becomes easier to do.
All in all, this software program delivers what developers and administrators would expect: a highly responsive system with lots of functionalities. Above that, it's free and it's constantly improved and updated.
v11.0 [Mar 19, 2020]
New features and enhancements in this version:
- Support connecting to SQLite database files.
- drop schema support for PostgreSQL.
- support foreign keys in PostgreSQL.
- support foreign keys in MS SQL.
- read-only mode for grid cell editors, if underlying query or table does not allow updates.
- support scram-sha-256 authentication on PostgreSQL.
- enhanced readability of release notes.
- enhanced readability of help links with dark themes.
- support column comments of PostgreSQL.
- support disabling "Full table status" on PostgreSQL.
- new filter edit box on session manager, for filtering sessions using regular expressions.
- close query tabs via middle mouse click.
- trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting.
- sort collation drop down on "Bulk table editor" alphabetically.
- place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable.
- performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
- widen buttons on search/replace dialog by one quarter, so translations fit better on them.
- use default library of given network type in command line receiver.
- refreshed application icon.
Bugfixes:
- fix crashes when restoring tabs: expect no UTF-8 BOM.
- Procedure body changes invisible when parameter tab is active.
- last active session was no longer scrolled into view area of session manager.
- crash when mouse moves over data grid with broken connection.
- clicking too fast on session folder opens connection instead of collapse.
- passphrase input for SSH tunnel now masked.
- 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.
- fix crash when accessing data from data tab on a disconnected session.
- fix crash when active main tab changes and data grid is disabled (due to disconnect).
- make copy/cut safer against harmless crashes, and show occurring error messages in log panel.
- MSSQL: Remove surrounding parentheses from default value.
- fix state of checkboxes on the session manager's Advanced tab.
- fix crash by click on "Add column" in table editor, when columns list has a minimum height.
Third party libraries and components:
- update libmariadb.dll to v3.1.7.
- update libpq.dll to v10.0.11.
- introduce additional libpq.dll v12.0.1.
- update InnoSetup compiler to v6.0.3.
- update VirtualTree component to v7.3.
- introduce sqlite3.dll v3.30.1.
Feature-rich relational database known for its high performance and excellent concurrency
