mcp-server-spreadsheet

Instructions

Implementation Reference

• src/mcp_server_spreadsheet/server.py:41-55 (handler)

  Implementation of the list_workbooks tool which scans a directory for supported spreadsheet files.

  def list_workbooks(
      directory: Annotated[str, Field(description="Absolute or relative path to the directory to scan")],
  ) -> list[str]:
      """List all spreadsheet files (.xlsx, .csv, .ods) in a directory (non-recursive).
  
      Returns the full path of each file found, sorted alphabetically.
      """
      d = Path(directory)
      if not d.is_dir():
          raise ValueError(f"Not a directory: {directory}")
      return sorted(
          str(f)
          for f in d.iterdir()
          if f.suffix.lower() in SUPPORTED_EXTENSIONS and f.is_file()
      )