HeidiSQL
heidisql.com
- Free plan
- Windows
- macOS
- Linux
What HeidiSQL is
HeidiSQL is free desktop client software for connecting to databases and editing their data and structures. It supports MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL, and Redshift. Multiple connections can remain in one window, including connections using SSH tunnels or SSL settings. Users can create and edit tables, views, stored routines, triggers, and scheduled events. The query editor provides customizable syntax highlighting, code completion, and SQL reformatting. HeidiSQL imports text files and exports table rows as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown, or JSON. It can also transfer exports directly between servers or databases. Downloads include Windows, Linux, and macOS builds, with Linux x64 and arm64 packages, a macOS arm64 bundle, and a Windows x64 portable edition. HeidiSQL requires a database server or SQLite file. The requirements page describes Wine operation as unstable and suggests native Linux instead.
Who it suits
HeidiSQL suits database users who need a free desktop client across Windows, Linux, or macOS. It is useful when connections, SQL editing, and many export formats are required.
Good to know, and what to watch
- Supports nine listed database systems
- Multiple connections in one window
- SSH tunneling and SSL settings
- Many table export formats
- Windows portable edition available
- Requires a database server or SQLite file
- Wine use is described as unstable
- It is client software, not a database server
Plans
Every plan and priceFree
Free plan
The verdict
HeidiSQL combines broad database support with editing, SQL authoring, connection options, and extensive exports. Check its connection requirement and the Wine limitation before choosing a deployment approach.
What the maker publishes
- Client requirement
- HeidiSQL is a client application and requires an available database server or SQLite database file to connect to. source
- Connections
- It supports multiple connections in one window and connections through an SSH tunnel or SSL settings. source
- Cross database export
- HeidiSQL can export from one server or database directly to another server or database. source
- Database objects
- Users can create and edit tables, views, stored routines, triggers and scheduled events. source
- Database support
- The site lists MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL and Redshift as supported systems. source
- Data import and export
- It imports text files and exports table rows as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown or JSON. source
- Founded
- 2002 source
- Headquarters
- Neuenkirchen, Germany source
- Maker and location
- The site names Ansgar Becker as the author and lists his address in Neuenkirchen, Germany. source
- Origin
- The site says HeidiSQL was invented in 2002 by Ansgar. source
- Platform builds
- The downloads page offers builds for Windows, Linux and macOS, including Linux x64 and arm64 packages and a macOS arm64 app bundle. source
- Platform limitation
- The requirements page says running HeidiSQL through Wine is currently quite unstable and suggests its native Linux version as an alternative. source
- Portable edition
- A Windows x64 portable download is available alongside the installer. source
- Purpose
- HeidiSQL is database client software for connecting to databases and editing their data and structures. source
- Security settings
- The client supports SSH tunnels and SSL settings, including SSL certificate verification options documented for command-line connections. source
- SQL tools
- The query editor offers customizable syntax highlighting and code completion, and can reformat SQL. source
- Support
- The help page directs users who cannot find an answer to register in the forum and post a question. source
Checked against the maker's pages on 8 Oct 2026.