Skip to content

v0.1.0

Latest
Latest

Choose a tag to compare

View all tags
@github-actions github-actions released this 28 Aug 16:14
· 68 commits to main since this release
v0.1.0
234c504

DataZen v0.1.0

First public preview — an open-source, AI-native desktop database client for developers (Tauri v2 + Rust + React).
User manual: flyxl.github.io/datazen · Source: github.com/flyxl/datazen

Highlights

Connections & SQL workspace

  • PostgreSQL, MySQL/MariaDB, SQLite, Redis in the Basic installer; MongoDB, ClickHouse, DuckDB, SQL Server, and more in the -all variant
  • Modern SQL editor: completion, multi-statement results, streaming large result sets, EXPLAIN visualization
  • Virtualized DataTable: sort/filter/paginate, in-grid editing, CSV/JSON/SQL import & export
  • Schema tree: ER diagram, object DDL, privileges, admin commands (create DB/schema/user, grant/revoke)
  • SSH tunnel, read-only connections, Safe Mode; import connections from TablePlus, Navicat, DataGrip, DBeaver, DBX

AI assistance

  • Natural language → SQL with live schema context
  • SQL error diagnosis and EXPLAIN analysis (with optional AI interpretation)
  • AI Chat sidebar: @ table/file references; OpenAI, Anthropic, DeepSeek, and custom endpoints
  • AI credentials encrypted locally (AES-256-GCM)

Migration toolkit (GA in v0.1.0)

Tool Entry Use when
Schema Diff Tools menu · connection tree Compare Schema Align structure with gated DDL deploy (additive by default)
Data Sync Tools menu · Compare Data Same dialect family, identical schema & PK → row-level diff → review → execute
Data Transfer Tools menu · Data Transfer Heterogeneous or mismatched schema → one-way structure + data (6-step wizard)

Schema Diff UI: 5-step wizard — Endpoints → Objects → Compare → Plan → Deploy.
Data Transfer UI: 6-step wizard — Endpoints → Setup → Objects → Mapping → Preview → Result.

Workflow automation

  • YAML workflows: Query / AI / Condition / Foreach / Merge / Transform
  • Cross-database flows (e.g. PostgreSQL orders + MySQL logistics + AI summary)
  • Runnable from GUI, AI sidebar, or MCP; bundled example workflows

Ops Dashboard

  • 12-column grid, SQL-bound widgets with background refresh
  • Threshold alerts (desktop / webhook), run history replay, dashboard import/export

Runtime plugins & themes

  • Install .zip extensions: Workspace pages and theme packs
  • Sandboxed iframe + controlled bridge; datazen:// asset protocol
  • Sample packs: community.slate-blue theme, datazen.playground demo page

MCP

  • MCP Server: expose DB tools, schema, workflows to external agents; headless --mcp-stdio
  • MCP Client: connect external MCP servers from Settings (full AI Chat tool-loop integration evolving)

Backup & app data

  • SQL backup/restore sub-window (staged progress, optional Gzip, destructive-overwrite confirm)
  • App data export/import (connections, workflows, history; master key excluded)

Also in this release

  • Deep Redis ops: key browser, command console, monitor, Pub/Sub
  • Charts from query results; PNG/SVG export
  • 10 UI locales (en, zh-CN, zh-TW, de, es, fr, ja, ko, pt-BR, ru)
  • datazen-driver-api on crates.io for independent Git driver development

⚠️ Breaking changes

This release unifies connectionId (persisted connection config) and dbSessionId (runtime session). No legacy key aliases.

Area Change Migration
MCP DB tools arg config_id → connection_id Rename JSON keys in agent payloads
MCP resources Schema URI {connectionId}; history field configId → connectionId Parse new field names
SQLite history DB columns config_id → connection_id Auto-migrated on startup
Schema Diff config clipboard JSON v2; v1 rejected Re-export after picking connections in UI
Sync task persistence session + connection dual ids Finish in-flight tasks before upgrade
Plugin bridge command.invoke configId → connectionId Upgrade plugin-sdk

See CHANGELOG.md.

Install variants

Three installer variants (pick what you need):

  • Basic (no suffix): PostgreSQL, MySQL, SQLite, Redis — recommended default, smallest size
  • All (-all in filename): all path native drivers (MongoDB, SQL Server, ClickHouse, DuckDB, etc.; excludes Kiwi / Superset / OLAP git drivers)
  • Akulaku (-akulaku): Basic + MongoDB + Kiwi + Superset

Build from source with explicit driver lists: DATAZEN_DRIVERS=postgres,mongodb, etc.

macOS

The app is not notarized. If macOS reports the app as damaged or from an unidentified developer:

  1. After installing, run in Terminal: 
    xattr -cr /Applications/DataZen.app
  2. Or: right-click the app → Open → confirm once in the dialog.

Windows

Run the .exe or .msi installer.

Linux (x86_64)

  • AppImage: chmod +x *.AppImage then run (may need libfuse2)
  • deb: sudo apt install ./DataZen-*-linux-x64.deb
  • rpm: sudo rpm -i ./DataZen-*-linux-x64.rpm
  • Requires WebKitGTK (libwebkit2gtk-4.1-0 / webkit2gtk4.1)

DataZen v0.1.0（中文）

首个公开预览版 — 面向开发者的开源 AI 数据库桌面客户端（Tauri v2 + Rust + React）。
使用手册：flyxl.github.io/datazen/zh/ · 源码：github.com/flyxl/datazen

亮点

数据库连接与 SQL 工作台

  • Basic 包内置 PostgreSQL、MySQL/MariaDB、SQLite、Redis；-all 变体可选 MongoDB、ClickHouse、DuckDB、SQL Server 等
  • SQL 编辑器：补全、多语句多结果、流式大结果集、EXPLAIN 可视化
  • 虚拟滚动 DataTable：排序/筛选/编辑、CSV/JSON/SQL 导入导出
  • 连接树：ER 图、对象 DDL、权限、管理命令；SSH 隧道、只读连接、Safe Mode
  • 支持从 TablePlus / Navicat / DataGrip / DBeaver / DBX 导入连接

AI 辅助

  • 自然语言 → SQL（自动注入 Schema 上下文）
  • SQL 错误诊断、EXPLAIN 分析（可选 AI 解读）
  • AI Chat：@ 引用表/文件；多 Provider；凭据 AES-256-GCM 本地加密

迁移三件套（v0.1.0 GA）

工具 入口 场景
Schema Diff Tools 菜单 · 右键「比较架构」 结构对比 + 受控 DDL 部署
Data Sync Tools 菜单 · 右键「比较数据」 同族库、结构/PK 一致 → 行级同步
Data Transfer Tools 菜单 · 右键「数据传输」 异构/结构不一致 → 单向迁移（6 步向导）

Schema Diff：5 步向导（Endpoints → Objects → Compare → Plan → Deploy）。
Data Transfer：6 步向导（Endpoints → Setup → Objects → Mapping → Preview → Result）。

其他

  • Workflow 自动化（含跨库、Merge/Transform 步骤）
  • 运营看板（监控 Widget、告警、导出）
  • 运行时插件与主题包
  • MCP Server / Client
  • 备份恢复与应用数据导入导出
  • Redis 深度运维、图表、10 种界面语言

⚠️ 破坏性变更

统一 connectionId（持久化连接） 与 dbSessionId（运行时会话），不保留旧键名别名。
MCP 工具参数、Schema Diff 配置 v2、插件桥、SQLite 历史库列名等均有变更 — 详见 CHANGELOG.md。

安装包变体

  • Basic（无后缀）：PG / MySQL / SQLite / Redis
  • All（-all）：全部 path 原生驱动（不含 Kiwi / Superset / OLAP）
  • Akulaku（-akulaku）：Basic + MongoDB + Kiwi + Superset

macOS

未公证。首次打开若提示损坏，请执行 xattr -cr /Applications/DataZen.app，或右键 → 打开。

Windows / Linux

直接安装 .exe / .msi；Linux 支持 AppImage / deb / rpm（需 WebKitGTK）。

Basic installer checksums (SHA256)

For Homebrew / WinGet templates in packaging/. Excludes -all and -akulaku variants.

File SHA256
DataZen-0.1.0-1.x86_64-linux-x64.rpm d36078c55193d75e614628fd3f430c2f66445d49279e8d73ee3519a30cbbd02f
DataZen_0.1.0_aarch64-macos-arm64.dmg a3c69de9aed0222c890a4963d6285085f278e2dab8740077cd1772362d6bd647
DataZen_0.1.0_amd64-linux-x64.AppImage ced998f4a9b0347311ef4afd17dfe49098ec70f5da3ffd4357adbbe678d51d56
DataZen_0.1.0_amd64-linux-x64.deb 7a4bae825c582e736d9d0c179d8a94484e606b137777fa4484953f6d4248fb5e
DataZen_0.1.0_x64-macos-x64.dmg e6c87dd723ff794f68bf6789d37e43420e848259a1b867a6b66eeb8b63ffca25
DataZen_0.1.0_x64-setup-windows-x64.exe eef03afa4018c6d2bd8d56de7c41e556784fe3c3b2e85063576f3eeb6fc46e47
DataZen_0.1.0_x64_en-US-windows-x64.msi ad378a00c45ad69c73a60c350d8dae59dce1e87ee51bc763ecfa010585dfa708
Assets 31
Loading