listPublications

read-onlyany connectionsweeps instancesweeps group

Synopsis

listPublications()

Description

Return logical replication publications with owner, all-tables flag, per-operation flags (insert/update/delete/truncate), table_count, up to 50 member table names, and on PostgreSQL 15+ the schemas published wholesale via FOR TABLES IN SCHEMA. That declaration is not cosmetic: a table created later in a published schema joins the publication by itself, while one added to a table-list publication does not -- so two publications with identical members today can behave differently tomorrow. tables_truncated says when a publication carries more than the names shown -- a publication FOR ALL TABLES resolves to every table in the database, so the member list is unbounded by construction and the count is the figure that scales.

Parameters

None of its own.

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

Output

Keyed by publication name; each value is its tables and replicated operations. 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": "listPublications",
    "arguments": {}
  }
}

Result

{
  "shop_cdc": {
    "owner": "migrator",
    "all_tables": false,
    "insert": true,
    "update": true,
    "delete": true,
    "truncate": false,
    "table_count": 2,
    "tables": [
      "shop.customers",
      "shop.orders"
    ],
    "tables_truncated": false,
    "schemas": []
  }
}

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.