# 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