handle_inspect_table

Inspect and retrieve comprehensive details about a specific Redshift table, including design, storage, health, usage, and encoding, using concurrent script execution.

Instructions

Retrieves detailed information about a specific Redshift table.

Fetches table OID, then concurrently executes various inspection scripts
covering design, storage, health, usage, and encoding.

Args:
    ctx: The MCP context object.
    schema_name: The schema name of the table.
    table_name: The name of the table.

Returns:
    A dictionary where keys are script names and values are either the raw
    list of dictionary results from the SQL query, the extracted DDL string,
    or an Exception object if that specific script failed.
    - On success: Dictionary containing raw results or Exception objects for each script.
    - On table not found: Raises TableNotFound exception.
    - On critical errors (e.g., OID lookup failure): Raises DataApiError or similar.

Raises:
    DataApiError: If a critical error occurs during script execution.
    TableNotFound: If the specified table cannot be found via its OID.

Input Schema

Name	Required	Description	Default
`schema_name`	Yes
`table_name`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "schema_name": {
      "title": "Schema Name",
      "type": "string"
    },
    "table_name": {
      "title": "Table Name",
      "type": "string"
    }
  },
  "required": [
    "schema_name",
    "table_name"
  ],
  "title": "handle_inspect_tableArguments",
  "type": "object"
}

redshift-utils-mcp

handle_inspect_table

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from redshift-utils-mcp

Related Tools