Leave Manager MCP Server

This project is a Python MCP server for managing employees, leave balances, and leave requests with SQLite.

1. Create the project

Open PowerShell and create a project directory:

mkdir D:\Coding\mcpserver\LeaveManager
cd D:\Coding\mcpserver\LeaveManager

Create a uv Python project inside leave_manager_server:

uv init leave_manager_server
cd leave_manager_server
uv add "mcp[cli]>=2.1.1"

The project requires Python 3.14 or newer. uv creates pyproject.toml, uv.lock, and the virtual environment used to run the server.

Related MCP server: leave_manager

2. Implement the server

Create server.py and add the following parts:

1. Import MCPServer from mcp.server.mcpserver.

2. Create the server with MCPServer("Leave Manager").

3. Define Employee and LeaveRequest data models.

4. Create a SQLite database next to server.py using an absolute path.

5. Initialize employees and leave_requests tables and insert sample data on startup.

6. Add resources for employee directories and leave requests.

7. Add tools to submit and approve leave, check balances, list pending approvals, get database statistics, and add employees.

8. Start the server from the __main__ block:

if __name__ == "__main__":
		init_database()
		mcp.run()

The project uses MCP 2.x. The old MCP 1.x import does not work with this dependency:

from mcp.server.fastmcp import FastMCP

The working MCP 2.x form is:

from mcp.server.mcpserver import MCPServer

mcp = MCPServer("Leave Manager")

3. Run the server directly

From the project directory:

cd D:\Coding\mcpserver\LeaveManager\leave_manager_server
uv run server.py

The server uses standard input/output for MCP communication, so it stays running while an MCP client is connected. Press Ctrl+C to stop it.

Validate that the module imports correctly without starting the long-running server:

uv run python -c "import server; print('Server import valid')"

4. Test with MCP Inspector

The supported development command is:

cd D:\Coding\mcpserver\LeaveManager\leave_manager_server
uv run mcp dev server.py

The MCP Inspector uses Node.js. Install Node.js 22.19.0 or newer before using the latest Inspector. Check versions with:

node --version
npm --version

Do not run npm i in this Python project directory because it has no package.json. If Inspector reports a missing native binding, clear the temporary npx cache and retry:

Remove-Item "$env:LOCALAPPDATA\npm-cache\_npx" -Recurse -Force
uv run mcp dev server.py

5. Connect Claude Desktop

Claude Desktop reads its configuration from:

%APPDATA%\Claude\claude_desktop_config.json

Add this server entry. Replace the path if the project is stored elsewhere:

{
	"mcpServers": {
		"leave-manager": {
			"command": "uv",
			"args": [
				"run",
				"--directory",
				"D:\\Coding\\mcpserver\\LeaveManager\\leave_manager_server",
				"server.py"
			]
		}
	}
}

Restart Claude Desktop after saving the configuration. The server creates leave_manager.db beside server.py on its first startup.

Available MCP features

Resources:

• employees://all

• employee://{employee_id}

• leave-requests://all

• leave-requests://employee/{employee_id}

• leave-requests://status/{status}

Tools:

• submit_leave_request

• approve_leave_request

• check_leave_balance

• get_pending_approvals

• get_database_stats

• add_employee

• This will add my Config file automatic uv run mcp install server.py --name "leave_manager"