Package edu.internet2.middleware.grouper.ws.mcp

Class GrouperMcpSqlGetSchema

java.lang.Object
edu.internet2.middleware.grouper.ws.mcp.GrouperMcpSqlGetSchema
public class GrouperMcpSqlGetSchema extends Object
MCP tool handler for retrieving database schema (DDL) information. Supports three actions:
  • listExternalSystems - list available external system IDs
  • listTables - list table/view names for an external system
  • tableInfo - get DDL or column metadata for a specific table
For the Grouper database ("grouper"), built-in DDL provides base schema; extra tables/views from config are additive. For other external systems, the table list comes entirely from the per-system config.

  • Constructor Details

    • GrouperMcpSqlGetSchema

      public GrouperMcpSqlGetSchema()

  • Method Details

    • toolDefinition

      public static com.fasterxml.jackson.databind.node.ObjectNode toolDefinition()
      return the MCP tool definition for sql_get_schema
      Returns:
      the tool definition as a Jackson ObjectNode

    • execute

      public static com.fasterxml.jackson.databind.node.ObjectNode execute(com.fasterxml.jackson.databind.JsonNode arguments, GrouperMcpAuthUser authUser)
      execute the sql_get_schema tool
      Parameters:
      arguments - the tool arguments from the MCP request
      authUser - the authenticated user
      Returns:
      the MCP tool result