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 
-
09 Jun HeidiSQL 12.18 with authentication plugins in user manager
Get 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 indexes
Get 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 SQLite
Get 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 ...
-
30 Jan HeidiSQL 12.15 for Windows, Linux and macOS
Get it from the download page Note: 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. Bugfixes and enhancem ...
-
16 Dec MacOS app bundle, first preview release
I managed to create an app bundle for macOS / arm64, including code signing certificates. It's at a very early stage, and only few issues have been taken care for yet. No support for MS SQL, and no ...
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
