• Home
• Downloads
  • Installer
  • Portable
  • Portable-64
  • App
  • Source
  • Nightly builds
• Images
  • Screenshots
  • Themes
• Forum
  • 06 Sep - pedro: Connecting to MySQL on Siteground
  • 05 Sep - ansgar: Scroll bar resets/jumps back to start be ...
  • 04 Sep - ansgar: Lost Triggers
  • 03 Sep - rimsha99: Namecheap coulnt connect on shared hos ...
  • 02 Sep - Ukiocsmo: Arabic Letter & Ligature
  • 30 Aug - FriFra: Bad Handshake
  • 30 Aug - rimsha99: Migrating hosted databases
  • 30 Aug - Patrick: Link/Git for current portable version?
  • 27 Aug - MrMix: Copy data fm one table to another
  • 26 Aug - ansgar: Groups in the project tree.
  • 25 Aug - mrbump: ORDER BY clause not observed in query re ...
  • 25 Aug - venyn29: problem import sql
  • 24 Aug - ansgar: MariaDB still bundles old HeidiSQL
  • 23 Aug - Pegas: suggestion for improvement
  • 22 Aug - MrMix: Comparing structure of two tables
  • 20 Aug - sandztorm33: update error
  • 19 Aug - David Marcus: Bad handshake
  • 15 Aug - Matthijstb7: VDS database doesn’t connect with ...
  • 14 Aug - finbar: Warning Flag on Database Drop
  • 14 Aug - ansgar: Logging Area Displaying Junk Characters
• Donate
  • How to donate
  • List of donors
• Bugtracker
  • Milestone Roadmap
  • Bug reports
  • Feature requests
  • Enhancement requests
• Help
  • Requirements
  • Connecting to a server
  • Command line switches
  • The database tree
  • Creating a table
  • Creating a view
  • Creating a stored procedure
  • Creating a trigger
  • Creating a scheduled event
  • The Data tab
  • Running SQL queries
  • SQL export
  • Importing files
  • HeidiSQL portable
  • License
  • Credits

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. Current Delphi version for compiling HeidiSQL is v12.1.

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

News

• 17 Jul Compiler update to Delphi 12.1

  All upcoming HeidiSQL builds and releases will use the latest Delphi 12.1 compiler from Embarcadero. This should definitely raise quality, probably even fix some bugs. If you like to compile HeidiS ...

• 11 Jul HeidiSQL 12.8 with support for encrypted SQLite databases and SSL/MySQL bugfixes

  Get it from the download page 3rd party updates: Issue #1946: update C connector / libmariadb.dll and plugin libraries to latest v3.3.10 New stuff: Issue #1284: add support for encrypted SQLite ...

• 05 May HeidiSQL 12.7 with support for descending indexes, filter boxes in table tools, JSONL export, and more

  Get it from the download page 3rd party updates: Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8 Update regular expression library to v1.181 2023.11.22, supporting \K pat ...

• 27 Nov Official Instagram profile

  Thanks to my daughter HeidiSQL now has an official Instagram profile: https://www.instagram.com/heidisql.official/ Mainly used for screenshots of HeidiSQL, especially of certain dialogs which are r ...

• 05 Nov HeidiSQL 12.6 with two new SQL formatters and static grid row id

  Get it from the download page 3rd party updates: Update madExcept exception handler to v5.1.3 Upgrading to Delphi compiler version 11.3 Update VirtualTrees component code to release v7.6.5a Updat ...

Features

• Free for everyone, OpenSource
• Connect to multiple servers in one window
• Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase and Firebird
• 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
• Import text-files
• Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
• 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