Xata.io

Most “try this query on prod” workflows still look the same: clone the database, wait, hope the dump finishes, clean up later (or never). xata scratch is a new command in the Xata CLI that short-circuits that. It forks a disposable branch off your real Postgres, including databases at 2TB+, in about a second. You land in psql (or run SQL inline), experiment safely, and when you exit the branch is torn down. Same data shape as production. No leftover environments. No waiting on a full copy. Demo below.

If you run Postgres replication in a hosted or multi-tenant setup, the names flowing through that path, source objects, replication slots, table filters, are not always fully under your control. pgstream v1.1.1 tightens exactly that. pgstream is the open source engine behind xata clone stream, the path that copies an existing Postgres into Xata. In v1.1.1, SQL identifiers, replication slot names, and plugin options are bound and escaped instead of interpolated as raw text, so a crafted name cannot break out onto the target. It is backported to v0.9.15, so teams on the 0.9.x line pick it up without upgrading. The release also widens snapshot and restore coverage for production-shaped schemas: - materialized views refresh after restore, in an opt-in step you turn on when you want it - inheritance and partition hierarchies snapshot cleanly - tables using CLUSTER ON restore in the right order - int4range, int8range and tstzrange columns come across intact No breaking changes, and the xata CLI is rebuilt on v1.1.1. https://lnkd.in/eeuyfTcs

in case you needed a sign → we're hiring at Xata.io ✨ 2 new roles are open and we're on the lookout for the right people: → Product Marketing Lead - https://lnkd.in/erTY5Wtn → Senior Backend Engineer (Go) - https://lnkd.in/esMMkvJN → remote-first + coworking budget → must be coming from a B2D / infra / dev tools company If you want to build genuinely great infra with a seriously sharp team, this is it. We're moving fast and aiming high (the bar is real). If that's you, or someone you'd instantly tag, my DMs are open 💌 #hiring #backendengineer #productmarketing

Xata is growing, and product marketing is how we define the category we're building: Postgres for agentic development. Our first PMM Lead will own positioning, launches, and developer-facing content, built from scratch with the founders and engineers. Come build it with us → https://lnkd.in/edZ98yGp

Today we're launching the Xata GitHub App. Until now, if you wanted to automatically create a Postgres branch from production for every pull request, we pointed you to our GitHub Actions examples. They worked well, but every team had to copy and maintain the workflow in each repository. With the GitHub App, you install it once, connect your repository, and every pull request automatically gets its own isolated Postgres branch. Every change gets tested in a production-like environment before merging. One thing we've noticed: once teams adopt this workflow, the number of active database branches grows a lot, often living for less than 10 minutes. See it in action in the demo below 👇 https://lnkd.in/eb4HK4CC

Today we're launching the Xata GitHub App. Connect a repo, and every pull request gets its own Postgres branch off the database you already run.

Introducing the Xata GitHub App. Many of our customers are now adopting the branch-per-PR workflow, where each agent-led task gets an isolated Postgres database to use for testing and previews. Rather than asking our customers to do an additional step, we built a GitHub app so branches are created automatically the moment a PR is opened. • Agents can build, test, and revise in isolation producing higher quality, more reliable code with less risk • Branches are ephemeral by nature, living less than 5 minutes on average, keeping compute costs marginal • Copy-on-write branching delivers a full production like database instantly, without multiplying storage costs. Learn more about the Xata GitHub app workflow in the video.

Xata is now on Google Cloud. Spin up an isolated Postgres branch from your production data in 3 seconds, in-region in us-central1 (Iowa). Every coding agent, pull request, and CI run gets its own production-like database. No shared staging, no migration. Free until September 13. Here is what you can do with it: Coding agents Give every coding agent its own isolated Postgres branch in 3 seconds. Build, test, and validate changes against production-like data. Deployment previews and CI Create a fresh Postgres branch in 3 seconds for every pull request and test run. Review every change against production-like data. AI application builders Provision a new Postgres database in a second for every generated application. Give every app its own dedicated database from day one. Built for instant Postgres branching: • Instant branches: an isolated branch in 3 seconds, starting from your full database with copy-on-write storage • Production data, anonymized: branch from production with sensitive fields automatically masked • Scale-to-zero compute: idle branches stop and wake on demand, so you keep thousands of short-lived branches without paying for idle compute • Available on Google Cloud: live today in us-central1 (Iowa), with more regions on the way A Postgres for every job, now on Google Cloud. Add your card and run free until September 13. Read more: https://xata.io/get/gcp

Xata is now on Google Cloud, starting with us-central1 (Iowa). If you build on GCP, you can branch your production Postgres for every coding agent, pull request, and CI run, or provision a new database in a second for every AI-generated app. Same instant copy-on-write branching, scale-to-zero, and anonymized production data free until September 13. Our founder Monica Sarbu on what shipped, below.