Puresys纯净系统-软件下载介绍
官方网站：https://github.com/HeidiSQL/HeidiSQL/
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 确实是同类工具中最好的之一，而且由于功能齐全，它应该可以满足许多专门从事该领域的用户的需求。
更新日志
12.21 - 2026-08-03
⛰️ Features
Create opt-in option for displaying columns in database tree - (f492bed)
Enhance order of items in completion proposal, so exact matches are at the top - (c1b817b)
For keyboard navigation on the completion proposal, wrap around the item list - (db952f8)
First attempt to create a user manager for PostgreSQL - (f0d7103)
Show index icons on columns in tree, and the data type text color - (e6e90aa)
Auto-adjust width of various combo boxes - (ca9b748)
Show table columns in tree, as child nodes - (0e20e70)
Query size of all indexes in one query - (c5201eb)
Display size of each index and paint a color bar behind it - (48a93d2)
Make custom proposal popup interval effective - (500c529)
Icons, colors and padding in completion proposal - (3d1254d)
🐛 Bug Fixes
(ui) Exchange icon for "column" and its variants for add, delete, edit - (08558f9)
Sporadic crash in DBtreePaintText with columns - (f76c54f)
Enable foreign key drop down on grid field in MS SQL mode - (9f83561)
Remove column nodes from tree in table tools dialog - (b09823e)
Empty command line part for sshpass on FreeBSD - (ed881b3)
Handle MONEY column types as float - (67521d4)
Hang and wrong check states in data grid column selection on macOS - (6c5b66c)
Invalid folder path for SQL export cannot be created if it contains a duplicated path delimiter - (4555274)
Various CVEs regarding libssl and libcrypto - (379d28a)
Context menu does not appear at right-click on a tree node text - (8befce3)
Crash when opening textfile import dialog, with 0 tables in database - (83c4947)
Crash when cancelling session manager while a session rename is active - (1da8683)
Prevent crashes from SetFocus on various controls - (bf46821)
Data grid header keeps showing previous table's columns on macOS - (255695d)
Prevent SQL error "Property 'MS_Description' already exists" - (ac50b73)
Enhance anchors on some of the table editors controls - (bfebd9e)
Bad width of collation combo box - (a90f73c)
File > "New window" does nothing on macOS - (0583a4e)
Still wrong proposal background color in dark mode - (e62c47f)
Wrong proposal background color in dark mode - (eec978c)
Crash when opening a table, due to using the TCanvas member of a not yet visible form or frame - (bfe29c1)
Give the trees and grids more height for the header - (568098a)
Widen many TSpinEditEx instances to either 80px or align them with neighbor controls - (5964be6)
Some trees have their own OnContextMenu logic set at design time, do not overwrite - (7c2870a)
Work around unused Header.PopupMenu menu on Linux when a tree has a PopupMenu - (2030a91)
DPI related scale glitches, mainly on completion proposal - (905b126)
Do not paint size bar in nodes of level 2, and do not show "-" text there neither - (3e678bc)
Bad text color for selected item in proposal - (1c46db7)
Propose items when editor already contains a leading backtick quote - (8f12b3e)
Missing support for custom keyboard shortcut for executing completion popup - (79f1d38)
Glitches with padding in completion proposal, and non-restored width - (cf67d11)
EXPLAIN actions either disabled or non-working for PostgreSQL and SQLite - (2572681)
Hanging in a loop over result nodes by right-click on query result - (bc8f903)
Detect release version string from Lazarus project file, and insert into Contents/Info.plist of macOS bundle - (2171b58)
Crash during refresh on disconnected session - (0b0106d)
When parsing the command line, make use of Application.GetOptionValue and friends, instead of ParamStr(x) with regular expressions - (f436354)
Use default library of connection when the one from a stored session contains an invalid path/file - (51023c3)
Refresh session tree after import per More > Import settings file - (cfca46f)
CAS(x AS CHAR) not supported by MySQL below v4.0.2 - (e9e5263)
Always enable release link label on update check dialog, which points to the general download page - (2d475d2)
Prepend database name to the trigger name at the correct position, when newer MariaDB versions use IF NOT EXISTS - (27a3a51)
🚜 Refactor
Prefer Delphi friendly SysUtils.PathDelim over System.DirectorySeparator - (84104d0)
⚡ Performance
Avoid full string scans in StrEllipsis - (32f3bd0)
⚙️ Miscellaneous Tasks
Update SQLite libraries to v3.53.4 - (7bfd91d)
Ignore auto-created IntelliJ project files - (64613cf)
Prefer macos-15 over macos-15-arm64, due to better availability of the Intel runners - (c3be9d4)
Stick to macOS 15, because the FPC package is only officially qualified up to macOS 11 and uses a package format Apple has tightened in newer releases, so it no longer installs on the macos 26 runners. - ([0c969da](https://github.com/HeidiSQL/Hei...
