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"],
  },