• Home
• Downloads
  • Installer
  • Portable
  • Portable-64
  • App
  • Source
  • Nightly builds
• Images
  • Screenshots
  • Themes
• Forum
  • 01 Mar - BubikolRamios: Find text on server/trigger
  • 28 Feb - BubikolRamios: Pocesses/host
  • 27 Feb - Conz: MariaDB Datatype length keeps changing
  • 27 Feb - Franky: MariaDB10 Stored Procedure Select with v ...
  • 25 Feb - xavier.be: Connecting to Oracle
  • 25 Feb - rolandkreuzer: Postgres JSONB Update from Grid
  • 24 Feb - andrea_ca_gt: table doesn't exit in engine
  • 22 Feb - ansgar: BIT(64) Field
  • 22 Feb - dami97: create a new localhost session with conn ...
  • 22 Feb - mnk: Is HeidySql work with Postgres 13?
  • 20 Feb - ansgar: How to omit / disable a # wildcard in a ...
  • 20 Feb - ansgar: cancel export of table does not work
  • 20 Feb - pantantrollo: Cannot find a usable libmariadb.dll.
  • 19 Feb - fernand.st-georges@protonmail.com: workbook to c ...
  • 19 Feb - ansgar: Slow movement across rows and columns
  • 18 Feb - dpkv: Can't connect to MySQL server on '127.0.0. ...
  • 16 Feb - nipukabadi: Access denied for user root@
  • 16 Feb - StephanBiegel: Recognize settings for - Database ...
  • 15 Feb - Roelie: Create or alter table view, tab basic
  • 15 Feb - ansgar: Warning error
• 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
  • 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

• 24 Jan HeidiSQL 11.2 with support for check constraints and CSV layout detection

  Get it from the download page 3rd party updates: update VCL Styles Utils code get latest bugfixes for VirtualTrees component upgrade installer compilation to InnoSetup v6.1.2 plink.exe update to ...

• 02 Nov HeidiSQL 11.1 released

  Grab it from the download page 3rd party updates: move to new Delphi v10.4 Sydney compiler ship plink.exe v0.73 by installing HeidiSQL, so users don't have to download it use smaller libmariadb.d ...

• 07 Sep "HeidiSQL - Made with Delphi" webinar available

  Letzten Mittwoch sprach ich mit Matthias Eissing von Embarcadero über Delphi und HeidiSQL. Agenda: Woher kommt HeidiSQL? Warum Delphi? Features Pläne für die Zukunft "dies und das" Und hier d ...

• 17 Mar HeidiSQL 11.0 with SQLite support

  Grab it from the download page New features and enhancements in this version: Support connecting to SQLite database files drop schema support for PostgreSQL support foreign keys in PostgreSQL sup ...

• 11 Dec HeidiSQL 10.3 released

  Grab it from the download page New features and enhancements in this version: Theme preview in preferences dialog "Library" dropdown in session manager, to enhance support for older and newer MyS ...

Features

• Free for everyone, OpenSource
• Connect to multiple servers in one window
• Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite
• 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.