介绍

HeidiSQL 是免费软件，其目标是易于学习。 “Heidi”让您可以从运行 MariaDB、MySQL、Microsoft SQL、PostgreSQL 和 SQLite 数据库系统之一的计算机上查看和编辑数据和结构。 HeidiSQL 由 Ansgar 于 2002 年发明，属于全球最流行的 MariaDB 和 MySQL 工具。

软件截图

软件特点

对所有人免费，开源
在一个窗口中连接到多个服务器
支持的数据库系统：MariaDB、MySQL、MS SQL、PostgreSQL 和 SQLite
通过命令行连接到服务器
通过 SSH 隧道连接，或通过 SSL 设置
创建和编辑表、视图、存储的例程、触发器和计划事件。
生成漂亮的 SQL 导出，然后压缩它们，或将它们放在剪贴板上。
从一个服务器/数据库直接导出到另一个服务器/数据库
管理用户权限
导入文本文件
将表格行导出为 CSV、HTML、XML、SQL、LaTeX、Wiki 标记和 PHP 数组
使用舒适的网格浏览和编辑表数据
批量编辑表（移至数据库、更改引擎、整理等）
将 ascii 或二进制文件批量插入表中
使用可自定义的语法突出显示和代码完成编写查询
漂亮的重新格式化无序的 SQL
监视和终止客户端进程
在一台服务器的所有数据库的所有表中查找特定文本
批量优化修复表
使用您当前的连接设置启动并行 mysql.exe 命令行窗口
以及更多

使用 MySQL 数据库是一项专业工作，需要在该领域拥有丰富的知识，还需要适当的程序来使任务更轻松。对于开发人员和数据库管理员来说，sorts 或 HeidiSQL 实用程序真的很受欢迎。该软件解决方案着眼于促进兼容数据库的管理，具有相当不错的界面，其中包含管理数据所需的所有功能和命令。

得益于 HeidiSQL 会话管理器背后的创新技术，可以一次建立连接并运行多个数据库。该应用程序可以处理大量任务，并使创建和编辑表成为一项简单的工作。在此程序的帮助下，您还可以创建和运行自定义查询，同时它配备的工具扩展了该实用程序的功能。因此，您可以使用用户管理模块，您可以在其中为将访问数据库的每个用户指定权限。

主机、日志、表、状态或权限等数据可以通过 HeidiSQL 自带的功能轻松刷新。数据库表可以批量编辑，这意味着您可以一次加载多个表并通过“批量表编辑器”处理所有表。

该软件的另一个巧妙功能是只需单击一下即可导出和导入设置。将数据库导出为 SQL 并同步它们的可能性使这一点加倍。其他工具包括 TEXT 和 BLOB 字段内的文件插值、从 CSV 导入数据等。

总而言之，可以肯定地说，HeidiSQL 确实是同类工具中最好的之一，而且由于功能齐全，它应该可以满足许多专门从事该领域的用户的需求。

更新日志

HeidiSQL 12.14.0.7164
Dec 11, 2025
Features:
Shell script for creating macOS app bundle – (af24108)
Support XML formatting in grid popup text editor – (913fc9d)
Switch to grayscale icons on inactive query tabs – (917e046)
Support SSH tunnel configuration per commandline – (35a5225)
Display some known file type icons in file open/save dialog – (b4c0566)
Finalize keyboard shortcut customization in preferences – (637d2d6)
Add new keyboard shortcut editors on preferences dialog – (cc4e6f1)
Keep time fractions intact for CSV exports – (06322de)
Use custom folder icons in tree on file dialogs, in non-Windows mode – (3094d79)
Show NULL values in system variables listing – (06b44eb)
Highlight same text in grids based on all selected rows – (afc9d8c)
Support fractional UNIX timestamps in grids – (65c1472)
Add “source table: xyz” hint to query result column headers – (2863a80)
Support click on path parts on top label of file dialog – (98b796b)
Convert all save/open dialogs to the new custom one – (4a8c53c)
Create file-save dialog with linebreaks selector – (d5d34ad)
Recreate basic TExtFileOpenDialog without OS owned dialog and room for customization – (bac0d7a)
Full support for different icon packs, Silk and Icons8 – (dbca69d)
Add 206 Silk icons into new TImageList – (769afa5)
Require libsybdb5 in DEB package – (e1781f9)
Mark MS SQL protocols like named pipe as unsupported, advise the user to change to TCP/IP – (b20f121)
Dirty and basic support for MS SQL – (3df3673)
Show more detailed backtrace in crash dialog – (bc0a7de)
Support SSH passwords via sshpass – (f2b2dc3)
Enhancements:
Position session manager centered over main form, ignore position set by user – (571c671)
Align bottom buttons on session manager – (ca7aad6)
Set font style and color of size column in tree – (f987c81)
Move RightEdge on SQL editors out of sight – (2a23e26)
Light text color instead of ghosted/ugly icon for unseen tree nodes – (76aefb3)
Disable tree option asDoubleClickInsertsNodeText by default – (1c9321c)
Bug Fixes:
Connect MS SQL query to session transaction, run .ExecSQL – (59191da)
Prevent SQL delimiter being set to PostgreSQL quotes – (a3acc04)
Crash when grid-exporting without required key – (ff6050f)
Delete CLI-created session settings from registry after disconnect – (8778d40)
Another broken thousand separator – (24f3e36)
New attempt to hide SynEdit caret when unfocused – (03f4a5f)
A TSpeedButton connected to a TAction, and a TMenuItem were not auto-checking – (42abf46)
Database icon in Icons8 list too small – (dda44be)
Cannot save new table when added column was removed – (1fe709a)
Compile without MS SQL support on macOS – (9a4d841)
Query batch stops at second last query if it has errors but StopOnErrors is off – (6e40c62)
Drag’n drop on Linux requires VT.DragType = dtVCL – (4fd646c)
Enable drag’n drop in table editor and session manager – (9afc60f)
Detected empty text DEFAULT value for table columns – (4c0617d)
Append quick filter without linebreak – (8ea3b94)
Wrong icon sizes, disable right-click select for column list so selection is kept – (a145fc5)
Remove dead code, fix some compiler hints – (79bcd1d)
Bad position of TEdit on TInplaceEditorLink – (8d119a0)
Quick filter > “more values” submenu not created/shown – (8696e61)
Empty KeyStrokes list on text editor – (db00c83)
Broken caption on inline text edit button – (1730956)
User queries not showing up in log panel – (222a386)
Do not edit grid cell on right-click, and set HotCursor on DBtree – (0257867)
Flashing main form in background after cancel session manager – (0563b4d)
Work around empty space artifact in ShellListView – (cf9ed85)
Move all Application event assignments to .lpr file – (64919d6)
Confusion with (selected) folder icons – (b488ca2)
Tree with keyboard actions shows wrong captions – (5e20c53)
Binary result values displayed as 000… – (4322372)
TMySQLQuery.TableName() returns wrong string, and introduce apphelpers.GetAppDir – (bb517d7)
Crash in AnyGridPaintText with no query result – (59659f0)
Error: (4004) Variable identifier expected – (13a0127)
Crash in printer dialog with 0 printers available – (6eecdd8)
Missing file for previous commit – (857cca8)
Some remaining issues in the new file-open/save dialogs – (34e3f32)
Work around out-of-view item in left tree after FormShow – (ec4c237)
Navigate to directory of currently loaded file when user opens dialog for loading another file – (251f632)
Broken support for non UTF-8 encoding – (fe65231)
Prompt to overwrite only if file exists – (91de2fc)
Add encoding selector to file-open dialog – (56b783d)
Crash when app exits, with deleted TSynGutterSeparator – (00627ae)
Optical stuff, add bookmark icons for SynEdit – (29d1abc)
Use GetApplicationName in InitMoFile as well, plus documentation – (93bf989)
Make LCLTranslator independent of executable filename – (0469dd9)
Make GetAppConfigDir independent of executable filename – (9e2611e)
Make translation filename independent of executable filename – (5d487bb)
More painting related crashes on QT, this time in OperationRunning() – (fbe32db)
Compiler warnings, re-enable active line background – (a1c84ae)
Two crashes in QT caused by aggressive control repainting – (7650efe)
Hide library files which ldconfig shows up but don’t exist – (85cf230)
Provide at least one libmysql for macOS, plus its dependencies – (1fbc2ab)
Fix compiler errors on macOS, set DYLD_LIBRARY_PATH run param to fix wrong path for libssl – (58b210a)
Wrong integer size/type for ClientFlag in mysql_real_connect – (3213fe9)

下载地址

本地下载        联通下载        蓝奏云