• Home
• Downloads
  • Installer
  • Portable
  • Portable-64
  • App
  • Source
  • Nightly builds
• Images
  • Screenshots
  • Themes
• Forum
  • 07 Dec - ansgar: SQL results: all cells change to "N ...
  • 06 Dec - ansgar: Option to disable "SSL inactive&quo ...
  • 05 Dec - ansgar: SQL Syntax Error 1064 Help
  • 05 Dec - Cpecific: Export Large Table
  • 04 Dec - ansgar: "Betroffene Zeilen" and " ...
  • 03 Dec - Jem: HeidiSQL hangs / not responding creating tr ...
  • 01 Dec - ansgar: Type into grid searches rather than editing
  • 30 Nov - ansgar: Bug CTRL + Z
  • 30 Nov - junior.remualdo: Ctrl + z , Ctrl + Shift + z issue
  • 30 Nov - fliegrobert: Formatierung SQL editor Neue Zeile ...
  • 29 Nov - JonasTFreitas: Function Debug
  • 29 Nov - mihairadu: Can't open SQL after install
  • 28 Nov - benf-tge: read-only mode
  • 28 Nov - ansgar: how to lock column head buttons
  • 28 Nov - ansgar: § character
  • 28 Nov - BubikolRamios: Disabled .... ?
  • 27 Nov - TTSneko: Connecting to Oracle
  • 24 Nov - ansgar: Can not edit bit-columns
  • 24 Nov - colua: Clicking on Query tab closes the tab (ran ...
  • 23 Nov - abu: how to "upgrade" your portable he ...
• 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's this?

HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.

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

News

• 05 Dec HeidiSQL 12.3 with fixed auto-updater and support for MySQL on RDS

  Get it from the download page 3rd party updates: Update plink binaries to latest v0.78. Closes issue #1430 New stuff: Make clicks on grid column headers configurable, so the user may disable it ...

• 15 Nov HeidiSQL 12.2 with JSON and XML reformatters, and customizable highlighters

  Get it from the download page 3rd party updates: Update SQLite libraries to v3.39.4 from 2022-09-29 New stuff: Issue #1536: auto-resize height of data grid filter while user types text in it Is ...

• 13 Aug HeidiSQL 12.1 with views in SQLite

  Get it from the download page 3rd party updates: Update SQLite libraries to v3.39.0, released on 2022-06-25 New stuff: Create context menu item "Empty recent filters" on database and table filt ...

• 12 Apr HeidiSQL 12.0 with experimental support for high DPI and Interbase/Firebird connections

  Get it from the download page 3rd party updates: Update SQLite libraries to v3.38.0 Update VirtualTrees component source to v7.6.1 Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode) Up ...

• 30 May HeidiSQL 11.3 with syntax highlighting in grid text editor

  Get it from the download page Still need 32bit support? I am planning to drop the 32bit releases in a future release, for keeping the installer package small, and to decrease deployment efforts. ...

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

Summer 2015 in Egmond aan Zee, duinreservaat.
On holiday with my wife and two kids.