Read one table's columns, types and primary key

curl --request GET \
  --url https://api.paigeme.dev/v1/tables/{table}/schema \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.paigeme.dev/v1/tables/{table}/schema', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "success": true,
  "data": {
    "table": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "name": "<string>",
        "type": "<string>",
        "nullable": true,
        "default_value": "<string>",
        "is_primary_key": true
      }
    ]
  }
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

GET

tables

{table}

schema

Read one table's columns, types and primary key

curl --request GET \
  --url https://api.paigeme.dev/v1/tables/{table}/schema \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.paigeme.dev/v1/tables/{table}/schema', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "success": true,
  "data": {
    "table": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "name": "<string>",
        "type": "<string>",
        "nullable": true,
        "default_value": "<string>",
        "is_primary_key": true
      }
    ]
  }
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

{
  "success": false,
  "error": {
    "code": "invalid_request",
    "message": "Invalid request body",
    "details": {}
  },
  "request_id": "<string>"
}

Authorizations

Authorization

string

header

required

Project API key issued in Settings → API keys. Send it as Authorization: Bearer pk_live_….

Headers

X-Paige-Project

string

Target project id, for an MCP OAuth bearer (mcp_at_…) attached to more than one project — get ids from GET /v1/projects. Matched case-insensitively.

Omit it and a READ falls back to the connection's default project; a mutation (any non-GET) on a connection with 2+ projects is rejected with 400 project_required — a write is never defaulted to a guessed project. A connection with exactly one project never needs the header.

Scopes are checked against the SELECTED project only, never a union across the connection.

For a pk_ API key the header selects nothing — one key is one project's context — but it IS validated: omit it and the key's own project is used, send it and it must name that project, otherwise the call is rejected with 403 project_not_attached (a blank value is 400 invalid_project_header, as above).

Path Parameters

table

string

required

Table name. Lowercase letters, digits and underscores only. Paige platform tables are rejected.

Pattern: ^[a-z_][a-z0-9_]{0,62}$

Query Parameters

schema

enum<string>

Which database schema to target: "public" (production, the default) or "preview" (dev sandbox).

Available options:

public,

preview

Response

Success.

success

enum<boolean>

required

Available options:

true

data

object

required

Hide child attributes

data.table

string

required

data.schema

string

required

data.columns

object[]

required

Hide child attributes

data.columns.name

string

required

Column name.

data.columns.type

string

required

Postgres data type, e.g. "text", "integer", "timestamp with time zone".

data.columns.nullable

boolean

required

Whether the column accepts NULL.

data.columns.default_value

string | null

required

Column default expression, or null.

data.columns.is_primary_key

boolean

required

Whether the column is part of the primary key.

Getting started

Endpoints

Read one table's columns, types and primary key

Authorizations

Headers

Path Parameters

Query Parameters

Response