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:

Or activate the virtual environment and use the MCP CLI:

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%\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