listCasts

Return type casts involving at least one user-defined type (excludes built-in-to-built-in casts) with source/target types, context (implicit/assignment/explicit), and method.

read-onlyany connectionsweeps instancesweeps group

Synopsis

listCasts()

Description

Return type casts involving at least one user-defined type (excludes built-in-to-built-in casts) with source/target types, context (implicit/assignment/explicit), and method.

Parameters

None of its own.

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

Output

Keyed by source->target type pair; each value is that cast's function and context. 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": "listCasts",
    "arguments": {}
  }
}

Result

{
  "money_amount->numeric": {
    "source": "money_amount",
    "target": "numeric",
    "context": "implicit",
    "method": "binary",
    "function": null
  }
}

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.

See also

listRoles, listTablespaces, listEventTriggers, listLanguages, listAccessMethods, listExtensions