What does the server do?
It reads an Excel workbook containing employee leave records and exposes MCP tools that allow an AI assistant (e.g., Claude) to answer questions about leave status, balances, and history.
@ItsMistahJi
基本信息
This is my attempt at creating a leave management mcp server to retrieve details of employees stored in a workbook.
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"itsmistahji-leave-management-mcp": {
"command": "uv",
"args": [
"init",
"."
]
}
}
}工具列表暂未提供
当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
The Leave Management MCP Server is a Model Context Protocol server for managing employee leave within an organization. It integrates with Excel workbooks containing employee leave data and provides tools for querying and analyzing leave records, designed for use with MCP clients like Claude Desktop.
Install dependences via UV, configure a .env file pointing to your Excel workbook, then run the server locally with uv run python -m src.leave_server or install it into an MCP client using uv run mcp install src/leave_server.py --name "Leave Management". For VS Code, add the provided JSON configuration to your settings.
It reads an Excel workbook containing employee leave records and exposes MCP tools that allow an AI assistant (e.g., Claude) to answer questions about leave status, balances, and history.
Python 3.9+, the UV package manager, an MCP client (e.g., Claude Desktop), and an Excel workbook with leave data structured with columns for employee details and monthly leave marks.
The data lives in an Excel workbook (e.g., `leave_tracker.xlsx`) located in a directory specified by the `DATA_DIR` environment variable. The server expects a sheet named "Leaves-2025" with specific columns.
Ensure `__init__.py` files exist in `src/` and `src/models/`, add a sys.path modification, or use the provided `main.py` wrapper in the root directory.
Install all dependencies in the same environment using `uv add pandas openpyxl python-dotenv PyPDF2` or use the `--with` flag when running the server.

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one
Hindsight: Agent Memory That Learns
A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!
AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
评论