Xata Documentation
Xata is a modern PostgreSQL platform designed for developers who want to build faster and ship with confidence. Our platform is built to support your production use cases as well as staging environments and developer workflows with features like instant branching, zero-downtime schema changes, and built-in data anonymization.
Here's a quick introductary video to learn more:
Why Xata?
| Feature | Description | Benefit | Learn More |
|---|---|---|---|
| 🚀 Instant Branching | Create database branches in seconds, not minutes | Develop and test with production-like data safely | Branching Guide → |
| ⚡ Zero-Downtime Schema Changes | Modify your database schema without service interruption | Deploy schema changes with confidence | Schema Changes → |
| 🔒 Built-in Data Anonymization | Automatically anonymize sensitive data for development | Use real data safely in non-production environments | Anonymization → |
| 🏗️ Deployment Flexibility | Choose between SaaS or bring-your-own-cloud (BYOC) | Deploy where you need - managed service or your infrastructure | Deployment → |
Interested in how we compare against other Postgres solutions out there? Check out this comparison blog series for more details.
Get Started
Get up and running with Xata in minutes:
- Create your first project - Set up a Xata account and create your first database
- Choose your framework - Connect your favorite language or framework
Popular Quickstarts
| Framework/ORM | Quickstart | Description |
|---|---|---|
| Next.js | Get Started → | Full-stack React applications |
| Drizzle | Get Started → | TypeScript ORM with type safety |
| SQLAlchemy | Get Started → | Python SQL toolkit and ORM |
| Django | Get Started → | Python web framework |
Tutorials & Guides
| Tutorial | Description |
|---|---|
| Set up staging replica | Create a staging environment with production data |
| Migrate to Xata | Move your existing database to Xata |
| Schema changes workflow | Learn best practices for schema evolution |
Migration Guides
Migrate your existing PostgreSQL databases to Xata using xata clone:
| Provider | Migration Guide | Description |
|---|---|---|
| AWS RDS & Aurora | Migrate → | Amazon's managed PostgreSQL services |
| GCP Cloud SQL | Migrate → | Google Cloud's managed PostgreSQL |
| Azure Database | Migrate → | Microsoft's managed PostgreSQL service |
| Neon | Migrate → | Serverless PostgreSQL with branching |
| Supabase | Migrate → | Open source Firebase alternative |
Tools & Integrations
Command Line Interface
Manage your Xata databases directly from the terminal:
# Install Xata CLI
npm install -g @xata.io/cli
# Authenticate and initialize
xata auth
xata init
# Create and manage branches
xata branch create feature-branch
xata branch checkout mainAutomation & CI/CD
Integrate Xata into your development workflow:
- GitHub Actions - Create database branches for pull requests
- Kubernetes - Deploy with container orchestration
View all automation workflows →
REST API
Programmatically manage your Xata resources:
- Organizations - Manage teams and access
- Projects - Create and configure databases
- Branches - Branch management operations
- Metrics - Performance and usage analytics
Get Help
- Discord Community - Join 10,000+ developers
- GitHub Discussions - Ask questions and share solutions
- Status Page - Check service status
- Support - Enterprise support and consulting
Built with ❤️ by the Xata team