Table Schema

https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/schema

This endpoint enables reading or updating the schema of a given table.

Expected Parameters

Name	Description	In	Required	Schema
`db_branch_name`	The DBBranchName matches the pattern `{db_name}:{branch_name}`.	path	✅	string
`table_name`	The Table name	path	✅	string

Get Table Schema

GET

https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/schema

Status Code	Description	Example Response/Type Definition
200	OK	`type GetTableSchema = { columns: Column[]; }; type Column = { name: string; type: "bool" \| "int" \| "float" \| "string" \| "text" \| "email" \| "multiple" \| "link" \| "object" \| "datetime"; link?: ColumnLink; notNull?: boolean; defaultValue?: string; unique?: boolean; columns?: Column[]; }; type ColumnLink = { table: string; };`
400	Bad Request	`type GetTableSchema = { id?: string; message: string; };`
401	Authentication Error	`{ "message": "invalid API key" }`
404	Example response	`type GetTableSchema = { id?: string; message: string; };`
5XX	Unexpected Error

Update Table Schema

PUT

https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/schema

Request Body Type Definition

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
type SetTableSchema = {
    columns: Column[];
};

type Column = {
    name: string;
    type: "bool" | "int" | "float" | "string" | "text" | "email" | "multiple" | "link" | "object" | "datetime";
    link?: ColumnLink;
    notNull?: boolean;
    defaultValue?: string;
    unique?: boolean;
    columns?: Column[];
};

type ColumnLink = {
    table: string;
};

Status Code	Description	Example Response/Type Definition
200	Schema migration response with ID and migration status.	`type SetTableSchema = { /* * @minLength 1 */ migrationID: string; parentMigrationID: string; status: MigrationStatus; }; type MigrationStatus = "completed" \| "pending" \| "failed";`
204	No Content
400	Bad Request	`type SetTableSchema = { id?: string; message: string; };`
401	Authentication Error	`{ "message": "invalid API key" }`
404	Example response	`type SetTableSchema = { id?: string; message: string; };`
409	Example response	`type SetTableSchema = { id?: string; message: string; };`
5XX	Unexpected Error