Xata - Postgres at Scale
@xata.io
With copy-on-write branching, data masking, separated storage & compute , 100% Postgres
Finally, AI won’t replace DBAs, it scales them.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
October 21, 2025 at 1:38 PM
Finally, AI won’t replace DBAs, it scales them.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
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.
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.
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-...
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?
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.
Now live: AWS Frankfurt (eu-central-1)
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
September 5, 2025 at 8:54 AM
Now live: AWS Frankfurt (eu-central-1)
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
If you want to understand Postgres locks beyond the basics, this talk is for you.
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
September 4, 2025 at 8:48 AM
If you want to understand Postgres locks beyond the basics, this talk is for you.
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
If you’re at PGDay Austria today, don’t miss @apatheticmagpie.bsky.social ’s talk:
“Anatomy of Table-Level Locks in PostgreSQL” 🔒
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
“Anatomy of Table-Level Locks in PostgreSQL” 🔒
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
September 4, 2025 at 8:45 AM
If you’re at PGDay Austria today, don’t miss @apatheticmagpie.bsky.social ’s talk:
“Anatomy of Table-Level Locks in PostgreSQL” 🔒
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
“Anatomy of Table-Level Locks in PostgreSQL” 🔒
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
🚨 The Malmö Postgres User Group meetup returns on Aug 19!
Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG.
🔗 Details and RSVP: tinyurl.com/ytkwvsst
Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!
Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG.
🔗 Details and RSVP: tinyurl.com/ytkwvsst
Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!
August 6, 2025 at 11:14 AM
🚨 The Malmö Postgres User Group meetup returns on Aug 19!
Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG.
🔗 Details and RSVP: tinyurl.com/ytkwvsst
Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!
Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG.
🔗 Details and RSVP: tinyurl.com/ytkwvsst
Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!
The summer edition of the London Postgres Meetup is behind us!
Thanks to the organisers for a great evening.
Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes.
Always a joy to talk Postgres over pints!
Thanks to the organisers for a great evening.
Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes.
Always a joy to talk Postgres over pints!
July 31, 2025 at 2:52 PM
The summer edition of the London Postgres Meetup is behind us!
Thanks to the organisers for a great evening.
Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes.
Always a joy to talk Postgres over pints!
Thanks to the organisers for a great evening.
Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes.
Always a joy to talk Postgres over pints!
We wanted to see how our Postgres service ranks among the others on the @planetscale.com benchmarks.
The blog post reviews in detail the benchmarking methodology, relevancy, fairness, and openness.
xata.io/blog/reactio...
The blog post reviews in detail the benchmarking methodology, relevancy, fairness, and openness.
xata.io/blog/reactio...
July 16, 2025 at 6:29 PM
We wanted to see how our Postgres service ranks among the others on the @planetscale.com benchmarks.
The blog post reviews in detail the benchmarking methodology, relevancy, fairness, and openness.
xata.io/blog/reactio...
The blog post reviews in detail the benchmarking methodology, relevancy, fairness, and openness.
xata.io/blog/reactio...
We kicked off the day at @berlinbuzzwords.de with a rooftop breakfast for the amazing women speakers.
As a proudly female-founded Postgres company, we’re thrilled to support moments like this. 💜
Don’t miss @apatheticmagpie.bsky.social talk at 15:20 (Maschinenhaus room)!
As a proudly female-founded Postgres company, we’re thrilled to support moments like this. 💜
Don’t miss @apatheticmagpie.bsky.social talk at 15:20 (Maschinenhaus room)!
June 16, 2025 at 11:15 AM
We kicked off the day at @berlinbuzzwords.de with a rooftop breakfast for the amazing women speakers.
As a proudly female-founded Postgres company, we’re thrilled to support moments like this. 💜
Don’t miss @apatheticmagpie.bsky.social talk at 15:20 (Maschinenhaus room)!
As a proudly female-founded Postgres company, we’re thrilled to support moments like this. 💜
Don’t miss @apatheticmagpie.bsky.social talk at 15:20 (Maschinenhaus room)!