Staging and dev for PostgreSQL
Get instant Copy-on-Write branches with anonymized data for any PostgreSQL cloud provider. Works with AWS RDS, Amazon Aurora, Google Cloud SQL, and more.
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.
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.
Data branches 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
Get instant Copy-on-Write branches, anonymized data, and zero-downtime schema changes for any PostgreSQL cloud provider.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.
Anonymize PII or other sensitive data
Mask sensitive data using configurable transformers that maintain referential integrity.
Learn moreStaging replica with realistic data
Get a nightly synced replica of production with sensitive data removed. Ready for testing.
Instant dev branches
From the staging environment, instantly create Copy-on-Write branches for each pull request to accelerate development, testing, and collaboration.
Learn moreDeploy 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 you need realistic staging and testing environments
You set up staging and testing environments for your infrastructure, and perhaps you use preview environments for your team's pull requests. However, without realistic data and fast branches, these environments fall short.
The challenges you're facing
Developer bottlenecks. Waiting for "staging" to be available.
Staging data doesn’t reflect production data well enough. Testing with a much smaller dataset leads to missed bugs.
Staging database contains PII. Exposing sensitive information in testing environments.
“Database changes are scary.” Schema migrations and updates can cause downtime or data loss.
How Xata solves them
Instant development branches. Spin up isolated branches for testing and development without impacting production.
Accurate production-like data. Generate realistic datasets that mirror production for reliable testing.
Data privacy by design. Automatically anonymize sensitive data to ensure compliance and protect user privacy.
Zero-downtime migrations. Safely apply schema changes without disrupting your application or users.
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
Bring your own Cloud (BYOC) A fully managed Xata service for large-scale deployments deployed in your own AWS, Azure or GCP account. Best for security and compliance.
Xata cloud PII and sensitive data is stripped before it leaves your account. Easiest option to get started with, the Xata Cloud is SOC-2 and HIPAA compliant.
Frequently Asked Questions
Find answers to common questions about Xata