Excel MCP Server

"""Logging utility for MCP server and agent.""" import logging from pathlib import Path from typing import Optional from logging.handlers import RotatingFileHandler def setup_logger(name: str = "excel_mcp", log_file: Optional[str] = None, level: str = "INFO") -> logging.Logger: """ Set up a logger with both file and console handlers. Args: name: Logger name log_file: Path to log file (optional) level: Logging level (DEBUG, INFO, WARNING, ERROR) Returns: Configured logger instance """ logger = logging.getLogger(name) logger.setLevel(getattr(logging, level.upper(), logging.INFO)) # Clear existing handlers logger.handlers.clear() # Create formatter formatter = logging.Formatter( '%(asctime)s - %(name)s - %(levelname)s - %(message)s', datefmt='%Y-%m-%d %H:%M:%S' ) # Console handler console_handler = logging.StreamHandler() console_handler.setLevel(logging.INFO) console_handler.setFormatter(formatter) logger.addHandler(console_handler) # File handler (if log_file specified) if log_file: log_path = Path(log_file) log_path.parent.mkdir(parents=True, exist_ok=True) file_handler = RotatingFileHandler( log_file, maxBytes=10 * 1024 * 1024, # 10MB backupCount=5 ) file_handler.setLevel(logging.DEBUG) file_handler.setFormatter(formatter) logger.addHandler(file_handler) return logger