- Home
- SQL Query Tools
- HeidiSQL
HeidiSQL
Neuenkirchen, Germany
What it 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 stay open in one window, including connections through 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 export directly from one server or database to another. Downloads cover Windows, Linux, and macOS, with Linux x64 and arm64 packages and a macOS arm64 app bundle. Windows users can choose a portable x64 edition. HeidiSQL was invented in 2002 by Ansgar Becker and is associated with Neuenkirchen, Germany. It requires a database server or SQLite file, and the requirements page describes Wine operation as unstable.
For and against
For
- Free software with no listed subscription
- Supports nine listed database systems
- SSH tunnels and SSL settings supported
- Exports rows to many structured formats
- Windows portable edition available
Against
- Requires a database server or SQLite file
- Wine operation is described as unstable
- Desktop client, not a hosted database service
The verdict
HeidiSQL offers broad database connectivity, editing tools, and export choices at no listed cost. Check that your operating system and database server fit its requirements, particularly if considering Wine.
Who it suits
HeidiSQL suits database users who need a free desktop client across Windows, Linux, or macOS. It fits work involving supported databases, SQL editing, data changes, and varied export formats.
Plans and prices
Free
Free software; connects to supported databases
Read 8 Oct 2026 · heidisql.com
On the record
- Client requirement
- HeidiSQL is a client application and requires an available database server or SQLite database file to connect to.heidisql.com · read 8 Oct 2026
- Connections
- It supports multiple connections in one window and connections through an SSH tunnel or SSL settings.heidisql.com · read 8 Oct 2026
- Cross database export
- HeidiSQL can export from one server or database directly to another server or database.heidisql.com · read 8 Oct 2026
- Database objects
- Users can create and edit tables, views, stored routines, triggers and scheduled events.heidisql.com · read 8 Oct 2026
- Database support
- The site lists MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL and Redshift as supported systems.heidisql.com · read 8 Oct 2026
- Data import and export
- It imports text files and exports table rows as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown or JSON.heidisql.com · read 8 Oct 2026
- Maker and location
- The site names Ansgar Becker as the author and lists his address in Neuenkirchen, Germany.heidisql.com · read 8 Oct 2026
- Origin
- The site says HeidiSQL was invented in 2002 by Ansgar.heidisql.com · read 8 Oct 2026
- Platform builds
- The downloads page offers builds for Windows, Linux and macOS, including Linux x64 and arm64 packages and a macOS arm64 app bundle.heidisql.com · read 8 Oct 2026
- Platform limitation
- The requirements page says running HeidiSQL through Wine is currently quite unstable and suggests its native Linux version as an alternative.heidisql.com · read 8 Oct 2026
- Portable edition
- A Windows x64 portable download is available alongside the installer.heidisql.com · read 8 Oct 2026
- Purpose
- HeidiSQL is database client software for connecting to databases and editing their data and structures.heidisql.com · read 8 Oct 2026
- Security settings
- The client supports SSH tunnels and SSL settings, including SSL certificate verification options documented for command-line connections.heidisql.com · read 8 Oct 2026
- SQL tools
- The query editor offers customizable syntax highlighting and code completion, and can reformat SQL.heidisql.com · read 8 Oct 2026
- Support
- The help page directs users who cannot find an answer to register in the forum and post a question.heidisql.com · read 8 Oct 2026
