mcp-snowflake-server

Instructions

Implementation Reference

• src/mcp_snowflake_server/server.py:258-265 (handler)

  The main handler function for the 'append_insight' tool. It validates the input arguments, adds the insight to the SnowflakeDB instance, sends a resource update notification for the memo, and returns a confirmation message.
  async def handle_append_insight(arguments, db, _, __, server, exclude_json_results=False): if not arguments or "insight" not in arguments: raise ValueError("Missing insight argument") db.add_insight(arguments["insight"]) await server.request_context.session.send_resource_updated(AnyUrl("memo://insights")) return [types.TextContent(type="text", text="Insight added to memo")]
• src/mcp_snowflake_server/server.py:445-460 (registration)

  Registration of the 'append_insight' tool in the all_tools list. Includes the tool name, description, input schema definition, handler reference, and tags.
  Tool( name="append_insight", description="Add a data insight to the memo", input_schema={ "type": "object", "properties": { "insight": { "type": "string", "description": "Data insight discovered from analysis", } }, "required": ["insight"], }, handler=handle_append_insight, tags=["resource_based"], ),
• src/mcp_snowflake_server/db_client.py:89-92 (helper)

  Helper method in the SnowflakeDB class that appends the provided insight string to the internal list of insights, which powers the memo resource.
  def add_insight(self, insight: str) -> None: """Add a new insight to the collection""" self.insights.append(insight)