What is HeidiSQL?

HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained.

The Windows version of HeidiSQL is currently built with Delphi 12.3. Lazarus v4.4 is used for compiling the Linux and macOS releases.

Download HeidiSQL, read further about features, take part in discussions or see some screenshots.

News

        ## 22 Jun HeidiSQL 12.20 bugfix releaseGet it from the download page Notable changes fix: reveal procedures and function in MySQL which are stored with correct case in mysql.proc feat: support some keywords like CURRENT_TIMESTAMP in S ...

        ## 20 Jun HeidiSQL 12.19 with Linux arm64 build and bugfixesGet it from the download page Notable changes ci: provide a QT6 binary for Linux arm64 / RaspiOS enhance: pass LogLevel=error to the SSH command line fix: crash in grid export with no focused col ...

        ## 09 Jun HeidiSQL 12.18 with authentication plugins in user managerGet it from the download page Notable changes feat: support authentication plugin selection in user manager, and fix complaint about invalid password length on user plugins which have no fixed pa ...

        ## 12 Apr HeidiSQL 12.17 with user role management, ENUMs on PostgreSQL, and invisible indexesGet it from the download page Notable changes Supports creating roles on MariaDB in the user manager Supports ENUM column types in table designer and data grid on PostgreSQL Support for invisible ...

        ## 10 Mar HeidiSQL 12.16 with reverse foreign keys, Display main menu, row count on MSSQL and SQLiteGet it from the download page Notes: You can already get a preview of v13 for Windows, built on the same codebase as the Linux version. See the download page for a zip package. Ubuntu 24.04 needs ...

Features

Free, OpenSource, for all major platforms: Windows, Linux and macOS
Multiple connections in one window
Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL, Redshift
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges with roles and authentication plugins
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown and JSON
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

HeidiSQL users with enabled statistics feature work on these servers:

        The author: Ansgar Becker