Xata - Postgres at Scale
@xata.io
With copy-on-write branching, data masking, separated storage & compute , 100% Postgres
Pinned
Xata - Postgres at Scale
@xata.io
· May 14
Xata: Postgres with data branching and PII anonymization | xata
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.
xata.io
📣 We have a brand new Postgres platform with:
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
It’s for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in 🧵
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
It’s for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in 🧵
Club Xata Rome 2025: our biannual reset.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
The Villa Getaway: Club Xata Rome 2025 by Natalia Woroniec
Somewhere between a team retreat and a family holiday, our week in Rome was about connection, ideas, and joy of being in one place together. A reminder of what can happen when the whole team shares…
xata.io
October 31, 2025 at 1:36 PM
Club Xata Rome 2025: our biannual reset.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
Day 1 at #PGConfEU kicked off with Community Summits!
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
October 21, 2025 at 1:38 PM
Day 1 at #PGConfEU kicked off with Community Summits!
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
The countdown to #PGConfEU is on ⏳
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
October 17, 2025 at 3:38 PM
The countdown to #PGConfEU is on ⏳
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
Branch settings, faster.
We reorganized the page and added search.
What changed
Search to jump directly to a setting.
Logical groups with clear labels.
Guardrails to reduce misclicks.
Why it helps
Quicker navigation.
Less guessing, safer edits.
Want early access? Ping us and we’ll enable it.
We reorganized the page and added search.
What changed
Search to jump directly to a setting.
Logical groups with clear labels.
Guardrails to reduce misclicks.
Why it helps
Quicker navigation.
Less guessing, safer edits.
Want early access? Ping us and we’ll enable it.
October 8, 2025 at 12:30 PM
Branch settings, faster.
We reorganized the page and added search.
What changed
Search to jump directly to a setting.
Logical groups with clear labels.
Guardrails to reduce misclicks.
Why it helps
Quicker navigation.
Less guessing, safer edits.
Want early access? Ping us and we’ll enable it.
We reorganized the page and added search.
What changed
Search to jump directly to a setting.
Logical groups with clear labels.
Guardrails to reduce misclicks.
Why it helps
Quicker navigation.
Less guessing, safer edits.
Want early access? Ping us and we’ll enable it.
See write latency and replica lag before users do.
New performance charts surface:
WAL sync time → time to flush WAL to disk (disk/flush latency).
Replication lag → how far a standby is behind the primary (freshness).
Want early access? Ping us and we’ll switch it on for your account.
New performance charts surface:
WAL sync time → time to flush WAL to disk (disk/flush latency).
Replication lag → how far a standby is behind the primary (freshness).
Want early access? Ping us and we’ll switch it on for your account.
October 6, 2025 at 12:30 PM
See write latency and replica lag before users do.
New performance charts surface:
WAL sync time → time to flush WAL to disk (disk/flush latency).
Replication lag → how far a standby is behind the primary (freshness).
Want early access? Ping us and we’ll switch it on for your account.
New performance charts surface:
WAL sync time → time to flush WAL to disk (disk/flush latency).
Replication lag → how far a standby is behind the primary (freshness).
Want early access? Ping us and we’ll switch it on for your account.
Project-level default database now live in Xata.
Set one default and we point new connection strings, views, and child branches to it by default.
Fewer misroutes and accidental writes to secondary DBs; faster onboarding.
Set it in Project Settings → Default database.
You can override per branch.
Set one default and we point new connection strings, views, and child branches to it by default.
Fewer misroutes and accidental writes to secondary DBs; faster onboarding.
Set it in Project Settings → Default database.
You can override per branch.
October 4, 2025 at 5:39 AM
Project-level default database now live in Xata.
Set one default and we point new connection strings, views, and child branches to it by default.
Fewer misroutes and accidental writes to secondary DBs; faster onboarding.
Set it in Project Settings → Default database.
You can override per branch.
Set one default and we point new connection strings, views, and child branches to it by default.
Fewer misroutes and accidental writes to secondary DBs; faster onboarding.
Set it in Project Settings → Default database.
You can override per branch.
Create a Postgres branch in one screen.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
October 3, 2025 at 12:30 PM
Create a Postgres branch in one screen.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Getting paged at 3 a.m + database operations ≠ heroics.
At Berlin Postgres Meetup (Sep 23) we showed our open-source Xata Agent: Autonomously find slow queries, proposes safe fixes, runs on a schedule w/ approvals. As if you have a new database expert colleague.
Recap:
At Berlin Postgres Meetup (Sep 23) we showed our open-source Xata Agent: Autonomously find slow queries, proposes safe fixes, runs on a schedule w/ approvals. As if you have a new database expert colleague.
Recap:
Recap of Berlin Postgres Meetup on September 23rd 2025 by Divyendu Singh
Takeaways from the Sep 23, 2025 Berlin Postgres Meetup: how Xata Agent (open-source Postgres AI agent) helps manage PostgreSQL at scale, Q&A highlights, lessons.
xata.io
October 3, 2025 at 10:59 AM
Getting paged at 3 a.m + database operations ≠ heroics.
At Berlin Postgres Meetup (Sep 23) we showed our open-source Xata Agent: Autonomously find slow queries, proposes safe fixes, runs on a schedule w/ approvals. As if you have a new database expert colleague.
Recap:
At Berlin Postgres Meetup (Sep 23) we showed our open-source Xata Agent: Autonomously find slow queries, proposes safe fixes, runs on a schedule w/ approvals. As if you have a new database expert colleague.
Recap:
Preload extensions once, use them everywhere.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
October 2, 2025 at 1:15 PM
Preload extensions once, use them everywhere.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
PostgreSQL 18 is supported on Xata.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
September 30, 2025 at 5:15 PM
PostgreSQL 18 is supported on Xata.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Thinking about changing your data model?
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
September 26, 2025 at 2:05 PM
Thinking about changing your data model?
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
PostgreSQL 18 is here 🎉 🐘
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
September 25, 2025 at 5:49 PM
PostgreSQL 18 is here 🎉 🐘
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
Shipping Text to SQL you can trust isn’t just prompting.
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
September 24, 2025 at 12:28 PM
Shipping Text to SQL you can trust isn’t just prompting.
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
Just dropped: pgstream v0.8.2 🛠️
Now with hstore transformations, role-aware snapshots, and a cleaner CLI.
Built for Postgres devs doing CDC, replication, or analytics.
Check it out → xata.io/blog/pgstrea...
Open source & ready to use.
Now with hstore transformations, role-aware snapshots, and a cleaner CLI.
Built for Postgres devs doing CDC, replication, or analytics.
Check it out → xata.io/blog/pgstrea...
Open source & ready to use.
pgstream v0.8.2: hstore transformer, roles snapshotting, CLI improvements and more by Ahmet Gedemenli
Learn how pgstream v0.8.2 transforms hstore data and improves snapshot experience with roles snapshotting and excluded tables option
xata.io
September 23, 2025 at 12:31 PM
Just dropped: pgstream v0.8.2 🛠️
Now with hstore transformations, role-aware snapshots, and a cleaner CLI.
Built for Postgres devs doing CDC, replication, or analytics.
Check it out → xata.io/blog/pgstrea...
Open source & ready to use.
Now with hstore transformations, role-aware snapshots, and a cleaner CLI.
Built for Postgres devs doing CDC, replication, or analytics.
Check it out → xata.io/blog/pgstrea...
Open source & ready to use.
Can an AI agent handle your Postgres on-call?
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
PostgreSQL September Meetup, Tue, Sep 23, 2025, 6:30 PM | Meetup
We will be hosting our September Meetup. Thanks to Amazon for sponsoring us. Please note that you have to show sign up with your real name and show a Photo ID to the build
www.meetup.com
September 22, 2025 at 11:39 AM
Can an AI agent handle your Postgres on-call?
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
What if your Postgres cluster could hibernate when idle and wake instantly when needed?
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
September 20, 2025 at 5:39 AM
What if your Postgres cluster could hibernate when idle and wake instantly when needed?
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
Data exploration is easier with the ability to generate SQL from a simple question.
No need to worry about syntax.
Just dive into the data.
No need to worry about syntax.
Just dive into the data.
September 19, 2025 at 12:15 PM
Data exploration is easier with the ability to generate SQL from a simple question.
No need to worry about syntax.
Just dive into the data.
No need to worry about syntax.
Just dive into the data.
Branch metrics provide insight into CPU, memory, throughput, egress, and more.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
September 18, 2025 at 1:16 PM
Branch metrics provide insight into CPU, memory, throughput, egress, and more.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Have a branch you don’t need running all the time?
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
September 16, 2025 at 12:45 PM
Have a branch you don’t need running all the time?
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Our list of supported extensions is growing every day.
Got any requests?
Got any requests?
September 15, 2025 at 12:31 PM
Our list of supported extensions is growing every day.
Got any requests?
Got any requests?
🚀 Congrats to @apatheticmagpie.bsky.social for being named Woman of the Month by Postgres Women India! 🎉
She shares her Postgres journey, open-source work on pgroll and pgstream and her role in co-organizing the Postgres on Kubernetes and Postgres & AI Summits.
👉 postgreswomen.in/gulcin-yildi...
She shares her Postgres journey, open-source work on pgroll and pgstream and her role in co-organizing the Postgres on Kubernetes and Postgres & AI Summits.
👉 postgreswomen.in/gulcin-yildi...
Gulcin Yildirim Jelinek - Postgres Women India
Postgres Woman of the Month September 2025 – Gulcin Yildirim Jelinek Introduction: Hello, my name is Gülçin Yıldırım Jelínek. I work at Xata, a modern PostgreSQL platform focused on enabling realistic...
postgreswomen.in
September 15, 2025 at 11:44 AM
🚀 Congrats to @apatheticmagpie.bsky.social for being named Woman of the Month by Postgres Women India! 🎉
She shares her Postgres journey, open-source work on pgroll and pgstream and her role in co-organizing the Postgres on Kubernetes and Postgres & AI Summits.
👉 postgreswomen.in/gulcin-yildi...
She shares her Postgres journey, open-source work on pgroll and pgstream and her role in co-organizing the Postgres on Kubernetes and Postgres & AI Summits.
👉 postgreswomen.in/gulcin-yildi...
Xata @ PGDay UK 2025 🐘
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
September 13, 2025 at 5:39 AM
Xata @ PGDay UK 2025 🐘
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
You have full control over your branches directly from the console.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
September 11, 2025 at 1:33 PM
You have full control over your branches directly from the console.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Tomorrow at @pgdaylowlands.bsky.social 🐘, @apatheticmagpie.bsky.social speaks at 09:40 on "Anatomy of Table-level Locks in PostgreSQL."
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
September 11, 2025 at 9:05 AM
Tomorrow at @pgdaylowlands.bsky.social 🐘, @apatheticmagpie.bsky.social speaks at 09:40 on "Anatomy of Table-level Locks in PostgreSQL."
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
In Xata, every branch is a full Postgres instance.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
September 10, 2025 at 3:26 PM
In Xata, every branch is a full Postgres instance.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.