Which integrations are available for this server?

Connects to a Supabase PostgreSQL database to manage employee leave data, including employees, leave types, balances, and requests, enabling tools for checking balances, applying for leave, approvals, and history.

How do I use Employee Leave Management MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Employee Leave Management MCP Server How many annual leave days do I have left?" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Employee Leave Management MCP Server

by adityapatel143

Overview Schema Related Servers Score Discussions

Python

Remote

Employee Leave Management — MCP Server

📌 Check out GenAI and System Design videos

An MCP (Model Context Protocol) server built with FastMCP that connects to a Supabase PostgreSQL database and lets Claude Desktop manage employee leave — checking balances, applying for leave, approvals, history, and more.

Architecture

┌───────────────────────────────────────────────────────┐
│  Claude Desktop (MCP Host)                            │
│                                                       │
│  "How many leaves does EMP001 have left this year?"   │
│                                                       │
│  Claude ──► get_leave_balance("EMP001", 2025)         │
│          ◄── [{Annual: 13 remaining}, {Sick: 8}, …]   │
│                                                       │
│  Claude: "Aditya has 13 Annual, 8 Sick, and 5 Casual  │
│           leave days remaining for 2025."             │
└───────────────────────────────────────────────────────┘
          │ stdio (subprocess)
          ▼
┌─────────────────────┐        ┌──────────────────────┐
│  server.py          │        │  Supabase (Postgres)  │
│  FastMCP + tools    │◄──────►│  employees            │
│                     │  REST  │  leave_types          │
│                     │  API   │  leave_balances       │
└─────────────────────┘        │  leave_requests       │
                               └──────────────────────┘

Related MCP server: leave-management

Exposed Tools

Tool	What it does
`list_leave_types`	All leave categories (Annual, Sick, Casual, …) with default allocation
`list_employees`	Active employees, optional department filter
`get_employee_info`	Look up one employee by code or email
`get_leave_balance`	Remaining / used / total days by employee & year
`apply_for_leave`	Submit a leave request (validates balance & date overlaps)
`get_leave_history`	All requests for an employee, filterable by year/status
`get_leave_request`	Full details of a single request by ID
`cancel_leave_request`	Employee withdraws a pending request
`approve_leave_request`	Manager approves — auto-deducts days from balance
`reject_leave_request`	Manager rejects with optional note

Resources

leave://schema — full schema overview attachable as context

Prompts

leave_assistant — structured conversation starter for the HR assistant

Quick Start

Step 1 — Create a Supabase project

Go to https://supabase.com and create a free project.
After the project is ready, go to Project Settings → API and copy:
- Project URL → SUPABASE_URL
- Project API Keys → anon public key (or service_role key for full access) → SUPABASE_KEY

Step 2 — Set up the database

In the Supabase Dashboard, open the SQL Editor → New Query.
Paste the full contents of setup_database.sql and click Run.

This creates four tables (employees, leave_types, leave_balances, leave_requests) plus a convenience view (leave_balances_view) and seeds 8 employees with realistic 2025 balances.

Step 3 — Configure environment variables

cd demo_projects/mcp
cp .env.example .env
# Edit .env with your Supabase URL and Key

.env contents:

SUPABASE_URL=https://your-project-ref.supabase.co
SUPABASE_KEY=your-anon-or-service-role-key

Step 4 — Install dependencies

uv sync

Step 5 — Test interactively (without Claude Desktop)

#uv run fastmcp dev server.py
uv run python server.py
# Opens MCP Inspector at http://localhost:6274

Connect to Claude Desktop

Locate the config file

OS	Path
macOS	`~/Library/Application Support/Claude/claude_desktop_config.json`
Windows	`%APPDATA%\Claude\claude_desktop_config.json`
Linux	`~/.config/Claude/claude_desktop_config.json`

Add the server block

{
  "mcpServers": {
    "employee-leave": {
      "command": "uv",
      "args": [
        "--directory",
        "/absolute/path/to/project_root",
        "run",
        "python",
        "server.py"
      ]
    }
  }
}

Important: Use the absolute path in --directory. You can get it by running pwd in the project folder.

Note: You may need to provide the full path to the uv executable in the command field. Run which uv (macOS/Linux) or where uv (Windows) to find it.

Restart Claude Desktop

Quit and reopen Claude Desktop. Click the + ("Add files, connectors, and more") icon in the chat input area, then hover over Connectors — you should see employee-leave listed there.

Note: Claude for Desktop is not yet available on Linux. Linux users can use the MCP Inspector or build a custom MCP client instead.

Connect to VS Code (GitHub Copilot)

VS Code supports MCP servers natively through GitHub Copilot agent mode. The config format is different from Claude Desktop.

Locate / create the config file

Scope	File
Workspace (team-shared)	`.vscode/mcp.json` in your project root
User profile (all workspaces)	Run `MCP: Open User Configuration` from the Command Palette

Add the server block

Create or edit .vscode/mcp.json:

{
  "servers": {
    "employee-leave": {
      "command": "uv",
      "args": [
        "--directory",
        "/absolute/path/to/project_root",
        "run",
        "python",
        "server.py"
      ]
    }
  }
}

Note: VS Code uses "servers" (not "mcpServers") and requires the "type": "stdio" field. Use the absolute path in --directory.

Tip: You may need to provide the full path to uv in "command". Run which uv to find it.

Start the server

Open the Command Palette (Ctrl+Shift+P) and run MCP: List Servers.
Select employee-leave and choose Start.
When prompted, confirm you trust the server.
Open the Chat view (Ctrl+Alt+I), switch to Agent mode, and the employee-leave tools will be available.

Verify tools are loaded

In the Chat view, select Configure Tools (or the tools icon) to see all tools provided by the employee-leave server and toggle individual tools on/off.

Troubleshooting

If the server fails to start, run MCP: List Servers → select the server → Show Output to view logs.

Example Conversations with Claude

You: How many leaves does Aditya have left for 2025?

Claude: [calls get_employee_info("EMP001"), then get_leave_balance("EMP001", 2025)]
        Aditya Sharma (EMP001) has:
        • Annual leave  : 13 days remaining (5 used of 18)
        • Sick leave    :  8 days remaining (2 used of 10)
        • Casual leave  :  5 days remaining (1 used of 6)

You: Apply for annual leave for EMP002 from 10th July to 18th July 2025.

Claude: [calls apply_for_leave("EMP002", "Annual", "2025-07-10", "2025-07-18")]
        Leave request submitted!
        • Employee   : Priya Nair (EMP002)
        • Type       : Annual
        • Dates      : 10 Jul – 18 Jul 2025  (7 business days)
        • Status     : Pending
        • Remaining after approval: 8 Annual days

You: Approve request ID 3.

Claude: [calls approve_leave_request(3)]
        Leave request #3 has been approved. 7 days deducted from Priya's Annual balance.

Database Schema

employees          -- employee_code, full_name, email, department, position
leave_types        -- name, description, default_days
leave_balances     -- one row per (employee, leave_type, year)
leave_balances_view -- denormalised view with remaining_days computed
leave_requests     -- status: pending | approved | rejected | cancelled

Project Files

demo_projects/mcp/
├── server.py             ← FastMCP server (all tools, resources, prompts)
├── setup_database.sql    ← Run once in Supabase SQL Editor
├── pyproject.toml        ← Dependencies (fastmcp, supabase, python-dotenv)
├── .env.example          ← Copy to .env and fill in credentials
└── README.md             ← This file

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Related MCP Servers

LeaveManager
App Automation Workplace & Productivity
umamaheswararao04
F
license
B
quality
D
maintenance
A Model Context Protocol server that enables users to manage employee leave through natural language. It provides tools to check leave balances, apply for leave, and view leave history via Claude integration.
Updated 7 months ago (2026-01-24 03:50 UTC)
3
leave-management
kanthirayakota-cloud
F
license
-
quality
C
maintenance
Enables employees to check leave balance, apply for leave, and view leave history through natural language using Claude Desktop.
Updated 2 months ago (2026-06-03 13:06 UTC)
HR Leave Management MCP Server
Workplace & Productivity Project Management
enggvaij
F
license
B
quality
C
maintenance
Enables managing employee leave requests (apply, view, list leaves) through Claude desktop using natural language.
Updated 2 months ago (2026-06-19 20:24 UTC)
6
MCP Leave Manager Server
Databases Workplace & Productivity
chalamalasettichamundeswari
F
license
-
quality
D
maintenance
Enables managing employee leave requests, balances, and approvals through natural language with Claude Desktop, using SQLite for persistence and fuzzy name matching.
Updated a year ago (2025-09-23 15:05 UTC)

View all related MCP servers

Related MCP Connectors

WHOOP — MissingMCP
WHOOP recovery, strain, sleep and workouts in Claude via official WHOOP OAuth. Free, open source.
sentinel
Uptime, SSL, DNS and domain monitoring you can talk to from Claude or any MCP client.
FoundRole — AI Job Search & Application Tracker MCP for Claude & ChatGPT
MCP server for AI job search — find jobs, track applications, get alerts. Claude, ChatGPT, Cursor.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/adityapatel143/GenAi_Employee_Leave_Management-MCP_Server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

Employee Leave Management — MCP Server

📌 Check out GenAI and System Design videos

Architecture

Exposed Tools

Quick Start

Step 1 — Create a Supabase project

Step 2 — Set up the database

Step 3 — Configure environment variables

Step 4 — Install dependencies

Step 5 — Test interactively (without Claude Desktop)

Connect to Claude Desktop

Locate the config file

Add the server block

Restart Claude Desktop

Connect to VS Code (GitHub Copilot)

Locate / create the config file

Add the server block

Start the server

Verify tools are loaded

Troubleshooting

Example Conversations with Claude

Database Schema

Project Files

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

LeaveManager

leave-management

HR Leave Management MCP Server

MCP Leave Manager Server

Related MCP Connectors

Latest Blog Posts

MCP directory API