Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

HeidiSQL

heidisql.com

  • Free plan
  • Windows
  • macOS
  • Linux
7.7 Club score Visit heidisql.com

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

Free

Free

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.