HeidiSQL – client for MySQL

HeidiSQL is a brilliant, simple and free open source SQL tool for easy management of your MySQL server and databases. It does exactly what you expect it to – and a few extra things. It allows you to browse your databases, manage tables, view and edit records, manage user-privileges and more from an intuitive Windows® interface.

Some of the features found on HeidiSQL

  • generate nice SQL-exports
  • synchronize tables between two databases
  • manage user-privileges
  • import text-files
  • export table-data as CSV, HTML and XML
  • browse and edit table-data using a comfortable grid
  • batch-insert ascii or binary files into tables
  • write queries with syntax-highlighting (next version will have also code-completion)
  • monitor and kill client-processes and much more



  • Take a look on free tool Valentina Studio, is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases for free on 32/64 bit Windows, Linux and Mac OS X. http://www.valentina-db.com/en/valentina-studio-overview

  • Sergei Kharchenko

    I prefer the alternative tool – dbForge Studio for MySQL from Devart. The full list of its major features you can read on this page: http://www.devart.com/dbforge/mysql/studio/
    It has very friendly GUI and can by downloaded by FREE!