imported>WikiCleanerBot: v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation)

2025-05-19T04:01:55Z

v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation)

New page

{{Short description|Administration tool for relational databases}}
{{refimprove|date=September 2014}}
{{Infobox software
| name = HeidiSQL
| logo = HeidiSQL logo image.png
| screenshot = HeidiSQL main screenshot.png
| caption = Main view of a session, dark theme selected, with the database tree on the left and details on the right. "SQL Export" dialog in the foreground.
| collapsible =
| author = Ansgar Becker
| developer =
| released = {{start date and age|2006|04}}
| discontinued =
| latest release version = {{wikidata|property|edit|reference|P348}}
| latest release date = {{wikidata|qualifier|P348|P577}} ({{Time ago| {{wikidata|qualifier|raw|P348|P577}} }})
| latest preview version =
| latest preview date = 
| programming language = [[Delphi (programming language)|Delphi]] and [[Object Pascal]]/[[Lazarus (software)|Lazarus]]
| operating system = [[Microsoft Windows|Windows]] and [[Linux]]
| platform =
| size =
| language =
| repo = https://github.com/HeidiSQL/HeidiSQL
| genre = Database management
| license = [[GNU General Public License|GPLv2]]
| website = {{url|http://www.heidisql.com/}}
}}

'''HeidiSQL''' is a [[Free and open-source software|free and open-source]] administration tool for [[MariaDB]], [[MySQL]], as well as [[Microsoft SQL Server]], [[PostgreSQL]] and [[SQLite]]. Its [[codebase]] was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. After selling the MySQL-Front branding to an unrelated party, Becker chose "HeidiSQL" as a replacement. The name was suggested by a friend as a tribute to [[Heidi Klum]], and was further reinforced by Becker's own nostalgia for ''[[Heidi, Girl of the Alps]]''.

== History ==
{{Proseline section|date=July 2024}}
Ansgar Becker began development on a MySQL front-end in 1999, naming the project "MySQL-Front" and using a direct [[API]] layer written by Matthias Fichtner<ref>{{cite web |url = http://www.fichtner.net/delphi/mysql.delphi.phtml |title = Client API for MySQL Database Servers |publisher = audio-data.de |author = Matthias Fichtner |accessdate = 2014-12-01 |date = 2011-09-15 |archive-url = http://webarchive.loc.gov/all/20020808163649/http://www.fichtner.net/delphi/mysql.delphi.phtml |archive-date = 2002-08-08 |url-status = dead }}</ref> to interface with [[MySQL]] servers and the databases contained on them. Private development continued until 2003 with version 2.5.
In 2004, during a period of inactivity, Becker sold the MySQL-Front branding to Nils Hoyer, who continued development by [[clone (computing)|cloning]] the original software.<ref>{{cite web|url=https://www.heidisql.com/forum.php?t=20155|title=the truth about heidiSQL history in wikipedia|website=www.heidisql.com|access-date=2017-05-22|archive-date=2016-02-19|archive-url=https://web.archive.org/web/20160219031506/http://www.heidisql.com/forum.php?t=20155|url-status=live}}</ref><ref>{{cite web|url=https://www.heidisql.com/forum.php?t=23|title=Zu: Announcement: End of MySQL-Front ? Some words from...|website=www.heidisql.com|access-date=2018-11-13|archive-date=2018-11-13|archive-url=https://web.archive.org/web/20181113170202/https://www.heidisql.com/forum.php?t=23|url-status=live}}</ref>
In April 2006, Becker [[Open-source software|open-sourced]] the application on [[SourceForge]], renaming the project "HeidiSQL" due to having sold the MySQL-Front branding. HeidiSQL was re-engineered to use [[ZeosLib]], a newer and more popular database-interface layer, which debuted in version 3.0.
The name was suggested by a friend as a tribute to [[Heidi Klum]], and was further reinforced by Becker's own nostalgia for ''[[Heidi, Girl of the Alps]]''.<ref>{{cite web |title=heidi? |url=https://www.heidisql.com/forum.php?t=19 |url-status=live |archive-url=https://web.archive.org/web/20190331104119/https://www.heidisql.com/forum.php?t=19 |archive-date=2019-03-31 |access-date=2017-05-22 |website=www.heidisql.com}}</ref>

The database layer was again replaced by a single-unit approach{{Clarify|date=July 2024|reason="Single-unit" is not used elsewhere, so it's unclear what it means to return to this approach.}} in October 2009 by Becker. Later, this was again extended for supporting other database servers.
jHeidi—a version written in [[Java (programming language)|Java]] was designed to work on Mac and Linux computers—was discontinued in March 2010 in favor of [[Wine (software)|Wine]] support.
Support for [[Microsoft SQL Server]] was added in March 2011 for the 7.0 release.
Since the 8.0 release, HeidiSQL offers its GUI in about 22 languages other than English; translations are contributed by users from various countries via [[Transifex]].
[[PostgreSQL]] support was introduced in March 2014 for the 9.0 release.
In early 2018, a slightly extended v9.5 release was published on the [[Microsoft Store]].
[[SQLite]] support was introduced in March 2020 for the 11.0 release.<ref>{{cite web|url=https://www.heidisql.com/forum.php?t=35807|title=HeidiSQL 11.0 with SQLite support|website=heidisql.com|access-date=2023-05-15|archive-date=2023-05-15|archive-url=https://web.archive.org/web/20230515200549/https://www.heidisql.com/forum.php?t=35807|url-status=live}}</ref>
In May 2025, a first native Linux version was released,<ref>{{cite web |title=12.10.1.133 Linux pre-release |url=https://www.heidisql.com/forum.php?t=44068 |url-status=live |website=www.heidisql.com}}</ref> for which Becker converted the current Delphi sources to a [[Lazarus (software)|Lazarus]] compatible project structure.

== Features ==

HeidiSQL has the following GUI features and capabilities:<ref>{{cite web|publisher=HeidiSQL|url=http://www.heidisql.com/|title=Partial list of major features|accessdate=2014-12-01|archive-date=2017-04-15|archive-url=https://web.archive.org/web/20170415011243/https://www.heidisql.com/|url-status=live}}</ref><ref>{{cite web|publisher=HeidiSQL|url=http://www.heidisql.com/screenshots.php|title=Screenshots of GUI features and descriptions|accessdate=2014-12-01|archive-date=2017-04-06|archive-url=https://web.archive.org/web/20170406125110/https://www.heidisql.com/screenshots.php|url-status=live}}</ref>
* '''Server connection'''
** Multiple saved sessions with connection and credentials stored within
** Compressed client/server protocol for compatible servers
** Interface with servers via [[TCP/IP]], [[named pipes]] (sockets) or a [[tunneling protocol]] (SSH)
** Multiple parallelly running sessions in one window
** Manage users on the server: add, remove and edit users, and their credentials
** Manage user privileges globally and per database
** Export databases to SQL files or to other servers
** Multiple query tabs, with each one having multiple subtabs for batch results
* '''Server host'''
** View and filter all server variables, such as system_time_zone
** Edit all server variables, either for this session or with global scope
** View server statistical variables, and average values per hour & second
** Currently running processes to analyze executed SQL and to kill bad processes
** View command-statistics with percentage indicator bars per SQL command
* '''Databases'''
** View all databases on the server, connect to a single database to work with its tables and data
** View connected databases' total and table size in KB/MB/GB within the database/table tree structure
** Create new, alter existing databases' name, character set and collation, drop (delete) databases
* '''Tables, views, procedures, triggers and events'''
** View all objects within the selected database, empty, rename and drop (delete) objects
** Edit table columns, indexes, and foreign keys. Virtual columns on MariaDB servers are supported.
** Edit view query and settings
** Edit procedure SQL body and parameters
** Edit trigger SQL body and settings
** Edit scheduled event SQL body time settings

==See also==
* [[Comparison of database administration tools]]

==References==
{{Reflist}}

==External links==
* {{Official website}}

{{MySQL}}

[[Category:Database administration tools]]
[[Category:Windows-only free software]]
[[Category:MariaDB]]
[[Category:MySQL]]
[[Category:Microsoft database software]]
[[Category:2006 software]]
[[Category:Pascal (programming language) software]]

HeidiSQL - Revision history

imported>WikiCleanerBot: v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation)