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)