personnel-absence-tracker
A specialized MCP server facilitating the comprehensive administration of employee time-off entitlements, encompassing functionalities for reviewing past absence records, formally lodging new leave requests, and accurately quantifying residual paid leave balances, all persisted via an embedded SQLite data repository.
Author

azalin
Quick Info
Actions
Tags
Personnel Leave Management MCP Core Service
This repository hosts an implementation of an MCP (Model Context Protocol) core service engineered specifically for regulating and tracking staff attendance leave.
Key Capabilities
- Retrieval of the complete roster of employee leave history.
- Mechanism for initiating and submitting novel leave applications.
- Automated computation of accrued, remaining leave days.
- Native persistence layer utilizing SQLite database technology.
- Adherence to the established MCP communication standard.
Deployment Instructions
- Install necessary system dependencies:
bash pip install -r requirements.txt
- Initialize and structure the persistence layer:
bash python create_db.py
Containerized Execution
To initiate the service using container orchestration:
bash docker-compose up --build
Accessing the MCP Endpoint
The service can be engaged via two distinct operational modes:
- Local Iteration (Development):
bash python izin-mcp.py
-
Remote Access via Smithery.ai (Production):
-
API Endpoint: https://smithery.ai/server/@azalin/mcp-test/api
- Communication Protocol: Standard I/O (STDIO)
n8n Workflow Integration Guide
For setting up an MCP Client connection within an n8n automation environment:
- Connection Paradigm: Command Line Interface (STDIO)
- Executable Command: python
- Required Parameters: -m mcp.client.stdio https://smithery.ai/server/@azalin/mcp-test/api
Licensing Agreement
This project is distributed under the MIT License.
