What's this?

HeidiSQL is a lightweight, Windows based application for managing MySQL and Microsoft SQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. read more...

News

• 19 May HeidiSQL 8.0 released

  343 revisions after the 7.0 release follows the new 8.0 release of HeidiSQL now. Get it from the download page. Here are the most noticable changes: - Available in 23 languages now. Thanks to a ...

• 17 Apr New feature: Compare global and session variables

  In the Host > Variables list, we only had session variables up to now. Now I introduced a new column with global variables. Most session variables have the same value as their global pendant, bu ...

• 15 Jan New feature: Search + replace on table rows

  Most HeidiSQL users have used the search/replace dialog. From now on, this dialog does not only support searching in a query editor, but also in data grids and query result rows! An interesting ...

• 24 Dec New feature: Microseconds in DATE/TIME values

  MariaDB 5.3 and up and MySQL 5.6 RC introduced real support for milliseconds: https://kb.askmonty.org/en/microseconds-in-mariadb/ http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html He ...

• 20 Dec HeidiSQL T-shirts

  I received a private mail from a HeidiSQL user located in California, who is interested in getting a T-shirt with a HeidiSQL logo and slogan on it. Here's what I have designed so far (woman version ...

Features

• Free for everyone, OpenSource.
• Connect to multiple servers in one window
• 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
• 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