QueryCraft 0.1.12

QueryCraft 0.1.12

中文

• 侧边栏及表总览的表右键菜单增加重命名、删表、截断、清空、重置自增和指定自增值，统一提供 SQL 预览、安全锁、表名确认及操作后刷新。MySQL、PostgreSQL 支持六项操作；Doris 提供重命名、删表和截断，其余项说明限制。Redis、Elasticsearch、Kafka 保留各自的对象操作。
• 修复 MySQL、PostgreSQL 在 SET NAMES 等语句成功后误报事务状态的问题，按服务器响应处理事务、保存点及 DDL 隐式提交；MySQL/Doris 共用新版 V3 transport，支持新旧驱动独立升级。
• MCP 设置改为直接页签、对齐的权限操作及独立对象范围弹窗，保留原有权限上限和策略。Dev 的名称、客户端注册、组件渠道及 Skill 安装目录与正式版隔离。
• 主程序移除独立 MCP 的 SDK、HTTP 与 NIO 传输依赖；MCP 改为独立运行包。Intel 与 Apple Silicon 分别下载签名 XZ 更新包，DMG 使用无损 ULMO 压缩，保留原更新源、历史下载、图标及驱动能力。

English

• Added shared table context actions in the sidebar and object overview: rename, drop, truncate, clear, reset and set auto increment. Actions include SQL preview, Safety Lock, typed table-name confirmation and refresh. MySQL/PostgreSQL support all six; Doris offers rename/drop/truncate with explicit limits for the others. Redis, Elasticsearch and Kafka retain their own object operations.
• Fixed MySQL/PostgreSQL transaction-state errors after successful statements such as SET NAMES. Transactions, savepoints and MySQL DDL implicit commits follow server responses. The MySQL/Doris V3 transport supports independent upgrades alongside older drivers.
• Simplified MCP settings with direct tabs, aligned permission controls and transactional object-scope sheets while preserving authorization ceilings and policies. Development names, client registrations, component feeds and installed Skill paths are isolated from production.
• Removed standalone MCP SDK/HTTP/NIO dependencies from the desktop. MCP runs in its own package. Signed native XZ updates and losslessly compressed ULMO DMGs reduce downloads while preserving the existing feed, history, icons and driver capabilities.

发布范围 / Release scope

组件 / Component	版本与决定 / Version and decision
主程序 / Desktop	0.1.12 (22)，双架构 DMG 与签名 XZ / native Intel and Apple Silicon DMG and signed XZ
MCP	0.1.2 (3)，最低主程序 0.1.12，双架构独立包 / standalone native packages, minimum desktop 0.1.12
Skill	1.0.0 (1)，无资源实现改动，不重新发布 / unchanged, no republication
MySQL	1.0.8 (9)，事务状态及共享 transport 改动，双架构 / transaction-state and shared transport changes, both architectures
PostgreSQL	1.0.7 (9)，协议事务状态转换改动，双架构 / protocol transaction-state changes, both architectures
Doris	1.0.8 (9)，与 MySQL 一同发布共享 transport，双架构 / shared transport, released together with MySQL, both architectures
Redis / Elasticsearch / Kafka	1.0.1 (2)，无实现、依赖或适用打包变化，不重新发布 / unchanged, no republication
Driver API	保持 5；存储、凭据、桌面接口均保持 1 / remains 5; storage, credential and desktop APIs remain 1

三类新驱动仍要求最低主程序 0.1.11；此次表操作通过现有 SQL 执行接口实现，没有修改公共驱动协议。SQL 查询结果不自动重新执行用户语句，表操作刷新对象列表及表数据/结构页。
The three updated drivers retain minimum desktop 0.1.11. Table actions use the existing statement execution API without changing the public driver contract. User SQL queries are not automatically rerun; object lists and table data/structure are refreshed.

验证与限制 / Validation and limits

发版前核心、MCP、SQL 执行与表操作的 206 项 Debug 回归通过，零失败、零跳过；17 项组件范围、10 项恢复产物计划、8 项更新归档脚本回归通过。优化 Release 主程序构建通过；正式产物使用 Release 配置。
Pre-release Debug validation passed 206 core/MCP/SQL/table-action tests with zero failures or skips, plus 17 component-scope, 10 recovery-artifact-plan and eight update-archive script regressions. The optimized Release desktop build passed; distribution artifacts use Release configuration.

表操作通过 Debug 编译、36 项逻辑/安全锁/工作区与列表回归、六类驱动加载和会话创建，以及 60 份中英文、明暗原生离屏截图检查。此前事务修复已在 Intel 的 MySQL 5.6/8.4、PostgreSQL 17 实库验证；MCP 设置、签名组件下载/更新/回退、旧会话连续调用及双架构更新包完整性已有本地回归。
Table actions passed the Debug build, 36 logic/Safety Lock/workspace/overview tests, six-driver loading/session creation and 60 Chinese/English light/dark offscreen native snapshots. Earlier transaction fixes were exercised on local Intel MySQL 5.6/8.4 and PostgreSQL 17; MCP settings, signed component installation/update/rollback, old-session continuity and native archive integrity have local regression coverage.

本轮表操作尚未执行实库写入，Docker 未运行；Doris/MariaDB 服务端和真实鼠标键盘操作未验收。PostgreSQL 自增操作针对表所属的 serial/identity 序列，不推测序列名称；设置过低值可能导致后续插入冲突。Doris 的通用 DELETE 清空和自增计数修改禁用。双架构正式产物及原生 MCP/六驱动运行验证由发布流水线执行。
Live writes for the new table actions remain unverified because Docker is stopped. Doris/MariaDB server behavior and physical-input UI acceptance are not claimed. PostgreSQL changes owned serial/identity sequences without guessing names; low values can cause later duplicate keys. Generic Doris DELETE-all and counter changes are disabled. The release pipeline builds both architectures and gates publication on native MCP/six-driver runtime checks.

QueryCraft MCP 0.1.2

QueryCraft MCP 0.1.2

中文

• SDK、stdio/HTTP 和 NIO 传输移入独立运行包，动态共享同一 Feature 模块，避免主程序携带传输依赖及重复驱动类型。
• 保留权限上限、凭据助手、持久化策略及旧会话兼容；强化 JSON/工具边界与初始化握手回归。
• Dev 使用独立的 QueryCraft Dev / querycraft-dev 身份、注册归属、组件来源及 Skill 安装路径；未配置 Dev 来源时保留本地组件，不回退生产下载。
• Intel / Apple Silicon 独立组件，版本 0.1.2 (3)，最低主程序 0.1.12。Driver API 5，存储/凭据/桌面 API 1 均不变。

English

• Move the SDK, stdio/HTTP and NIO transport into a standalone runtime that dynamically shares one Feature module, removing desktop transport dependencies and duplicate driver types.
• Preserve permission ceilings, credential helpers, policy storage and existing sessions; strengthen JSON/tool boundaries and initialization handshake regressions.
• Use separate QueryCraft Dev / querycraft-dev identities, registration ownership, feeds and installed Skill paths. Without a configured development feed, keep local components and reject production-download fallback.
• Native Intel and Apple Silicon components, version 0.1.2 (3), minimum desktop 0.1.12. Driver API remains 5; storage, credential and desktop APIs remain 1.

QueryCraft 0.1.11

QueryCraft 0.1.11

本次更新

• 新增原生数据传输工作台，支持可复用任务、结构与数据复制、逐表过滤、Upsert、后台执行和取消回滚。
• MySQL LOAD DATA 与 PostgreSQL COPY 原生批量通道实现有界流式传输；四个方向千万行全量校验通过，实测耗时 45.75～121.81 秒，测试进程采样峰值内存 26.34～40.62 MiB。
• 新增 MySQL 结构对比与同步，支持差异检查、SQL 预览和部署。
• 主程序与 MCP 统一凭据授权，减少重复钥匙串授权；改善 MCP 安装进度和兼容性反馈。
• 改善深色编辑器背景及数据传输界面，精简中英文 README 为产品能力与实测性能。

What's New

• Added a native data-transfer workbench with reusable tasks, structure/data copying, per-table filters, Upsert, background execution and cancellation rollback.
• Bounded MySQL LOAD DATA and PostgreSQL COPY pipelines passed full-field verification in four 10-million-row transfers: 45.75–121.81 seconds and 26.34–40.62 MiB sampled peak RSS of the test process.
• Added MySQL schema comparison and synchronization with difference review, SQL preview and deployment.
• Unified desktop/MCP credential authorization to reduce repeated Keychain prompts, with improved MCP installation progress and compatibility feedback.
• Improved dark editor backgrounds and transfer presentation; simplified both READMEs around capabilities and measured performance.

发布范围 / Release scope

组件 / Component	决定 / Decision
主程序 / App	0.1.11 (21)，Intel / Apple Silicon DMG，Universal Sparkle ZIP
MCP	0.1.1 (2)，凭据授权及运行时变化；双架构独立包 / credential and runtime changes, both architectures
Skill	保持 1.0.0 (1)，无实现变化，不重新发布 / unchanged, no republication
MySQL	1.0.7 (8)，原生通道与共享 transport；双架构 / native pipeline and shared transport, both architectures
PostgreSQL	1.0.6 (8)，COPY 与持续读取；双架构 / COPY and streaming reads, both architectures
Doris	1.0.7 (8)，持续读取、类型转换及共享 transport；双架构 / streaming, type conversion and shared transport, both architectures
Redis / Elasticsearch / Kafka	保持 1.0.1 (2)，无实现、依赖或适用打包变化，不重新发布 / unchanged, no republication
Driver API	保持 5；新增可选能力，旧协议表不变 / remains 5 with additive optional capabilities

新三类驱动最低主程序为 0.1.11，避免旧主程序加载其缺失的新符号。MySQL/Doris 使用独立模块名的 MariaDBTransportV2，验证了单独、同时及独立升级加载。MCP 0.1.1 最低主程序为 0.1.11；Skill 保持对 MCP 0.1.x 的兼容。
The three new driver packages require desktop 0.1.11, preventing older hosts from loading missing symbols. MariaDBTransportV2 supports independent MySQL/Doris upgrades. MCP 0.1.1 requires desktop 0.1.11; the unchanged Skill supports MCP 0.1.x.

验证 / Validation

本地 Intel 原生通道通过 45 项回归、四方向实库边界、百万行追加与 Upsert、四方向千万行及六项取消回滚，逐字段校验零差异。六类驱动加载、关闭 LOCAL 与 TEMP 权限不足时回退、三组 Doris/新旧 MySQL 混装均已验证。基准为本地 Docker 的五列混合类型、每批 1000 行、各容器 4 CPU / 2 GiB；耗时包含执行复核及提交，不包含夹具生成与结果校验；RSS 按秒采样，不代表完整 App 总内存，性能依赖硬件、表结构和网络。
Doris 已做来源小样本实库验证，未做千万行；MariaDB 服务端未实测。Redis/Elasticsearch/Kafka 不适用本次关系表通道。未进行物理鼠标/键盘验收。

Local Intel validation covers 45 native-transfer regressions, four-direction live edge cases, million-row append/Upsert, four 10-million-row transfers and six cancellation/rollback cases with no field differences. Six-driver loading, disabled LOCAL, denied TEMP and three Doris/mixed-version combinations passed. Measurements use five mixed-type columns, 1,000-row batches and local Docker containers capped at 4 CPUs / 2 GiB each; execution checks and commit are included, fixture generation and final verification excluded. RSS is sampled once per second for the test harness, not the whole application.
Doris received live small-sample source testing, not a 10-million-row benchmark; a MariaDB server was not tested. Redis/Elasticsearch/Kafka are outside the relational transfer scope. No physical-input UI acceptance is claimed.

整合 main 后的 227 项 Release 回归全部通过（0 失败、0 跳过），Release 主程序构建通过，15 项发版范围测试通过。线上六类驱动的 12 个架构包已核对摘要、大小、包内版本及 API 5。Intel 独立 Release MCP 包通过重定位签名、依赖路径、stdio/HTTP、六驱动及新旧 MySQL/Doris 混装验证；Actions 对两个架构设置相同的发布前阻断检查。安装生命周期的本地 HTTP 夹具使用 Debug，Release 保留 HTTPS 下载限制。

The merged main branch passed 227 Release regressions (zero failures/skips), the Release build and 15 release-scope checks. All 12 existing architecture-specific driver archives were verified against hashes, sizes, bundle versions and API 5. The Intel standalone Release MCP passed relocated signatures/dependencies, stdio/HTTP, six-driver loading and mixed MySQL/Doris upgrades. Actions gates publication on the same native runtime checks for both architectures. Loopback HTTP lifecycle fixtures use Debug; Release retains HTTPS-only component downloads.

Debug 隔离夹具另通过真实限速下载/未知长度进度、校验失败与取消重试、签名目录与 ZIP 校验、独立 MCP/Skill 安装、兼容回退、稳定入口、CLI 更新、旧 stdio 会话继续真实工具调用、自检失败恢复、签名拒绝、降级拒绝、跨进程锁、显式回退和 Skill 本地修改保护。未启用会注册系统后台服务的 launchd 验收。
The isolated Debug lifecycle fixture also passed throttled/unknown-length downloads, checksum and cancellation recovery, signed catalog/ZIP validation, independent installs, compatibility fallback, stable launchers, CLI updates, live old-session tool calls, failed self-test recovery, signature/downgrade rejection, cross-process locking, explicit rollback and local Skill edit protection. Persistent launchd registration checks were not enabled.

QueryCraft MCP 0.1.1

QueryCraft MCP 0.1.1

中文

• 与主程序共用签名验证的凭据助手及单一钥匙串保险库，减少逐连接重复授权。
• 统一密码新增、修改、清除及迁移行为，防止并发写入或旧迁移恢复已清除密码。
• 改善安装进度及兼容性反馈，旧运行时明确提示升级。
• 独立双架构组件，最低主程序 0.1.11；Driver API 5、存储/凭据/桌面接口版本保持 1。

English

• Share the signature-validated credential helper and one Keychain vault with the desktop, reducing repeated per-connection authorization.
• Unify password creation, updates, clearing and migration, protecting concurrent writes and cleared credentials.
• Improve installation progress and compatibility feedback with explicit upgrade messages for older runtimes.
• Independently packaged for Intel and Apple Silicon; requires desktop 0.1.11. Driver API remains 5 and storage/credential/desktop APIs remain 1.

QueryCraft 0.1.10

QueryCraft 0.1.10

本次更新

• 新增独立 MCP 组件：支持本地 stdio 和带认证的 Streamable HTTP，QueryCraft 退出后仍可访问已授权数据库。
• 新增原生 macOS MCP 设置、连接/数据库/工具权限和调用摘要；支持客户端配置一键添加与移除，优化首次加载、权限切换和记录滚动。
• MCP 程序与可选 QueryCraft Skill 分别下载安装、更新及卸载，提供版本兼容检查、签名和摘要验证、原子切换与回退；保留用户授权和 Skill 本地修改。主程序不内置这两个安装包。
• 改善 Codex 的 MCP 初始化兼容性，提供限量查询、结构上下文、长字段展开、事务会话及六类已安装驱动的相应工具。
• 新增编辑器颜色自定义，并改善 SQL/JSON 语法高亮、增量解析及不同编辑场景下的颜色一致性。
• 新增表数据导出和流式导入，支持 CSV、JSON、SQL 和 XLSX，以及导出选项、批量写入和取消处理。
• MySQL、Doris 改用共享动态 MariaDB transport，避免同时加载驱动时重复注册类型；同步发布两者 1.0.6（7）。Driver API 保持 5。
• PostgreSQL 1.0.5（6）、Redis/Elasticsearch/Kafka 1.0.1（2）保持不变，不重新发布。

What's New

• Added an independent MCP component with local stdio and authenticated Streamable HTTP. Authorized database tools continue working after QueryCraft exits.
• Added native macOS MCP settings, connection/database/tool permissions and bounded call summaries, with one-click client registration/removal and smoother loading, permission switching and history scrolling.
• Install, update and remove MCP and the optional QueryCraft Skill independently. Compatibility checks, signatures, checksums, atomic activation and rollback preserve authorization and local Skill edits. Neither installation payload is embedded in the desktop application.
• Improved Codex MCP initialization compatibility. Tools cover bounded queries, schema context, long-cell expansion, transaction sessions and the capabilities of six installed driver families.
• Added editor color customization and improved SQL/JSON highlighting, incremental parsing and color consistency across editing workflows.
• Added table-data export and streaming import for CSV, JSON, SQL and XLSX, including export options, batched writes and cancellation.
• MySQL and Doris now share a dynamic MariaDB transport to avoid duplicate runtime type registration. Both drivers advance to 1.0.6 (7); Driver API remains 5.
• PostgreSQL 1.0.5 (6) and Redis/Elasticsearch/Kafka 1.0.1 (2) are unchanged and are not republished.

Release scope and validation

Application: 0.1.10 (20). MCP: 0.1.0 (1). Skill: 1.0.0 (1).
MCP and Skill require QueryCraft 0.1.10 or later and Driver API 5; Skill requires MCP 0.1.x.
MySQL/Doris: publish both x86_64 and arm64. Other four driver families: retain the compatible online API 5 releases.

Local Intel validation passed: Debug build, 131 MCP/settings/SQL regressions, 14 release-scope tests, all LicenseServer Go packages, signed component lifecycle/rollback, standalone stdio/HTTP and six-driver loading. Native settings were rendered offscreen; physical-input interaction and an actual OS reboot are not claimed.
The release workflow builds native Intel/Apple Silicon installers, a Universal Sparkle archive, independently signed MCP/Skill packages and the two affected drivers. Online catalogs and downloadable artifacts must pass publication checks before release completion.

QueryCraft SKILL 1.0.0

QueryCraft Skill 1.0.0

中文

• Skill 作为独立可选资源下载安装，与 MCP 和主程序分别版本管理。
• 清单声明所需 MCP 版本范围；不兼容时保留已有安装。
• 支持 Shared、Codex、Claude Code 目录，提供六类驱动工作流指导。
• 更新及卸载保留用户本地修改，拒绝通过符号链接替换其他文件。

English

• Install the optional Skill independently, with its own release version and compatible MCP version range.
• Keep the existing installation when compatibility checks fail.
• Support Shared, Codex and Claude Code destinations and guidance for all six driver families.
• Preserve local modifications during updates and removal; refuse symbolic-link replacement.

QueryCraft MCP 0.1.0

QueryCraft MCP 0.1.0

中文

• MCP 作为可选独立组件下载安装，不再内置于主程序。
• 支持 stdio 与带认证的 Streamable HTTP，主程序退出后仍可运行。
• 提供六类已安装驱动的连接、结构、查询与相应原生能力；权限由服务端执行。
• 发行清单声明主程序、Driver API、存储、凭据及桌面联动接口的兼容要求。
• 使用固定启动入口与不可变版本目录，升级前完成签名、摘要、兼容性和协议自检，支持回退。
• 旧客户端路径保留；在设置中重新添加客户端后使用固定入口。

English

• Install MCP as an optional independent component; the desktop application contains no MCP package.
• Use stdio or authenticated Streamable HTTP, including when the desktop application is closed.
• Discover authorized connections, inspect schemas and use the capabilities of the six installed driver families.
• Signed release records declare desktop, Driver API, storage, credential and desktop-bridge compatibility.
• A stable launcher selects immutable runtime versions after signature, checksum, compatibility and protocol checks. A previous version can be restored.
• Legacy client paths are retained. Update client registration in settings to use the stable launcher.

QueryCraft 0.1.9

QueryCraft 0.1.9

本次更新

• 重做 SQL 片段补全的占位符状态显示：当前输入位置使用清晰的描边和强调底色，其他待填写位置使用淡色提示，亮色和暗色主题都能区分当前编辑位置。
• 修复 SQL 片段补全在输入、退格、清空后重填、配对引号、中文输入法、撤销和重做后跳转位置丢失的问题。
• 修复 Tab、Shift-Tab 在补全列表和输入法组合输入下偶发失效的问题；支持循环回到上一项，完成最后一项后退出片段编辑。
• 增加可持久化的 SQL 片段设置，并支持复制行和内容页签快捷键。
• SQL 补全结果支持显示字段与表注释，相关元数据链路升级到 Driver API 5。
• SQL 语法资源在 Swift Package 和 Xcode 环境下统一正确加载。
• 同步发布 Driver API 5 的 MySQL、PostgreSQL、Doris、Redis、Elasticsearch 和 Kafka Intel 与 Apple Silicon 驱动。

What's New

• Reworked SQL snippet placeholder styling: the current editing position now uses a clear outline and accent fill, while other pending positions use a subtle hint fill in both light and dark themes.
• Fixed snippet navigation losing its placeholder ranges after typing, backspacing, clearing and retyping, paired quotes, Chinese input method composition, undo, or redo.
• Fixed intermittent Tab and Shift-Tab navigation failures while the completion list or an input method is active. Navigation now wraps backward and exits cleanly after the final placeholder.
• Added persisted SQL snippet settings, duplicate-line support, and content-tab keyboard shortcuts.
• SQL completion results can show field and table comments; the metadata path now uses Driver API 5.
• Fixed SQL grammar resources loading consistently in both Swift Package and Xcode environments.
• Published Driver API 5 MySQL, PostgreSQL, Doris, Redis, Elasticsearch, and Kafka drivers for Intel and Apple Silicon.

QueryCraft 0.1.8

QueryCraft 0.1.8

本次更新

• SQL 表格编辑新增紧凑的日期与时间编辑器：年月日、时分秒分别支持直接输入和上下调节。
• 日期、时间、日期时间字段按类型显示对应编辑行，支持 TIME 类型。
• 日期编辑弹窗改为居中的玻璃材质布局，提供“现在 / NULL / 应用”三个操作按钮。
• SQL 表格与查询结果编辑统一接入日期编辑器，并在结果刷新或切换对象时正确结束过期编辑状态。
• 增加 SQL 日期编辑、时区、精度和别名字段元数据测试。

What's New

• Added a compact SQL date and time editor with direct input and stepper controls for year, month, day, hour, minute, and second.
• Date-only, time-only, and date-time columns now show only the controls relevant to their SQL type, including TIME columns.
• Reworked the editor popover with a centered glass-style layout and consistent Now, NULL, and Apply actions.
• Unified date editing across SQL table cells and query result cells, including cleanup when results or selected objects change.
• Added coverage for SQL date editing, timezone handling, precision, and aliased column metadata.

QueryCraft 0.1.7

QueryCraft 0.1.7

本次更新

• 新增原生 Kafka 插件，支持 Topic 浏览与管理、消息读取与发送、消费组查看及 JSON 消息表格展示；同步发布 Intel 与 Apple Silicon Kafka 驱动。
• SQL 批量执行新增消息与摘要视图，展示执行 SQL、返回或影响行数、耗时及结果数量限制；执行期间保持消息页签并跟随执行进度滚动。单条查询直接展示表格，更新、删除等无查询结果的语句展示执行消息。
• SQL 预览支持语法高亮、自动换行、窗口缩放、字号调整与复制；双击语句或使用悬停时出现的放大按钮即可查看完整内容。
• 可编辑的查询结果支持删除行和批量编辑单元格，配合变更预览与提交操作完成修改。
• 修复 SQL 自动补全上下文混用、默认选中项未重置和列信息加载失败后无法重试的问题，并完善 DESC 语句识别。
• 修复重新构建或升级应用后反复要求钥匙串授权的问题：连接密码由固定安装的 QueryCraft Credentials 辅助程序访问，仍保存在 macOS 钥匙串中。已有连接首次迁移时可能需要为该辅助程序选择一次“始终允许”，后续主应用升级将保留授权。
• 同步更新 MySQL、PostgreSQL、Doris、Redis、Elasticsearch 和 Kafka 的 Intel 与 Apple Silicon 驱动。

What's New

• Added a native Kafka plugin with topic browsing and management, message reading and producing, consumer group inspection, and JSON message tables. Kafka drivers are available for Intel and Apple Silicon.
• Added messages and summaries for SQL batch execution, including executed SQL, returned or affected rows, elapsed time, and result row limits. Execution stays on the messages tab and scrolls with progress. A single query opens its result table directly; statements without query results show execution messages.
• SQL previews support syntax highlighting, line wrapping, resizable windows, font size controls, and copying. Double-click a statement or use its hover-only expand button to view the complete SQL.
• Editable query results now support row deletion and bulk cell editing, with change previews and commit actions.
• Fixed SQL completion context isolation, default selection reset, and retries after column metadata loading failures, and improved DESC statement recognition.
• Fixed repeated Keychain authorization prompts after rebuilding or upgrading the app. A persistently installed QueryCraft Credentials helper accesses connection passwords, which remain in the macOS Keychain. Existing connections may require selecting Always Allow once for the helper during migration; later main app upgrades preserve that authorization.
• Updated MySQL, PostgreSQL, Doris, Redis, Elasticsearch, and Kafka drivers for Intel and Apple Silicon.