MCP.so
登录

Leave Management MCP Server

@ItsMistahJi

代码仓库

关于 Leave Management MCP Server

This is my attempt at creating a leave management mcp server to retrieve details of employees stored in a workbook.

#leave-management#mcp#employee-management

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

ItsMistahJi

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "itsmistahji-leave-management-mcp": {
      "command": "uv",
      "args": [
        "init",
        "."
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Leave Management MCP Server?

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.

How to use Leave Management MCP Server?

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.

Key features of Leave Management MCP Server

  • Integrates with Excel workbooks for leave data storage
  • Enables natural-language queries about employee leave
  • Supports queries by employee name, ID, month, or date
  • Built with Python and uses Pandas for data processing
  • Can be run locally or installed in MCP clients

Use cases of Leave Management MCP Server

  • Ask who is on leave today and get instant answers
  • Check leave balance for a specific employee by ID
  • List all employees on leave in a given month
  • Retrieve leave details for a named employee
  • Query when a particular employee took leave in a specific period

FAQ from Leave Management MCP Server

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.

What are the prerequisites?

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.

Where is the leave data stored?

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.

How do I handle "No module named 'src'" errors?

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.

How do I resolve "No module named 'pandas'" errors?

Install all dependencies in the same environment using uv add pandas openpyxl python-dotenv PyPDF2 or use the --with flag when running the server.

评论

其他 分类下的更多 MCP 服务器

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

Mobile Mcp

mobile-next

Model Context Protocol Server for Mobile Automation and Scraping (iOS, Android, Emulators, Simulators and Real Devices)

5.4K

Nginx UI

0xJacky

Yet another WebUI for Nginx

11.3K

ACI: Open-Source Infra to Power Unified MCP Servers

aipotheosis-labs

ACI.dev is the open source tool-calling platform that hooks up 600+ tools into any agentic IDE or custom AI agent through direct function calling or a unified MCP server. The birthplace of VibeOps.

4.8K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K