📦 Inventory Tracker MCP 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

Related MCP server: PocketBase MCP Server

✨ 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