HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager

Source: Hacker News

HeidiSQL is a graphical interface for managing MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite, Interbase, and Firebird databases. It lets you browse and edit data, create and modify tables, views, procedures, triggers, and scheduled events. You can also export structures and data to SQL files, the clipboard, or other servers. See the full list of features and some screenshots.

Need help

Visit the online help page to learn how to use HeidiSQL.
Ask questions on the forum.
Report bugs or request new features via the issue tracker.

Building

• Windows: Delphi 12.1 is required. Older Delphi versions are likely to fail; newer versions may work.

  • Load the SynEdit project from the components folder, build both run‑time and design‑time packages, and install the design‑time package.
  • Do the same for the VirtualTree component project.
  • Install madExcept (download from ).

• Other platforms: See the lazarus branch for non‑Windows builds. Note that Lazarus or other free compilers cannot currently compile HeidiSQL.

Compiling resource files

rem Compile *.rc files
rem Folder                File               Command
rem ---------------------------------------------------------
rem HeidiSQL/source/vcl-styles-utils  AwesomeFont.RC   brcc32 AwesomeFont.RC
rem HeidiSQL/res                     icon.rc          brcc32 icon.rc
rem HeidiSQL/res                     icon-question.rc brcc32 icon-question.rc
rem HeidiSQL/res                     version.rc       brcc32 version.rc
rem HeidiSQL/res                     manifest.rc      (no command needed)
rem HeidiSQL/res                     styles.rc        brcc32 styles.rc
rem HeidiSQL/res                     updater.rc       brcc32 updater.rc

If updater.rc and updater.exe are missing, copy them from updater64.rc and updater64.exe.

After compiling the resources, load the HeidiSQL project from the packages folder and build.

Translation

To help translate HeidiSQL, register at Transifex, join an existing language team, or request a new language.

Contributing to HeidiSQL

• Pull requests are accepted only for bug fixes; new features are not welcome.
• Reference a ticket ID in your pull request. If no ticket exists, create an issue first and fill out the issue template.
• To become a developer member, contact Ansgar via email (see the imprint page for the address).

Icons8 copyright

Icons added in January 2019 to a TImageCollection component are © Icons8. They are used with special permission from Icons8 granted solely for this project. Do not copy them for any other purpose.