HeidiSQL – client for managing MySQL, MSSQL and PostgreSQL

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, PostgreSQL and MariaDB.

It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.

Also, the software lets can export structure and data, either to SQL file, clipboard or to other servers.

Features include:

  • Connect to multiple servers in one window.
  • Connect to servers via the command line.
  • 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.

Website: www.heidisql.com
Support: Forum, GitHub code repository
Developer: Ansgar Becker
License: GNU General Public License v2.0


Are you interested in learning the art of programming? There are lots of excellent free and open source programming books that teach you how to program in every popular programming language. Read these Free Books.

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.