Users

Get user details

get

Update user info

put

Delete user

delete

Authentication

Get the list of user API keys

get

Create and return new API key

post

Delete an existing API key

delete

OAuth

Get the list of user OAuth Clients

get

Delete the oauth client for the user

delete

Get the list of user OAuth Access Tokens

get

delete an access token for a third party app

delete

updates an access token for a third party app

patch

Workspaces

Get list of workspaces

get

Create a new workspace

post

Get an existing workspace

get

Update an existing workspace

put

Delete an existing workspace

delete

Get workspace settings

get

Update workspace settings

patch

Get the list members of a workspace

get

Update workspace member role

put

Remove a member from the workspace

delete

Invites

Invite a user to join the workspace

post

Updates an existing invite

patch

Deletes an invite

delete

Accept the invitation to join a workspace

post

Resend Invite notification

post

Databases

List databases

get

Create Database

put

Delete Database

delete

Get Database metadata

get

Update Database metadata

patch

Rename Database

post

List available regions

get

Tasks

Get all tasks

get

Get task status

get

Branch

List branches

get

Create database branch

put

Get branch schema and metadata

get

Create Database branch

put

Delete Database branch

delete

Get branch move status

get

Move the branch to a different cluster

put

Update branch metadata

put

Get Branch Metadata

get

Branch stats

get

List git branches mapping

get

Link a git branch to a Xata branch

post

Unlink a git branch to a Xata branch

delete

Resolve a Git Branch to a Xata branch

get

Database

Database settings

get

Update database settings

patch

Migrations

Get branch migration history [deprecated]

get

Compute migration plan [deprecated]

post

Migrate branch [deprecated]

post

Query schema history.

post

Compare branch with user schema.

post

Compare branch schemas.

post

Update Branch schema

post

Preview branch schema edits.

post

Apply edit script.

post

Push migrations.

post

Table

Create table

put

Delete table

delete

Update table

patch

Get table schema

get

Update table schema

put

List table columns

get

Create new column

post

Get column information

get

Update column

patch

Delete column

delete

Records

Execute a transaction on a branch

post

Insert record

post

Get record by ID

get

Insert record with ID

put

Update record with ID

patch

Upsert record with ID

post

Delete record from table

delete

Bulk insert records

post

Files

Download content from a file item in a file array column

get

Upload or update the content of a file item in a file array column

put

Delete an item from a file array

delete

Download content from a file column

get

Upload content to a file column

put

Remove the content from a file column

delete

Search and Filter

Query table

post

Free text search

post

Free text search in a table

post

Vector similarity search in a table

post

Ask your table a question

post

Continue a conversation with your data

post

Summarize table

post

Run aggregations over a table

post

SQL

SQL query

post

Batch SQL queries

post

Available regions

https://api.xata.io/workspaces/workspace_id/regions

This path allows to access the list of available database regions

Expected parameters

NameDescriptionInRequiredSchema
workspace_id

Workspace ID

path✅string

List Available Regions

GET
https://api.xata.io/workspaces/workspace_id/regions

List regions available to create a database on

Responses