listAccessMethods

Return index and table access methods available in the cluster (btree, gist, gin, heap, etc) with type and handler function.

read-onlyany connectionsweeps instancesweeps group

Synopsis

listAccessMethods()

Description

Return index and table access methods available in the cluster (btree, gist, gin, heap, etc) with type and handler function.

Parameters

None of its own.

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

Output

Keyed by access method name; each value is its kind and handler. 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": "listAccessMethods",
    "arguments": {}
  }
}

Result

{
  "btree": {
    "type": "index",
    "handler": "bthandler",
    "description": "b-tree index access method"
  },
  "heap": {
    "type": "table",
    "handler": "heap_tableam_handler",
    "description": "heap table access method"
  }
}

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.