Inventory Tracker Server

A Model Context Protocol (MCP) server that lets Claude AI manage a real PostgreSQL inventory database using natural language.

🛠️ Tech Stack

• Python 3.11
• MCP (Model Context Protocol) by Anthropic
• PostgreSQL
• psycopg2
• python-dotenv

✨ Features

• Add new items or restock existing ones
• Sell/remove stock with automatic low stock warnings
• View full inventory grouped by category
• Check items running low on stock
• View full activity history log
• Delete items permanently

🚀 How It Works

Claude Desktop connects to this MCP server and uses natural language to manage inventory in a real PostgreSQL database.

Example prompts:

• "Add 50 units of Coffee at $12.50 in category Food"
• "List my inventory"
• "Check low stock"
• "Show my activity history"

⚙️ Setup

1. Install dependencies

pip install -r requirements.txt

2. Create .env file

DB_HOST=localhost DB_PORT=5432 DB_NAME=inventory_db DB_USER=your_user DB_PASSWORD=your_password

3. Run the server

python server.py

4. Connect to Claude Desktop

Add to claude_desktop_config.json: { "mcpServers": { "inventory-tracker-pro": { "command": "python", "args": ["/path/to/server.py"] } } }

📁 Project Structure

inventory-mcp-pg/ ├── server.py # Main MCP server ├── requirements.txt # Dependencies ├── .env # Database credentials (not uploaded) └── README.md # This file