📦 Admin Inventory Management – Remote MCP Server

A production-ready Remote MCP (Model Context Protocol) Server built using FastMCP, enabling Claude Desktop to manage office inventory using natural language.

🌐 Live Endpoint: https://admin-inventory-management-remote-mcp.onrender.com/

🚀 Project Overview

This project implements an AI-powered Office Admin Inventory Management System using the Model Context Protocol (MCP).

It allows Claude Desktop to:

• Add inventory items

• Issue stock

• Check stock availability

• List all items

• Trigger low-stock alerts

All operations are executed via structured tool calls and backed by a persistent database.

🧠 Architecture

🔹 Local Architecture

Claude Desktop
      ↓ (stdio MCP)
FastMCP Server
      ↓
SQLite Database

Related MCP server: Enterprise Expense Automation System

🔹 Remote Architecture (Production)

Claude Desktop
      ↓ (HTTPS MCP Protocol)
Remote FastMCP Server (Render)
      ↓
SQLite Database

🛠️ Tech Stack

• FastMCP – MCP server implementation

• SQLAlchemy – ORM for database interaction

• SQLite – Persistent storage

• Docker – Containerization

• Render – Cloud deployment

• Claude Desktop – LLM client

⚙️ How It Was Built

1️⃣ MCP Tool-Based Server

Inventory operations are exposed as structured tools:

@mcp.tool()
def add_item(name: str, category: str, quantity: int, min_threshold: int):

Each tool:

• Validates inputs

• Executes deterministic business logic

• Updates the database

• Returns structured output

2️⃣ Database Layer

Built using SQLAlchemy ORM.

Item Model Fields:

• name

• category

• quantity

• min_threshold

This ensures persistent and reliable inventory tracking.

3️⃣ HTTP Transport Mode

Converted from local stdio transport to HTTP transport for remote deployment:

mcp.run(
    transport="http",
    host="0.0.0.0",
    port=port
)

This allows Claude to communicate securely over HTTPS.

4️⃣ Dockerized Deployment

Dockerfile used for containerization:

FROM python:3.11-slim
WORKDIR /app
COPY requirements.txt .
RUN pip install -r requirements.txt
COPY . .
EXPOSE 8000
CMD ["python", "server.py"]

Deployed as a Web Service on Render.

🌐 Live Endpoint Behavior

Opening the URL in a browser may show:

Not Found

This is expected behavior.

MCP servers expose protocol endpoints — not web UI routes.

🔗 How to Configure in Claude Desktop

Step 1: Open Claude Settings

Go to:

Settings → Developer → MCP Servers

Step 2: Edit Claude Configuration File

Windows:

%APPDATA%\Claude\claude_desktop_config.json

Mac:

~/Library/Application Support/Claude/claude_desktop_config.json

Step 3: Add Remote MCP Server Configuration

{
  "mcpServers": {
    "admin-inventory-remote": {
      "transport": "http",
      "url": "https://admin-inventory-management-remote-mcp.onrender.com"
    }
  }
}

Step 4: Restart Claude Desktop

Claude will automatically:

• Discover available tools

• Enable natural language inventory management

🧪 Example Usage in Claude

You can now say:

• “Add 200 ball pens in Stationery category with threshold 40.”

• “Issue 30 ball pens.”

• “Check stock of printer paper.”

• “List all items in inventory.”

Claude will:

1. Interpret intent

2. Select appropriate MCP tool

3. Send structured arguments

4. Execute backend logic

5. Return updated inventory status

🎯 Key Design Principles

🔹 Separation of Concerns

• LLM handles reasoning

• MCP handles structured execution

• Database ensures persistence

🔹 Deterministic Backend

The LLM does not directly manipulate the database. All operations pass through validated business logic.

🔹 Secure Protocol Communication

Claude communicates with the server using MCP over HTTPS.