Realistic data
In order to catch bugs before they hit production, it's important to test with a realistic data set. Seeded or generated data is often not enough.
Use real data
in dev workflows
Get instant copy-on-write branches from your production PostgreSQL, without relocating your database. Works with any cloud provider.
PII detection and data anonymization
Removing sensitive data from your staging/testing dataset is important for privacy and security. Automate removing PII and sensitive data when syncing data from production.
A database branch for each PR
Spin up a Copy-on-Write PostgreSQL branch for each pull request, with anonymized data. Create preview environments to test your changes and new features.
Optimize database performance
Test performance improvements on instant database branches with the full dataset from production. Test new indexes and query patterns before they hit production.
Speed up development
When many developers are working on the same staging database, they have to wait for each other. With Xata, you can spin up a copy-on-write branch for each developer, and they can work in isolation.
Manage complex database changes
Test your schema changes in your dev and staging environments, create a pgroll plan, then apply to production with guaranteed zero-downtime.
Move fast without breaking production
Adopt Xata for dev and testing without changing, migrating, or relocating your production database.
01
Connect to your production database
Keep your production database where it is, whether it is AWS RDS, Aurora, GCP Cloud SQL, Azure Database, or even self-hosted.
02
Anonymize PII or other sensitive data
Mask sensitive data using configurable transformers that maintain referential integrity.
Learn more03
Clone the production database
Get a nightly synced clone of production with sensitive data removed. Ready for testing.
04
Instant dev branches
From the production clone, instantly create copy-on-write branches for each pull request to accelerate development, testing, and collaboration.
Learn more05
Deploy to production without downtime
Apply database changes confidently with pgroll, serving old and new schema versions in parallel for smooth, lock-free migrations.
Learn moreWhy real data workflows matter
Dev workflows only help if they feel like prod. Without real patterns and instant branches, teams slow down and bugs slip through.
The challenges you're facing
- Developer bottlenecks while waiting for "staging".
- Tiny datasets hide real bugs.
- Staging copies risk exposing PII.
- "Schema changes feel risky."
How Xata solves them
- Instant dev branches. Spin up isolated DB branches per PR.
- Production-like test data. Seed rich, realistic datasets.
- Privacy by design. Automatic PII anonymization.
- Zero-downtime migrations. Ship schema changes safely.
Simplify your schema changes workflow
You can use the Xata CLI to easily create and switch database branches during development and to integrate Xata into your CI/CD.
Use our cloud, or bring your own
Option 01
Xata Cloud
The easiest option to get started with.
- PII and sensitive data stripped before it leaves your account
- SOC 2 and HIPAA compliant
Option 02
Bring your own cloud (BYOC)
A fully managed Xata service for large-scale deployments, running in your own cloud account.
- Deployed in your AWS, Azure or GCP account
- Best for security and compliance
Frequently Asked Questions
Find answers to common questions about Xata