Redshift MCP Server

Instructions

Get sample rows from a table.

Args:
    table_name: Name of the table
    limit: Number of rows to return (default: 5)
    schema: Schema name (default: "public")

Returns:
    JSON sample data

Implementation Reference

• redshift_mcp_server.py:117-131 (handler)

  The main handler function for the 'redshift_get_sample_data' tool. It is decorated with @mcp.tool() which serves as both the implementation and registration in FastMCP. The function generates a SQL query to fetch a limited number of rows from the specified table and delegates execution to the 'redshift_query' tool, returning JSON results.

  @mcp.tool()
  def redshift_get_sample_data(table_name: str, limit: int = 5, schema: str = "public") -> str:
      """
      Get sample rows from a table.
      
      Args:
          table_name: Name of the table
          limit: Number of rows to return (default: 5)
          schema: Schema name (default: "public")
      
      Returns:
          JSON sample data
      """
      sql = f"SELECT * FROM {schema}.{table_name} LIMIT {limit}"
      return redshift_query(sql)