listTypes

Return composite type, domain, and range type list for a schema (excludes enums and implicit table/view row types); composites include their attribute list, domains include base type/nullability/default/constraints, ranges include subtype and the auto-generated multirange type…

read-onlyany connectionsweeps instancesweeps group

Synopsis

listTypes(schema)

Description

Parameters

schema requiredstring

Also accepts connection, instance, group, described once under arguments every tool takes.

Output

Keyed by type name; each value is that composite, domain or range type. An absent extension or a missing grant is reported as {error, hint} in place of the map.

Scope

A physical replica is byte-identical here, so asking each member of a replication group adds nothing.

Example mocked data

Request

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "listTypes",
    "arguments": {
      "schema": "shop"
    }
  }
}

Result

{
  "money_amount": {
    "kind": "domain",
    "description": "Non-negative amount with two decimals.",
    "base_type": "numeric(12,2)",
    "not_null": true,
    "default": null,
    "constraints": [
      "CHECK (VALUE >= 0)"
    ]
  },
  "address": {
    "kind": "composite",
    "description": null,
    "attributes": {
      "street": "text",
      "city": "text",
      "postcode": "text"
    }
  }
}

Invented values on a fictional shop database, shaped by and checked against this tool's output schema. Real output is returned as structuredContent to clients that negotiate MCP 2025-06-18 or later.