DbCat

更新日志

DbCat 有哪些新变化

每个版本按从新到旧排列,更早的版本保留在 GitHub Releases。

0.6.0 起发布说明只有英文版。GitHub Releases

0.8.2

最新

New Features

  • Import CSV as New Table: From the sidebar menus, DbCat infers each column's type from the file, lets you edit the column definitions, then creates the table and imports the rows. SQL databases only.
  • Existing Rows on Import: CSV and MongoDB imports can fail, skip existing rows, insert or update them by primary key or _id, or overwrite whole rows. Where a database cannot do this, the option is disabled and the reason is shown.
  • Import Errors: Stop, or skip bad rows and continue. Stop rolls back a SQL import; Skip lists the first 20 skipped rows in the result.
  • Empty Table Before Import: CSV and MongoDB import dialogs can clear the existing table or collection first, after a confirmation.
  • CSV Encoding: Choose the file's text encoding, such as UTF-8, UTF-16, GB18030, Big5, Shift_JIS or Windows-1252. A byte order mark takes precedence. Decode errors report the line.
  • Import into New Collection (MongoDB): From the "+" menu, the Collections folder or a blank-area right-click.
  • New Collection (MongoDB): Create a collection from the "+" menu and the Collections folder menu, the same entry points as New Table.
  • Export Query Results (MongoDB): Export results as CSV or JSON, or export a collection with its current filter from the tab's bottom bar.
  • Back Up / Restore in the Title Bar: SQL and MongoDB workspaces have Back Up and Restore Database in the ⋯ menu. The overview's Restore row is hidden when the connection is read-only.
  • Views in the Sidebar: Rename and Drop View from the right-click menu, and New Query on tables and views.
  • Redis Key List Menu: Right-click a blank area of the key list for New Key and Refresh.

Improvements

  • Remembered Database: Connections with no database set reopen on the database you used last, for PostgreSQL, SQL Server, MySQL, MariaDB, ClickHouse, MongoDB and Redis. If that database no longer exists, DbCat opens the default one.
  • Keep Your Place: After a commit or refresh, table and query grids keep the selected row and scroll position, matched by primary key or _id. Redis key views and the Structure tab also keep their place after a reload. Paging, filters, sorting and switching tables still reset the view.
  • Structure Type Picker: Type, default and extra cells have a visible dropdown, using the same type list as New Table. SQL Server types are included.
  • Inline Text Editing: Short single-line TEXT values edit in place. Long or multi-line values still open the editor.
  • Import Progress: CSV and MongoDB JSON Lines imports show progress as a percentage of the file read.
  • Background Notifications: Backup, restore and import results that finish while DbCat is in the background post a system notification.
  • Pinned Dialog Footers: The import, backup, restore, export, create-table and query-parameter dialogs keep their buttons visible in short windows.
  • Connection Marker: The connection color tints the tile itself, and the active item has an outer ring.
  • Plan Graph Warnings: Warnings show as icon badges with a tooltip, so operator names keep their room.
  • Wide Tables: The details panel and MongoDB JSON and tree views redraw less when the table refreshes.

Bug Fixes

  • Fixed shortcuts such as ⌘S, ⌘I, ⌘F and ⌘↵ stopping working after focus moved to the workspace in SQL and Redis tabs.
  • Fixed a menu or picker closing without returning focus to where it was opened from.
  • Fixed Esc in the paging popover applying the change instead of closing it.
  • Fixed the window order after session restore depending on which connection finished first.
  • Fixed the ClickHouse overview showing "Data 0 B · Index 0 B" when only a total size is reported.
  • Fixed CSV import reporting the same file read error repeatedly; the row-by-row retry now shows progress and can be cancelled.
  • Fixed default-value suggestions not following the column type.
  • Fixed the import dialog footer hiding Import in short windows, and long type badges hiding the column name.

0.8.1

New Features

  • Redis Database Overview: With no tab open, a Redis connection shows key statistics, sampled key types, the biggest keys, the key space and quick actions.
  • MongoDB Database Overview: Shows collections, documents, size and the largest collections, with Open collection and Backup actions. Views are skipped, and databases with more than 500 collections are not supported.
  • Connection Type Picker: New connections start from a grid of database logos; one click opens the form. Aliases such as pg, mssql and mongo work in the search box, and pasting a connection URL opens a prefilled form.
  • Separate Theme per Appearance: Choose one theme for light mode and another for dark mode from swatch cards that preview the real colors.
  • MongoDB Index and Validation Pages: Indexes and validation rules are now independent pages. Indexes show usage (operations and since) and a building flag; validation rules have a live preview with sample passing and failing documents and a capped violation count.
  • Redis Key Detail: A key opens with its name as an editable title (rename in place), type, TTL, length, encoding and memory chips, and a member table beside a value pane.
  • MongoDB and Redis Backup / Restore Dialog: They open in the same dialog as SQL backup and restore and share one progress and result view.

Improvements

  • Backup and Restore: Backup and restore show determinate progress (percent, elapsed and remaining time, per-object state) and finish with a result view (time, file size, path, Show in Finder). The object list shows estimated rows and size. Connection and database pickers sit at the top of one dialog, with no Next step.
  • New Table Dialog: Columns are edited in a compact table with primary-key badges and type presets; foreign keys and the SQL preview are collapsible, and ⌘↩ creates the table.
  • CSV Import Dialog: Rebuilt with format and column-mapping cards, example values, a required-column check, a file preview, in-place progress and a done view.
  • Welcome Window: Connection cards show when they were last opened, the list scrolls smoothly with group titles, and Enter in the search box connects.
  • Themes: Each theme family has its own categorical chart palette, and light themes use a tinted canvas with white cards.
  • MongoDB and Redis Admin Pages: Server, process, index and session pages use stat cards, opcounter rates and soft state badges, and system sessions are hidden.
  • Connection Form: Server fields come first, the AI access setting matches write protection, and the host field is focused on open.
  • Statement Previews: Approval and confirmation dialogs show statements in a highlighted, selectable SQL view with a fitted height.
  • SQL Console: Shows the log in a read-only highlighted SQL view with an empty-state hint and a source tag on statements issued by the app. It keeps its scroll position when scrolled up, and follows new output only when at the end.
  • AI Access (MCP): Row estimates only gate automatic writes, harmless DDL such as CREATE and COMMENT is no longer reported as destructive, and the approval dialog is simpler.
  • Result Grid: Rows share one vertical center, structure columns fit the visible width, status values are pills, and the bottom bar turns tool labels into icons before collapsing structure sections. Cell and row menus have icons and a Copy As submenu.
  • Table Details: Table sizes and the row estimate appear as stat cards; the empty comment is hidden.
  • Backup Dialogs, Export Dialog and Preferences: Consistent headers, card widths and segmented controls; the MCP preferences page groups clients and connections in cards.
  • Sidebar: New-object menu items use the same icons as the tree, and the right-clicked row stays highlighted while its menu is open.
  • Bar Chart: The value axis lands on round ticks, like the line chart.
  • MySQL Errors: Connection and IO failures read as plain English, for example "Could not connect to host:port: reason".

Bug Fixes

  • Fixed the Redis overview showing English text in Chinese and the reverse, and unreadable byte sizes and uptime.
  • Fixed dark-mode logo tiles for MySQL, SQLite, DuckDB, ClickHouse, PostgreSQL, MariaDB, CockroachDB and SQL Server.
  • Fixed the MongoDB index and validation panes failing to load, index columns squeezing the keys column, and the validation preview not refreshing after a revert.
  • Fixed MongoDB views showing statistics and allowing new indexes.
  • Fixed Enter in the AI rejection reason box closing the dialog without recording the rejection.
  • Fixed the cell editor opening with the caret at the start.
  • Fixed the welcome window's last-opened time clipping.
  • Fixed Redis member table columns not fitting their content, and numeric member columns not right-aligning.
  • Fixed the ER thumbnail not drawing table names, and MongoDB search saying "tables" instead of "collections".
  • Fixed Redis and MongoDB stat cards not aligning in one row, and Mongo index and validation pages showing row statistics in the bottom bar.

0.8.0

New Features

  • Indigo Theme: A new default theme family for new installs, with a deep navy dark mode and an indigo accent. Existing users keep the theme they chose; Cupertino, DbCat and Dawn stay available.
  • Result to Chart: Query results can be shown as a bar, line, pie or single-value chart, toggled next to Data. DbCat recommends a chart from the column types. A -- chart: comment sets it explicitly.
  • Chart Export: Copy a chart as an image, or export it as PNG or SVG.
  • ER Diagram Export and Join Paths: Export the ER diagram as SVG or PNG (2×), or copy it as an image. Pick two tables (⌥-click or the toolbar) to highlight the foreign-key path between them, then open a ready-made JOIN query with ⌘↩.
  • Built-in Sample Database: A SQLite sample database with five related tables and 18 months of orders. Open it from the empty connection list, the welcome sidebar or the Help menu. The overview offers "Try these" items, including two charts and an ER diagram.
  • Database Overview: The empty content view shows database statistics, the largest tables, recent queries, quick actions and an ER thumbnail.
  • Typed Result Grid: Tables and query results show booleans as checkmarks, dates and times with the time part muted, compact JSON previews and colored status values. Column widths fit their content.

Improvements

  • Chart Axes: Value axes use round ticks, and large numbers are abbreviated (for example 1.2M). Charts have a legend and a settings popover for their axes.
  • Categorical Colors: Every built-in theme now has a categorical palette for charts and ER tables, so tables are no longer all blue. Red and green stay reserved for status.
  • ER Diagram: Each table has its own color with a header stripe. Selecting a table no longer dims the others, and view changes animate (instantly with Reduce Motion).
  • Query Plans: Plan cards are more compact, and a new plan fits the window on first view.
  • Motion: Query results fade in, and plan nodes appear in sequence.
  • Table Stats: Table sizes and row counts for a whole database are read with one metadata query. SQLite uses sqlite_stat1 for row counts when the database has been analyzed.
  • Keyboard Access: Overview rows are focusable buttons: Tab reaches them, and Enter or Space opens them.

Bug Fixes

  • Fixed MySQL EXPLAIN, DESCRIBE and ANALYZE being cut short by the session row limit, which added an extra Limit node to plans and shortened EXPLAIN ANALYZE runs.
  • Fixed SQLite overview showing 0 B for index and total size.
  • Fixed SQLite table details showing no row count.
  • Fixed running a query leaving the completion popup open.
  • Fixed the sidebar width changing when the details panel appears or hides.
  • Fixed the connection form flickering while a connection test or save runs: the previous result stays until the new one arrives, quick results no longer flash the bottom bar, and a late result no longer overwrites a form you have since changed.
  • Fixed the bottom bar of narrow table views clipping the row count and timing.

0.7.3

New Features

  • AI Access via MCP: DbCat has a built-in MCP server, so AI tools can work with the connections you open to them. Claude Code, Claude Desktop, Codex, Cursor, VS Code, Windsurf and Antigravity can be added in one click from Settings → MCP; other tools can use a copied command or JSON. Reads run directly. Writes wait for your approval in DbCat, and ordinary writes can be allowed per connection. AI tools start DbCat in the background when they need it, and reconnect after DbCat restarts or MCP is turned off and on.
  • Copy as URL with Password: A new context-menu item copies a connection's URL including its password, taken from the keychain or from the password you typed this session. Plain Copy as URL still never includes the password.

Bug Fixes

  • Fixed two sets of window buttons being drawn on Windows.
  • Fixed title-bar controls overlapping and the close button being pushed out of narrow windows. The title bar now collapses step by step as the window narrows: on Windows the menu bar becomes one menu button, back and forward hide, and the search box and mode pill shrink.
  • Fixed Windows upgrades and uninstalls failing with "DeleteFile failed; code 5" while an AI tool was still running DbCat's MCP bridge. The installer now stops the bridge first.

0.7.2

New Features

  • Windows Auto-Updates: The Windows version checks for new versions and offers to install them, like the macOS version. Automatic checks are on by default. Windows users who installed 0.7.0 or 0.7.1 must download and install 0.7.2 once from the website; updates arrive automatically after that.

Improvements

  • Schema-Aware Completion: Tables in schemas owned by an extension (such as TimescaleDB's _timescaledb_catalog) no longer crowd unqualified FROM completion. They appear after you type the schema name. On PostgreSQL, extension-owned schemas are listed in their own group after your schemas.
  • Wider Completion Menu: The completion menu is wider, so long table names are no longer cut off mid-word.
  • Large Results: Showing or switching a large result no longer copies its whole row set on the interface thread.
  • Safer Window Close: Closing a workspace window with the window button asks before discarding uncommitted changes.
  • Smaller App: The Apple silicon app binary shrank from 95.7 MB to 81.6 MB.
  • DuckDB Backup Unavailable: DuckDB database backup and restore are temporarily unavailable: they downloaded a Parquet extension on first use, which failed offline and on Windows. They will return in a later version.

Bug Fixes

  • Fixed a running statement continuing after its tab, window, or connection was closed.
  • Fixed connection pools and SSH tunnels staying open after a workspace window was closed with the window button.
  • Fixed completion showing results from a previous target, and failed lookups being cached.
  • Fixed stale sidebar connect and schema-list results, and auto-refresh starting again while the previous refresh was still loading.
  • Fixed striped tables still showing empty filler rows for a moment when results first load.
  • Fixed double-clicking the cell you are editing in query results replacing what you typed with its original value.
  • Fixed DuckDB files held open by another process on Windows not being detected as locked.
  • Fixed ~\ not being expanded in path fields on Windows.

0.7.1

New Features

  • Windows Installer (Beta): DbCat for Windows 11 (x64) ships as a per-user installer. Passwords are kept in Windows Credential Manager, SQL Server Windows authentication is supported, and ssh-agent works through the OpenSSH agent or Pageant. The installer is not code-signed yet, so Windows SmartScreen shows a warning on first launch: click "More info", then "Run anyway". Windows does not update itself yet; download new versions from the website.
  • Execution Plan Graph: The execution plan view has a graph mode with node cards, heat colouring relative to the hottest node, zoom and fit, a colour legend, a node detail panel, and keyboard navigation. Each node shows its self time and cost.
  • Report an Issue with Details: The bug report form opens with the app version, OS build, and CPU architecture already filled in (macOS also reports whether the app runs under Rosetta).

Improvements

  • Title Bar Tooltips: Title-bar tooltips open below the buttons, so they no longer sit under the traffic lights. Database kind menus show each kind's logo, and the current kind is marked in bold with the accent colour.
  • Windows Shortcuts: Shortcut labels use Ctrl on Windows (for example Ctrl+S), and the interface follows the system display language.

Bug Fixes

  • Fixed a crash when closing a window (including right after connecting) on Macs with a Touch Bar (#1).
  • Fixed striped tables showing their empty filler rows seconds after the data appeared.
  • Fixed query history growing without limit: statements over 256 KB are no longer stored, and oversized older entries are dropped.
  • Fixed config file reads blocking the interface when a workspace opens.
  • Fixed SQL Server Windows-authentication failures being reported as query errors instead of login failures.

0.7.0

New Features

  • Customizable Keyboard Shortcuts: Preferences has a Shortcuts page that lists every command by category. Record a new key combination in place, reset one command, or reset all of them; the menu bar follows your changes. The Redis new-key shortcut stays fixed.

Improvements

  • Preferences Layout: Settings are grouped into cards with page icons, descriptions, and hints. Resetting a page restores its defaults.
  • Shortcut Display: Key combinations are shown as clearer key caps, and global search also finds commands on the Shortcuts page.
  • Cell Editors: Cell editors take keyboard focus as soon as they open.
  • MariaDB Expression Indexes: The structure editor refuses expression indexes on MariaDB, which does not support them, and says so.

Bug Fixes

  • Fixed input placeholders staying in the previous language after switching the interface language.

0.6.0

New Features

  • Valkey, TiDB, CockroachDB & DuckDB: Connect to Valkey (its own version is shown), TiDB (distributed, MySQL-compatible), CockroachDB (distributed, PostgreSQL-compatible), and local DuckDB .duckdb files. Backup and restore work on TiDB, CockroachDB, and DuckDB too; DuckDB backups use its native EXPORT / IMPORT DATABASE folders.
  • DuckDB Data & Structure: Browse and edit rows in place (tracked by rowid), run queries with chunked streaming and cancellation, design table structures, and create tables with auto-increment sequences. On DuckDB, changing a column's name or type, or dropping a column, on a table with secondary indexes requires dropping those indexes first (an engine limit).
  • TiDB & CockroachDB Execution Plans: The execution plan view supports TiDB (EXPLAIN FORMAT='tidb_json') and CockroachDB, showing operators, costs, and runtime statistics as foldable trees.
  • CockroachDB Sessions & Users: See running queries and sessions, cancel or kill them (the confirmation shows the exact statement that will run), and manage users, grants, and default privileges.

Improvements

  • Consistent Backups: On MySQL, MariaDB, TiDB, PostgreSQL, and CockroachDB, a backup reads every table from one point in time, so related tables stay in step. On TiDB, a long backup holds back garbage collection while it runs. If some tables use a non-transactional engine (such as MyISAM), the completion notice lists them.
  • Copy Buttons: Truncated names, statements, and column types show their full text in a hover card with a copy button. Statement previews get a copy-all button, and error messages get a Copy action.
  • Table Tabs: A single click opens a table in the preview tab, and double-click pins it. A new table loads without a blank frame, and its key icons and column types appear together with its first page.
  • Row Number Menu: Right-click a row number for a row menu. The favorites list shows only the current connection's favorites.
  • CSV Import into Binary Columns: 0x…, \x…, and X'…' values import into binary columns as bytes, so a CSV exported by DbCat imports back unchanged.
  • Connections from Newer Versions: Connections this version cannot read are kept on disk and written back unchanged. The Welcome status bar shows how many there are.
  • Restricted Accounts: On MySQL, MariaDB, and TiDB, the Users & Privileges page is disabled with an explanation when the connected account lacks permission to manage users, instead of failing on save.
  • App Icon: The app icon uses the navy variant.

Bug Fixes

  • Fixed SQL Server failing to set a binary cell to NULL (error 257) or to import NULL into one.
  • Fixed MySQL, MariaDB, and TiDB reading VARBINARY columns as text instead of raw bytes.
  • Fixed TiDB backups making restored tables jump ahead in auto-increment IDs.
  • Fixed TiDB view backups keeping the source database name, and restoring tables with AUTO_RANDOM columns failing on explicit inserts.
  • Fixed CockroachDB backups rewriting sequence defaults (nextval) to bigserial.
  • Fixed PostgreSQL and SQL Server tabs reopening in the wrong database after a restart. The session now records each tab's database.
  • Fixed a table's error from the previous table showing under the newly opened table's title.

0.5.0

  • SQLite 整库备份与还原:支持将 SQLite 数据库导出为 SQL 备份文件,并还原到另一个 SQLite 文件。完整导出表、视图、索引、触发器、自增计数器及全文搜索(FTS5)等虚拟表,支持仅结构、仅数据或完整备份,可在侧栏、文件菜单及欢迎窗口选择器中发起。
  • SQLite 与 SQL Server 复制表:支持在 SQLite 和 SQL Server 上快速复制已有表结构、约束、索引与数据。新表上的约束与索引自动改名,避免在库或 Schema 内重名,自增与标识列的值保留;外键与触发器不复制(与其他数据库一致)。
  • 新建表可视化外键配置:在 MySQL、MariaDB、PostgreSQL、SQLite 与 SQL Server 的新建表表单中可视化添加外键约束。支持搜索并选择被引用的表与列,支持自引用表,可配置 ON UPDATE 与 ON DELETE 级联规则,并在执行前完成校验。
  • PostgreSQL 与 ClickHouse 枚举下拉:浏览数据表或在查询结果中就地编辑单元格时,PostgreSQL 的 ENUM 类型与 ClickHouse 的 Enum8 / Enum16 列现已支持下拉选择预设枚举值,体验与 MySQL 保持一致。
  • 支持取消正在建立的连接与界面打磨:可在欢迎窗口连接列表或点击左侧连接栏的转圈图标随时取消正在建立的连接,Microsoft Entra ID 交互式浏览器登录也支持随时中断退出且不弹错误提示。备份对话框的 Schema 分组表头支持键盘焦点与空格键切换选择。
  • 写入保护分级与高危操作拦截:连接配置中的写入保护升级为四段分段选择:允许写入、危险前确认、写前确认与只读。新增的「危险前确认」档在日常写入时不打扰,仅在执行高风险操作(如 DROP、TRUNCATE、ALTER、RENAME、GRANT/REVOKE、无 WHERE 条件的整表 UPDATE 或 DELETE、无条件的 MongoDB 集合删除/清空)或终止会话(KILL)时弹窗确认。新建连接点选 staging 标签自动建议危险前确认,点选 prod 建议写前确认。
  • 修复数据修改 CTE 识别:修复 PostgreSQL 中包含写入的公用表表达式(如 WITH … DELETE … RETURNING)被误判为只读查询、从而绕过只读连接拦截和写前确认的问题。
  • 拖动排序连接:在连接管理窗口中拖动连接即可调整顺序,其他行实时让位标出落点;拖到某个文件夹下方即移入该文件夹。⌥⌘↑ / ⌥⌘↓ 可在文件夹内上下移动选中的连接。
  • 密码输入框重做:"每次询问"的密码对话框显示连接的图标、名称与地址,支持显示密码,并按原样提交(不再去掉首尾空格)。
  • 修复与打磨:在没有打开标签的连接窗口按 ⌘W 不再导致 DbCat 意外退出,而是关闭连接并回到连接管理窗口;查询标签分屏时 ⌘W 先关闭当前分屏;新建查询 / Redis 控制台 / Pub/Sub 标签按已打开的最大编号续号;MongoDB 工作区侧栏显示为"集合"并提示 mongosh 语法,补全只高亮已输入的前缀;ClickHouse 图标去掉黑色底块,Cupertino 浅色主题的侧栏带上浅灰底色。

0.4.0

  • 支持 SQL Server 与多种认证方式:支持 SQL Server 账号、Windows(NTLM)、Kerberos 以及 Microsoft Entra ID(密码、服务主体、浏览器交互式 PKCE 登录、访问令牌)认证。支持各档 TLS 加密(禁用、首选 / 必需并信任自签证书、校验 CA、校验 CA 与主机名)、SSH 隧道,以及导入与复制 mssql://、sqlserver://、microsoftsqlserver:// 和 jdbc:sqlserver:// 连接地址。
  • SQL Server 浏览、编辑与结构设计:像 PostgreSQL 一样在连接内切换数据库,按 schema 浏览表、视图、存储过程、函数、触发器、序列与同义词(含 master / msdb 的系统对象)并查看 ER 关系图。支持在 XACT_ABORT 原子事务中就地编辑表数据,可视化设计列、命名默认约束、索引(含 INCLUDE 包含列与过滤条件)、主键 / 唯一键、外键及 MS_Description 注释,执行前均可预览 DDL。
  • SQL Server 查询执行与可视化执行计划:按 GO(含 GO n)拆批执行多结果集脚本,通过 TDS Attention 实现查询取消、超时与行数上限截断,中断后保持当前会话、临时表与未提交事务不丢失。支持估算(SHOWPLAN_ALL)与实际(STATISTICS PROFILE)可视化执行计划,计划树节点可折叠与展开。
  • SQL Server 用户权限、导入导出与进程列表:管理服务器登录、数据库用户、服务器与数据库角色成员,以及数据库 / Schema / 表 / 函数 / 序列级的 GRANT 与 REVOKE 权限网格。支持 CSV / JSON / SQL 导出(自动包裹 SET IDENTITY_INSERT ON/OFF)、分批 CSV 导入,以及查看进程列表与终止会话(KILL)。
  • 连接管理窗口重做:全新欢迎与连接管理窗口,左侧提供「所有连接」(支持可折叠文件夹)、「收藏星标」与「最近使用」视图,顶部可按数据库类型筛选与搜索;连接列表、左侧连接栏与侧栏卡片统一换用数据库产品图标。连接支持星标与标签(预设 local / dev / test / staging / prod 或自定义文字,新建连接选 staging / prod 自动勾选写前确认),并支持 ⌘N、⌘F、⌘1–⌘9 快捷键。
  • 多 Schema 备份与还原重做:PostgreSQL 与 SQL Server 支持将同一数据库的多个 schema 备份到单个文件中,跨 schema 全局排序类型、函数、序列、表、数据、外键、视图与触发器,跨 schema 外键与视图依赖链可原样还原。全新备份与还原对话框按 Schema 分组展示表与视图(支持三态勾选与搜索);PostgreSQL 勾选「先删除同名对象」时先删外键再删表且不再带 CASCADE,避免连带删掉备份范围外的对象。
  • 欢迎窗口备份与还原选择器:从欢迎窗口发起备份或还原时,PostgreSQL 与 SQL Server 直接列出服务器上的真实数据库(支持搜索,后台直接连接所选库而不改动已打开工作区的当前库),MongoDB 与 Redis 连接也会在列表中显示并跳转到各自的备份 / 还原对话框。
  • 切换面板分组计数、跨 Schema 补全与界面打磨:切换面板将用户 schema 与系统 schema 分组展示并显示对象数量;PostgreSQL 与 SQL Server 查询编辑器支持补全其他 schema 的 schema.table。空表保留表头且不再闪烁,执行计划节点可折叠与展开,关闭连接时立即释放连接池会话。

0.3.3

  • Apple 芯片与 Intel 分开下载:不再提供 universal 安装包,改为按芯片各出一个 DMG,下载体积约减半。官网默认下载 Apple 芯片版,按钮下方提供 Intel 版链接;自动更新会按你的 Mac 选择对应版本。
  • ⌘W 可关闭更多窗口:欢迎窗口、偏好设置、新建 / 编辑连接窗口都可用 ⌘W 关闭;连接窗口里没有打开的标签页时,⌘W 关闭该连接。

0.3.2

  • 支持 Intel Mac:DbCat 改为 universal 应用,在 Apple 芯片与 Intel 芯片的 Mac 上都原生运行(macOS 12 及以上)。
  • 主题与外观重做:偏好设置合并为一页「主题与外观」:明暗模式、带大缩略图的主题卡片、界面与编辑器字体集中一处。可按主题、按浅色 / 深色分别自定义语法颜色(含粗体 / 斜体)与数据网格状态色(NULL、已修改、新增、删除、选中),并实时预览 SQL 编辑器与示例网格;主题可导出为 JSON 文件,也可从 JSON 导入。
  • 欢迎窗口精简:欢迎窗口更紧凑;连接的操作改为右键菜单,搜索框旁的"导出 / 导入全部连接"菜单已移除。
  • Redis 哨兵与集群:新建连接时可选择单机 / 哨兵 / 集群。哨兵模式经哨兵解析主库,哨兵可单独设置认证;发生故障转移时自动切换到新主库并提示。集群模式按 slot 路由读写,键浏览跨所有分片扫描,提交修改按 slot 分组执行。新增「拓扑」页查看节点、角色、slot 分布与状态;服务器信息、客户端、慢日志、配置与 ACL 可按节点查看,ACL 修改会应用到所有节点。支持导入 redis-sentinel:// 地址。哨兵与集群连接暂不支持 SSH 隧道。
  • 提示统一:所有应用内提示按含义分为成功 / 信息 / 警告 / 错误四种样式;错误提示不再自动消失,需手动关闭;相同提示不再重复堆叠;导入导出、备份恢复等长任务在你切到别的应用时完成,会同时发送系统通知。
  • 界面文字修整:中文界面里仍显示英文的几处菜单项、表头与标签已补译(如「查询」菜单的 Explain、用户权限的 Host、筛选栏的 Raw SQL、分页的 Limit / Offset);连接窗口、用户权限页、导出对话框与 Redis 页面中英文文字被截断的控件已放宽,并缩短了部分过长的英文文案。

0.3.1

  • 中英双语界面:全部界面、macOS 原生菜单栏、对话框与导入导出流程现已支持 English 与 简体中文。
  • 跟随系统与即时切换:默认跟随 macOS 系统语言;可在「偏好设置 → 通用」中切换为跟随系统、简体中文或 English,无需重启立即生效。
  • 统一的驱动报错与日志:数据库驱动报错、校验信息、执行计划节点、备份文件头注释与诊断日志统一为英文原文,便于检索与排查问题。

0.3.0(首个公开 Beta)

新数据库

  • ClickHouse:浏览与筛选、查询编辑器、表结构查看与修改(MergeTree 引擎选项、分区、排序键)、导入导出。
  • MariaDB:独立连接类型;序列的查看、重置、删除与备份,列 CHECK 约束,账户锁定与角色。
  • Redis:键浏览与按模式批量删除、按类型编辑值(暂存后以 MULTI/EXEC 提交,提交前预览命令)、就地改 TTL 与重命名、命令控制台、Pub/Sub、服务器信息与慢日志、ACL 用户管理、导入导出与 DUMP 备份恢复。
  • MongoDB:表格 / JSON / 树三种视图并可就地编辑,mongosh 查询编辑器(补全、explain、可编辑结果),索引与校验规则,集合与库管理,进程列表、服务器状态、用户与角色,导入导出与备份恢复;支持 mongodb:// 与 mongodb+srv://。

新功能

  • 连接栏:每个窗口左侧一列连接图标,一个窗口里开多个连接,⌘1…9 切换,⌘⇧K 快速选择;窗口各自保存与恢复会话。
  • 查询编辑器:查询参数(占位符弹窗绑定执行)、按外键补全 JOIN、子查询与 CTE 补全、分屏编辑、可视化执行计划与 ANALYZE。
  • 统一的提交栏:数据、结构、权限、Redis 键的待提交修改都在浮动提交栏里统一预览与提交;详情面板可逐字段撤销。
  • 界面:新的连接卡片与库切换器、标题栏全局搜索、前进 / 后退,新建连接窗口按类别分组。