Attendance Management MCP Server

# 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](https://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%\Claude\Logs\mcp*.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