Postgres just got time travel for AI agents with the Gnomon extension

Gnomon is a new PostgreSQL extension that brings Git-like version control directly to your database, allowing developers to create instant branches of production data without copying it. By running 'create extension gnomon', teams can spin up isolated branches for AI agents, feature development, or testing that track only the changes made, not the entire dataset. Each branch appears as a simple connection string, meaning applications don't need modifications to use it—they just connect to the branch's URL.

This fundamentally changes how engineers can safely experiment with live data. AI agents can be given their own sandboxed branch to perform operations like updating order statuses, with every field change recorded and reviewable through a SQL 'diff' command. Teams can then merge an agent's work back into the main branch with a three-way, type-aware merge or completely undo it if something goes wrong. The takeaway: database versioning just became as straightforward and powerful as code versioning, unlocking safer, more auditable workflows for the age of AI assistants.