Gnomon: Git-like version control for Postgres data built for AI agents
·2026.11.14 02:09
Key point
Gnomon is an open-source PostgreSQL extension that provides branch, diff, and merge capabilities for database data, allowing AI agents to safely modify production data with full auditability and undo functionality.
Details
- Gnomon is a PostgreSQL extension (PostgreSQL 15-18) that implements Git-like version control for database rows, enabling agents to work on isolated branches of production data without copying the database.
- Agents receive a dedicated database role, branch, and connection string, ensuring they can only read and write to their assigned branch while Postgres enforces isolation from the main database.
- The system supports type-aware three-way merges, row-level diffs for review, and time-travel queries to read the database state at any specific past moment.
- TypeScript and Python SDKs are provided to manage agent runs, with integrations for frameworks like the Anthropic SDK, OpenAI Agents SDK, and LangChain, plus an MCP server for agent interaction.
This summary was generated automatically by AI. Check the original for the author's claims and context. Copyright belongs to the original author.
Our guide explains how the AI works. Report summary errors, attribution issues, or removal requests via Contact.