describe_table

Returns one table’s definition. Call it before reading or writing rows so values match the column types.


Scope	`mcp:read`
Annotations	`readOnlyHint: true`

Parameters

string

required

Project id from list_projects.

string

required

Table name.

Result

string

Table name.

object[]

Columns in table order. The first two are always the system columns id and created_at.

Show column

string

Column name.

string

One of text, integer, numeric, boolean, timestamptz, uuid, jsonb.

boolean

false when the column is NOT NULL. Omitted when the column is nullable.

string

now() or gen_random_uuid() when the column has a default. Omitted otherwise.

object[]

Foreign keys. Omitted when the table has none.

Show foreign key

string

The uuid column in this table.

string

The table it references.

"id"

Always id.

string

cascade, restrict, or set null. Omitted when none was given at creation, which behaves as restrict.

Example

Arguments

{ "projectId": "01k7m3x9q2v8d4h6n1r5t0w2yz", "table": "books" }

Result

{
  "data": {
    "table": "books",
    "columns": [
      { "name": "id", "type": "uuid", "nullable": false, "default": "gen_random_uuid()" },
      { "name": "created_at", "type": "timestamptz", "nullable": false, "default": "now()" },
      { "name": "title", "type": "text", "nullable": false },
      { "name": "author_id", "type": "uuid" },
      { "name": "finished", "type": "boolean" },
      { "name": "rating", "type": "integer" },
      { "name": "details", "type": "jsonb" }
    ],
    "foreignKeys": [
      { "column": "author_id", "refTable": "authors", "refColumn": "id", "onDelete": "set null" }
    ]
  }
}

Errors

Code	When
`ACCESS_DENIED`	The project doesn’t exist or you can’t access it
`VALIDATION`	The table doesn’t exist, or the name is invalid

Overview

Read tools

Write tools

Destructive tools

Parameters

Result

Example

Errors

​Parameters

​Result

​Example

​Errors

Parameters

Result

Example

Errors