MatrixOne adds snapshots and branches for AI agent database writes

On October 3, 2026, a post on V2EX described new capabilities in MatrixOne, an open-source database that is compatible with the MySQL protocol. The release adds four native SQL features — Snapshot, Branch, Diff and Merge — aimed at the risks that come with letting AI agents write to a database.

The idea, as presented in the post, is to bring a Git-style workflow to tables. Before an agent starts working, a Snapshot can be taken of the table; snapshots record metadata only and do not copy data, so the table can later be compared against or rolled back to that point. The agent's inserts, updates and deletes then happen on a writable table branch instead of the main table. Diff provides a row-level comparison between the branch and the main table, showing which rows changed and what they were changed to. Once a change is approved, Merge applies it back to the main table according to an explicit conflict strategy; if it is not approved, the branch can simply be discarded. In the post's framing, this is essentially opening a pull request on a table: isolate, review, approve, merge.

The post also sets out the limits of the feature. These are described as low-level primitives only, and validation rules, approval flows, permissions and auditing still have to be implemented by the adopting system. The examples in the accompanying tutorial are said to be demonstration scenarios. The motivation given is that an agent holding a connection with write access can alter thousands of rows if a single WHERE clause is written too broadly, leaving no clear account of which rows were changed afterwards. The report does not mention a release schedule, version numbers, or any organizations using the feature.