Attendance Management MCP Server

by shineliang

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

-
security - not tested
-
license - not tested
-
quality - not tested

A Model Context Protocol server that enables querying attendance information and managing employee leave requests, overtime requests, and schedules.

  1. Features
    1. Prerequisites
      1. Installation
        1. Running the Server
          1. Using with Claude Desktop
            1. Troubleshooting
          2. Available Tools
            1. Employee Information
            2. Attendance Records
            3. Leave Management
            4. Overtime Management
            5. Schedule Management
            6. Statistics and Reports
          3. Available Resources
            1. Available Prompts
              1. License

                Related MCP Servers

                • -
                  security
                  A
                  license
                  -
                  quality
                  A Model Context Protocol server that provides a standardized interface for interacting with Notion's API, enabling users to list databases, create pages, and search across their Notion workspace.
                  Last updated -
                  95
                  Python
                  MIT License
                  • Apple
                • -
                  security
                  A
                  license
                  -
                  quality
                  A Model Context Protocol server that helps track expenses and calculate reimbursements for social events, making it easy to settle balances between friends.
                  Last updated -
                  Python
                  Apache 2.0
                • A
                  security
                  A
                  license
                  A
                  quality
                  A Model Context Protocol server providing utility tools for development and testing, offering functionalities like personalized greetings, random card drawing, and datetime formatting with an extensible architecture.
                  Last updated -
                  19
                  167
                  2
                  TypeScript
                  MIT License
                  • Apple
                  • Linux
                • -
                  security
                  -
                  license
                  -
                  quality
                  A Model Context Protocol (MCP) server that interacts with system APIs, allowing users to check connections, search employees, register breakfast, and update chemical information by shifts.
                  Last updated -
                  2

                View all related MCP servers

                ID: h01i17s6kb