Xata is joining ClickHouse to bring agentic capabilities to ClickHouse Managed Postgres. Together, they are building a Postgres platform designed for modern applications and AI agents, combining high-performance production workloads with Xata’s technology for instant database provisioning, copy-on-write branching, and scale-to-zero compute.
Nothing changes for Xata customers in the short term, and the company continues to accept new sign-ups. In parallel, Xata is working on bringing branching and an agentic tier to ClickHouse Managed Postgres, with plans to eventually migrate Xata customers to the platform.
Xata’s technology addresses database workflow bottlenecks by enabling instant branching. Creating a copy of a production database is traditionally slow and expensive, especially with terabytes of data. Copy-on-write branching allows new branches with production data to be created in seconds without duplicating underlying storage. Even databases with multiple terabytes can be branched in around three seconds. These branches are fully independent, with their own compute running on different physical nodes, ensuring no impact on the parent database.
Key capabilities include instant database provisioning, instant copy-on-write branching, scale-to-zero compute, and anonymized production data. This makes it remarkably cheap to run a branch per pull request, agent run, or SQL session. AI-native customers like Sapien, Enginy, David AI, Runner AI, and Loop AI each create thousands of database branches weekly. Xata also contributes open-source projects to the Postgres ecosystem, including pgstream for logical replication with anonymization and pgroll for zero-downtime schema changes.
ClickHouse Managed Postgres, built on local NVMe storage, is currently the fastest Postgres service available. The two platforms share a common foundation of unmodified vanilla Postgres and a strong focus on reliability, positioning them well for quick integration. David AI exemplifies a customer leveraging the combined capabilities.
Source: Hacker News · Summarized by HeadlinesBriefing