Personnel Leave Oversight MCP Endpoint

This repository hosts the source code for an MCP (Model Context Protocol) server application engineered specifically for managing staff leave tracking operations.

Key Features

• Retrieval of the complete roster of personnel leave records.
• Functionality to formally lodge a new leave application.
• Computation engine for determining remaining authorized leave days.
• Native integration with an SQLite database system.
• Adherence to the Model Context Protocol (MCP) specification.

Implementation Guide

1. Install required dependencies:

bash pip install -r requirements.txt

1. Initialize and populate the persistence layer:

bash python create_db.py

Deployment via Docker

Execute the following command to launch the service within a containerized environment:

bash docker-compose up --build

Accessing the MCP Server

The endpoint can be connected to using two distinct methods:

1. Local Execution (Development Mode):

bash python izin-mcp.py

1. Via Smithery.ai Gateway (Production Environment):

2. Endpoint URI: https://smithery.ai/server/@azalin/mcp-test/api

3. Communication Medium: Standard Input/Output (STDIO)

n8n Workflow Integration

To establish an MCP Client connection within an n8n workflow:

1. Set Connection Type to: Command Line (STDIO)
2. Specify Command: python
3. Supply Arguments: -m mcp.client.stdio https://smithery.ai/server/@azalin/mcp-test/api

Software License

Licensed under the MIT License.