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
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.
None of its own.
Also accepts connection, instance, group, described once under arguments every tool takes.
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.
A physical replica is byte-identical here, so asking each member of a replication group adds nothing.
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "listCasts",
"arguments": {}
}
}
{
"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.
listRoles, listTablespaces, listEventTriggers, listLanguages, listAccessMethods, listExtensions