listExtensions

Return installed PostgreSQL extensions with version, schema, relocatable flag, and description.

read-onlyany connectionsweeps instancesweeps group

Synopsis

listExtensions()

Description

Return installed PostgreSQL extensions with version, schema, relocatable flag, and description.

Parameters

None of its own.

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

Output

Keyed by extension name; each value is its version and installation schema. 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": "listExtensions",
    "arguments": {}
  }
}

Result

{
  "pg_stat_statements": {
    "version": "1.11",
    "schema": "extensions",
    "relocatable": true,
    "description": "track planning and execution statistics of all SQL statements executed"
  },
  "hypopg": {
    "version": "1.4.1",
    "schema": "extensions",
    "relocatable": true,
    "description": "Hypothetical indexes for PostgreSQL"
  }
}

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.