listForeignTables

Return foreign tables in a schema with their foreign server, FDW, options, and columns (does not expose user mapping credentials).

read-onlyany connectionsweeps instancesweeps group

Synopsis

listForeignTables(schema)

Description

Return foreign tables in a schema with their foreign server, FDW, options, and columns (does not expose user mapping credentials).

Parameters

schema requiredstring

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

Output

Keyed by foreign table name; each value is its server and column list. 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": "listForeignTables",
    "arguments": {
      "schema": "shop"
    }
  }
}

Result

{
  "legacy_invoices": {
    "description": "Invoices still held in the old ERP.",
    "server": "erp",
    "fdw": "postgres_fdw",
    "options": [
      "schema_name=billing",
      "table_name=invoices"
    ],
    "columns": [
      "id",
      "order_ref",
      "amount"
    ]
  }
}

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.