xata.io

# Xata

> Postgres by the thousands. Spin up tens of thousands of writable Postgres copies with real data, for the price of one.

Xata is the managed Postgres platform for agent-driven development, testing, and training. Database demand scales with machine activity, not headcount. The Xata architecture decouples copy-count from cost — every agent, CI job, and simulation gets its own real database.

## How It Works

- **Instant Postgres copies** — Branch a live database or spawn from a snapshot. Copies use compute only when active (scale to zero) and storage only for diffs (copy-on-write). No per-copy fees.
- **Works with existing Postgres** — Replicate from RDS, Aurora, Cloud SQL, or self-hosted. Or run your primary on Xata.
- **Vanilla Postgres** — Standard PostgreSQL, not a fork. Every Postgres tool works. Any cloud.
- **Built-in PII anonymization** — Lightweight filters to HIPAA-grade microaggregation on every branch.
- **Open-source core** — Core branching engine is open source. No vendor lock-in. pg_dump and go.

## Platform Features

- [Postgres Branching](https://xata.io/postgres-branching)
- [Realistic Staging Environments](https://xata.io/realistic-staging-dev)
- [Postgres Data Masking](https://xata.io/postgres-data-masking)
- [Postgres Schema Changes](https://xata.io/postgres-schema-changes)
- [Database Agent](https://xata.io/database-agent)
- [Postgres Performance](https://xata.io/postgres-performance)
- [Postgres Storage](https://xata.io/postgres-storage)
- [Postgres Analytics](https://xata.io/postgres-analytics)
- [Postgres for Platforms](https://xata.io/postgres-for-platforms)
- [Bring Your Own Cloud (BYOC)](https://xata.io/byoc)

## Agent Resources

- [Database Infrastructure Glossary](https://xata.io/glossary) — 258 database terms across 26 categories. HTML page with search and filtering.
- [Glossary Agent Context File (.md)](https://xata.io/glossary/database-glossary-agent.md) — Flat markdown, optimized for LLM context windows and agent skills.
- [Glossary Agent Context File (.txt)](https://xata.io/glossary/database-glossary-agent.txt) — Plain text version of the glossary.
- [Xata Claude Skill](https://xata.io/xata-claude-skill/SKILL.md) — Claude Code skill for creating isolated database branches.
- [Full glossary + platform context (llms-full.txt)](https://xata.io/llms-full.txt) — Complete glossary content inline, no additional fetches needed.

## Open Source Projects

- [pgroll](https://github.com/xataio/pgroll) — Zero-downtime PostgreSQL schema migrations via expand/contract pattern.
- [pgstream](https://github.com/xataio/pgstream) — PostgreSQL CDC and streaming replication.
- [pgzx](https://github.com/xataio/pgzx) — Build PostgreSQL extensions in Zig.

## Documentation
- [Quickstart](https://xata.io/docs/quickstart)
- [CLI Reference](https://xata.io/docs/cli)
- [API Keys](https://xata.io/docs/platform/api-key)

- [Xata Documentation](https://xata.io/docs)

## Company

- [About Xata](https://xata.io/about)
- [Xata vs Neon](https://xata.io/versus-neon)
- [Pricing](https://xata.io/pricing)
- [Get Access](https://xata.io/get-access)
- [Blog](https://xata.io/blog)

## Version

Last updated: February 2026