listSequences

Return sequence list for a schema with type, range, increment, cycle, cache, current value, and owning table.column (for SERIAL/IDENTITY columns).

read-onlyany connectionsweeps instancesweeps group

Synopsis

listSequences(schema)

Description

Return sequence list for a schema with type, range, increment, cycle, cache, current value, and owning table.column (for SERIAL/IDENTITY columns).

Parameters

schema requiredstring

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

Output

Keyed by sequence name; each value is that sequence's range, increment and owning column. 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": "listSequences",
    "arguments": {
      "schema": "shop"
    }
  }
}

Result

{
  "invoice_no_seq": {
    "data_type": "bigint",
    "start": 100000,
    "increment": 1,
    "min": 1,
    "max": 9223372036854775807,
    "cycle": false,
    "owned_by": "shop.orders.invoice_no",
    "last_value": 482211
  }
}

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

listSchemas, listTables, tableDetails, tableStats, largeObjects, listPartitions, partitionDetails, listTableStats, tableSize, listTableSizes, listFunctions, functionDetails, listEnums, enumDetails, listTypes, typeDetails, columnHistogram, listExtendedStatistics