Skip to main content
Glama
Inventory Tracker MCP Server

Inventory Tracker MCP Server

by pborlagdan

πŸ“¦ 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: MCP Product Management System

✨ 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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that enables Claude and other LLMs to perform database operations and invoke Edge Functions within Supabase through natural language.
      1,421 npm
      4
      MIT
    • F
      license
      Not graded
      quality
      D
      maintenance
      A comprehensive Model Context Protocol (MCP) server for product inventory management with PostgreSQL database backend, enabling natural language queries for product information across multiple AI platforms.
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      An MCP server that allows Claude to query and manipulate a PostgreSQL database using natural language, with tools for listing tables, describing tables, and performing CRUD operations.
      1
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol (MCP) Server that allows AI models to securely interact with data hosted in Azure Database for PostgreSQL. It enables natural language querying, schema exploration, and data management through MCP clients like Claude Desktop and Visual Studio Code.
      MIT