DataOmni icon DataOmni v1.1.0
中文 GitHub

Changelog

User-facing release highlights, security hardening milestones, and on-disk configuration compatibility guarantees across DataOmni releases.

v1.1.0 — 2026-11-16 #

Expands structural engineering workflows and safe AI integration on top of the v1.0 desktop foundation, alongside strict WebView security hardening and DuckDB 2.0.

  • Read-only MCP server (dataomni mcp): built-in stdio MCP protocol server exposing 11 read-only tools across SQL and MongoDB / Redis / Neo4j / Elasticsearch, sharing the OS keychain HMAC-SHA256 grant and physical Production profile invisibility.
  • Cross-connection schema diff & sync DDL: compare tables, columns, primary keys, indexes, and foreign keys between two connections and generate reviewable sync scripts verified end-to-end across PostgreSQL, MySQL, SQLite, SQL Server, and DuckDB.
  • Editor :name bind parameters: typed parameter bar (text, number, boolean, date/time, NULL, unset) mapped to native driver placeholders ($1, ?, @p1, :name) while ignoring comments, string literals, PostgreSQL $$...$$, and Oracle q'[...]'.
  • Deterministic ER diagram codegen: generate Prisma, TypeORM, MikroORM, SeaORM, and Rust sqlx models directly from live database catalogs offline, with zero LLM non-determinism.
  • Security & runtime hardening: enforced strict WebView Content Security Policy, moved SQLite fully onto the backend pool, blocked file operations inside app_config_dir, upgraded bundled DuckDB to 2.0 (supporting Windows file paths > 260 characters), and eliminated root UI re-renders on editor keystrokes.

v1.0.0 — 2026-11-05 #

First stable MIT-licensed desktop release across macOS (Apple Silicon), Windows (x64), and Linux (x86_64).

  • Unified multi-engine coverage: PostgreSQL, MySQL, SQLite, SQL Server, Oracle (Instant Client Basic Light bundled), DuckDB, ClickHouse, MariaDB, TiDB, OceanBase, CockroachDB, and openGauss, plus dedicated workspaces for MongoDB, Redis, Neo4j, and Elasticsearch / OpenSearch.
  • Zero-surprise editing & guardrails: local edit queue with exact parameterized SQL preview, single-transaction optimistic concurrency verification, environment badges (DEV / TEST / STAGING / PROD), and destructive-statement confirmation.
  • Credentials & networking: OS keychain storage (zero plaintext secrets on disk), built-in SSH jump-host tunnels with strict ~/.ssh/known_hosts verification, five TLS modes over rustls, and layered connection diagnostics.
  • Data workflows & Agent CLI: streaming CSV/JSON/SQL export, encoding-aware CSV import, native backups, visual execution plans, whole-database ER diagrams, and the read-only dataomni cli interface.

Upgrade & on-disk compatibility guarantee #

Forward- and backward-safe connections.json

DataOmni preserves unrecognized fields and newer connection entries verbatim when reading and saving connections.json (pinned by fixtures/on-disk-0.5/ conformance tests). Upgrading across 1.x releases — or rolling back to an earlier 1.x build — never drops saved connections or keychain references.