What's this?

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

News

• 05 Feb Rewritten search + replace dialog, Loglevel settings

  Two minor news today about nice new stuff in HeidiSQL:1. Rewritten search + replace dialog. Previously HeidiSQL used a default dialog provided by the Windows API, supporting only a small feature set, and including some nasty focussing bugs. Anyway, the new dialog can... [read]

• 30 Jan HeidiSQL 5.0 Beta available

  A new release with lots of new features and bugfixes. To mention some of them:* Completely rewritten, homebrown database communication layer, supporting Unicode from the very beginning* Rewritten table editor, now supporting foreign keys and drag'n drop editing* Rewr... [read]

• 01 Jan New feature: Reformat SQL

  We've all been there: Getting some totally unreadable portion of SQL queries from someone else's code, and you are hard working to find the logic in order to understand it. Now, HeidiSQL can reformat such SQL, so it gets readable again. Just press the relevant button... [read]

• 12 Dec Trigger editor implemented, finally

  One of the most wanted, needed features in HeidiSQL was a GUI for creating and editing triggers, available in MySQL 5.0.2 and above. Now implemented and hopefully as usable at it can be. Very simple compared to editing tables or procedures. See it in action by downlo... [read]

• 09 Dec New feature: Bulk table editor

  The recently refactored "Table tools" dialog has a new tab now: "Bulk table editor". What is bulk editing?* Move all tables of one or more databases to another database* Change default collation of these tables* Change table engine* Convert data to a different charse... [read]

Features

• Generate nice SQL-exports
• Synchronize tables between two databases
• Manage user-privileges
• Import text-files
• Export table-data as CSV, HTML, XML and SQL
• Browse and edit table-data using a comfortable grid
• Create and edit tables, views, stored routines and triggers
• 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
• Connect to servers via commandline
• Find specific text in all tables of all databases of one server
• Optimize and repair tables in a batch manner
• And much more

MySQL version usage*

* Reported by 7147 HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog. (Implemented in build r2497)

Random Screenshots

Grideditors

Insert Files

Maintenance

Find Text On Server

Sql Help

More images...