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.
v10.3 [Dec 13, 2019]
New features and enhancements in this version:
- Theme preview in preferences dialog.
- "Library" dropdown in session manager, to enhance support for older and newer MySQL and MariaDB versions.
- Various new shortcuts in the "Go to" menu, e.g. for switching between result and query area.
- Support newer plink versions for SSH tunneled connections.
- Grid rightclick on cell: "Open in webbrowser" for fields containing a web url.
- Support for client_ed25519 MariaDB plugin.
- Support for SSH tunneled connections to PostgreSQL servers.
- Support for SSL on PostgreSQL servers.
- "Same text" background color in grid now applies to neigbour fields in selected row as well.
- Support for connections to Amazon Redshift (basically older PostgreSQL servers).
- Restored query tabs also restore bind parameters.
- New option in grid export dialog: "Remove linebreaks from data".
- New option to remove DEFINER clauses in SQL export option drop-down.
- Increase compatibility of table editor on PostgreSQL.
Bugfixes:
- Reverts earlier attempts for native high DPI support, so scaling is done by Windows again (blurry but less buggy).
- Auto-detected Chinese localization fixed.
- Compatibility to MySQL 4 restored.
- Various fixes for SSL on MySQL and MariaDB.
- Fixed broken "undo" after auto-uppercased SQL keyword.
- Fixed crash when switching to table/database with same name on different server.
- Fixed invisible column comments on PostgreSQL.
- Fixed unsupported def.adsrc on PostgreSQL 12.
- Ctrl Backspace in text boxes deletes left word, instead of writing cryptic character.
- Fixed update SQL for JSON columns in PostgreSQL.
- Fixed disappearing table comments after saving.
- Fixed warning about unsafe query when fooled with a commented WHERE clause.
Feature-rich relational database known for its high performance and excellent concurrency
