Participate in our content hackathon before it ends on September 30th, for a chance to win incredible prizes!

Hero banner illustration

Serverless database platform
powered by PostgreSQL

Modern applications are complex. We make the data part easy with the functionality your application needs to evolve and scale.

Hero illustration

Trusted by thousands of developers at companies like

Focus on what matters most

Stop worrying about managing database infrastructure. In seconds you can have a fully managed and scalable database built on Postgres, the database that's trusted by millions of developers and businesses around the world. Get started with our generous free tier today and scale up or down as needed.

Vector searchFull text searchFile attachmentsBranchingPython SDKTypeScript SDKAPIsAdmin UIPostgreSQL

Support all of your data requirements

Features include a powerful, lightning-fast full-text search engine (powered by Elasticsearch), support for rich data types, and vector search capabilities. Easily create AI-enabled applications with ChatGPT embedded in your database. Xata automatically replicates all of your data from Postgres to additional data stores, so you don't have to.

// Typings and client automatically up to date
import { getXataClient } from "./xata";
const xata = getXataClient();
 
// Fuzzy-search with column weights
const records = await xata.search.all("next.js", {
  tables: [
    {
      table: "posts",
      target: [
        { column: "content", weight: 2 },
        { column: "title", weight: 5 },
      ],
    },
  ],
  fuzziness: 2,
  prefix: "phrase",
});

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.

Is Xata right for my use case?

Xata uses the best tools for the job, extending your Postgres database to support more use cases. Here are some popular use cases among our customers.

AI applications

With a dedicated rich type for embeddings, built-in vector similarity search and a native OpenAI integration, Xata makes it very easy to add AI capabilities to your app.

Learn More

Web apps

Whether you write your web app in Python, TypeScript, or JavaScript, you’ll enjoy the best database developer experience. It also comes with built-in support images and attachments.

Learn More

Search

Data from Postgres is automatically replicated to Elasticsearch, the world’s most advanced search engine. The Xata search API makes it very easy to fine tune your app search.

Learn More

Serverless apps

The Data API, the edge-ready TypeScript SDK, the Vercel, Netlify, and CloudFlare integrations make Xata a pleasure to use together with any serverless platform.

Learn More
Database illustration

No servers, no ops, no stress

  • Auto-scaling up and down
  • Zero cold-starts
  • High availability

In seconds, spin up a Postgres database that is ready to scale up (or down) with your workload. With high availability, redundancy and edge caching, the only thing you have to worry about is your application code.

Start free

Latest from our blog

Subscribe to our blog

Join our community of subscribers to stay up to date with the latest news, tips and thought leadership, delivered directly to your inbox.