Redshift MCP Server

Instructions

Get the column definitions for a table.

Args:
    table_name: Name of the table
    schema: Schema name (default: "public")

Returns:
    JSON description of columns

Implementation Reference

• redshift_mcp_server.py:96-115 (handler)

  The handler function for the 'redshift_describe_table' tool. It is registered via the @mcp.tool() decorator and executes a SQL query against information_schema.columns to describe the table structure, returning JSON via redshift_query.

  @mcp.tool()
  def redshift_describe_table(table_name: str, schema: str = "public") -> str:
      """
      Get the column definitions for a table.
      
      Args:
          table_name: Name of the table
          schema: Schema name (default: "public")
      
      Returns:
          JSON description of columns
      """
      sql = f"""
      SELECT column_name, data_type, is_nullable, column_default
      FROM information_schema.columns
      WHERE table_schema = '{schema}'
      AND table_name = '{table_name}'
      ORDER BY ordinal_position
      """
      return redshift_query(sql)