listCollations

Return collations usable in the current database's encoding for a schema, with provider, locale settings, and determinism flag.

read-onlyany connectionsweeps instancesweeps group

Synopsis

listCollations(schema)

Description

Return collations usable in the current database's encoding for a schema, with provider, locale settings, and determinism flag.

Parameters

schema requiredstring

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

Output

Keyed by collation name; each value is its provider, ctype and determinism. 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": "listCollations",
    "arguments": {
      "schema": "shop"
    }
  }
}

Result

{
  "case_insensitive": {
    "provider": "icu",
    "collate": "und-u-ks-level2",
    "ctype": "und-u-ks-level2",
    "deterministic": false,
    "description": "Case-insensitive comparisons for emails."
  }
}

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

listOperators, listOperatorClasses, listTextSearchConfigs