Branch your database
just like your code

Create a copy of your database for local development, testing or staging environments, then merge into production with zero downtime.

Start free
Branching hero image

Version control

Create a branch with every pull request for local development and faster collaboration.

Learn More

Testing environments

Have a branch in every stage of your development lifecycle. From QA to staging to production.

Learn More

Preview deployments supported

Pair with your preview deployments in Vercel and Netlify.

Learn More

CI/CD pipeline

Plug into your existing CI/CD pipeline to reduce operational overhead and minimize risk.

Learn More

Keep doing what works best for your team

A complete end-to-end workflow for preview deployments

1

Branch

Branch your database like your code. Run xata branch from our CLI then xata pull and xata push to start collaborating with your team.

Hey team. I'm making a feature branch so we can collaborate.

Create branches in the CLI
# Create a branch in code or the UI
xata branch create my-changes

# Made changes in the UI? Pull them down
xata pull my-changes

# Made changes in the code? Push them up
xata push my-changes
xata pullCLIupdated TS Types in src/xata.ts
xata pullCLIcreated new migration files in .xata/migrations
2

Create a PR

Create a PR like normal in GitHub. Xata keeps track of your schema changes in the background and will create a comment with your schema and status in the PR.

I made some changes to the Xata schema in the UI. Time to run xata pull my-changes to get back Types! Now I'll commit the generated migration files into a PR along with my app code.

Alexis

committed add desc column into my-changes just now
.xata/migrations/mig_cgi6o.json
"addColumn": {
  "column": {
    "name": "description",
    "type": "string"
  },
  "table": "Posts"
}

Xata

botnoticed a migration on GitHub. Creating a preview branch for this PR.
3

Preview

Vercel and Netlify integrations generate a preview branch with your PR and deployment preview, eliminating the need for separate dev and staging environments.

Xata

bot

commented 3 minutes ago on GitHub

Preview branches created for your PR. Learn more about Xata for GitHub.

DatabaseStatePreview
preview-my-changes✅ Ready

View on Xata

The pull request creates a cloned Xata database with data. Feel free to mess around, it won't affect production data. The Vercel preview build automatically points to the linked Xata database. 🎉

Vercel

bot

commented 3 minutes ago on GitHub

The latest updates on your project. Learn more about Vercel for GitHub.

NameStatePreview
my-website✅ Ready

View on Xata

4

Merge

Merge your pull request as usual. Our system will run checks, perform a zero-downtime migration, and close any open branches, automatically.

Alexis

merged commit 3daa381 into main just now

Xata

botnoticed a merge. Deleting branch preview-my-changes

Xata

botnoticed a merge. Merging branch my-changes to main

Merged the pull request. Xata automatically merged the database changes to the main branch with zero downtime.

Explore more resources

Need a workflow cover image

End-to-end preview deployment workflows with Xata and Vercel

By Alex Francoeur

April 26, 2023

Preview deployments have changed the way we work. Xata's integration with Vercel brings the data layer directly into that workflow.

Need a workflow cover image

Modern database workflows with GitHub, Vercel, Netlify, and Xata

By Alex Francoeur

April 26, 2023

Finally, a database with a complete end-to-end developer workflow.

Xata

Branching brings predictability to web development

By Anjalee Sudasinghe

March 21, 2022

Explore the advantages of branching in developer workflows and how Xata brings these benefits to data infrastructure.

Learn by example

Try out a sample app

Built with Next.js, Chakra UI, and Xata, the sample app will help you learn how to query, paginate and search records with a heavy focus on file attachments.

View source on GitHub
Add column to table

Start free,
pay as you grow

Xata provides the best free plan in the industry. It is production ready by default and doesn't pause or cool-down. Take your time to build your business and upgrade when you're ready to scale.

Free plan includes
  • 10 database branches
  • High availability
  • 15 GB data storage
  • 15 GB search engine storage
  • 2 GB file attachments
  • 250 AI queries per month
Start freeExplore all plans
Free plan includes
  • 10 database branches
  • High availability
  • 15 GB data storage
  • 15 GB search engine storage
  • 2 GB file attachments
  • 250 AI queries per month
Add column to table

Copyright © 2024 Xatabase Inc.
All rights reserved.

Product

RoadmapFeature requestsPricingStatusAI solutionsFile attachments