Snowflake MCP Server

Instructions

Implementation Reference

• src/mcp_snowflake_server/server.py:249-256 (handler)

  The core handler function that implements the append_insight tool logic. Validates input, adds insight to the database memo, notifies the session of resource update, and returns confirmation.
  async def handle_append_insight(arguments, db, _, __, server): 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:489-504 (registration)

  Tool registration object for append_insight, defining name, description, input schema, handler, and tags. Added to the all_tools list for dynamic tool listing and invocation.
  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/server.py:492-501 (schema)

  Input schema definition for the append_insight tool, specifying a required 'insight' string parameter.
  input_schema={ "type": "object", "properties": { "insight": { "type": "string", "description": "Data insight discovered from analysis", } }, "required": ["insight"], },