Attendance Management MCP Server

This is a Model Context Protocol (MCP) server for attendance information queries and form applications. It provides tools and resources for managing employee attendance, leave requests, overtime requests, and schedules.

Features

• Employee information management
• Attendance record tracking
• Leave request management
• Overtime request management
• Schedule management
• Statistics and reports

Prerequisites

• Python 3.10 or higher
• Neon PostgreSQL database

Installation

1. Clone this repository:

   git clone https://github.com/yourusername/attendance-mcp-server.git
   cd attendance-mcp-server
   

2. Set up a virtual environment and install the required dependencies:

   ./setup_venv.sh
   

3. Configure the database connection by creating a .env file with the following content:

   DB_HOST=db.weathered-shadow-70756968.us-east-2.aws.neon.tech
   DB_NAME=shinedb
   DB_USER=shine_user
   DB_PASSWORD=Shine@123456#!
   DB_PORT=5432
   

Running the Server

You can run the server using the wrapper script:

./run_mcp.sh

Or activate the virtual environment and use the MCP CLI:

source .venv/bin/activate
mcp run attendance_mcp_server.py

Using with Claude Desktop

To use this server with Claude Desktop:

1. Install Claude Desktop from claude.ai/download

2. Run the installation script to configure Claude Desktop:

   python install_claude_desktop.py
   

3. Restart Claude Desktop

Troubleshooting

If you encounter the “No module named ‘mcp’” error:

1. Make sure the MCP package is installed in the Python environment that Claude Desktop is using:

   ./install_dependencies.sh
   

2. Check the Claude Desktop logs for more information:

   • On macOS: ~/Library/Logs/Claude/mcp*.log
   • On Windows: %APPDATA%ClaudeLogsmcp*.log

3. If the issue persists, try running the MCP server manually to see if there are any errors:

   ./run_attendance_mcp.sh
   

Available Tools

Employee Information

• get_employee_info: Get employee information by ID or employee number
• list_employees: List employees with optional filtering
• list_departments: List all departments

Attendance Records

• get_attendance_records: Get attendance records with optional filtering
• submit_attendance_record: Submit a new attendance record or update an existing one

Leave Management

• get_leave_requests: Get leave requests with optional filtering
• submit_leave_request: Submit a new leave request
• approve_leave_request: Approve or reject a leave request

Overtime Management

• get_overtime_requests: Get overtime requests with optional filtering
• submit_overtime_request: Submit a new overtime request
• approve_overtime_request: Approve or reject an overtime request

Schedule Management

• get_employee_schedule: Get employee schedule with optional filtering
• list_shifts: List all available shifts
• assign_schedule: Assign a schedule to an employee

Statistics and Reports

• get_monthly_attendance_stats: Get monthly attendance statistics
• get_holidays: Get holidays with optional filtering

Available Resources

• employee://{employee_id}: Get employee information as a resource
• department://{department_id}: Get department information as a resource
• attendance://{employee_id}/{date}: Get attendance information for a specific employee and date

Available Prompts

• request_leave: Create a leave request prompt
• request_overtime: Create an overtime request prompt
• check_attendance: Create an attendance check prompt

License

MIT