Inventory MCP Server
A Model Context Protocol (MCP) server for managing inventory using Supabase (PostgreSQL) database.
Features
- Add Inventory: Add or update inventory items with product name, location, and quantity
- Remove Inventory: Remove items from inventory at specific locations
- Check Stock: Query stock levels for specific items at locations
- List Inventory: Get a complete list of all inventory items
Prerequisites
- Python 3.11 or higher
- Supabase account with a project
- Database password from Supabase Dashboard
Setup Instructions
1. Install Dependencies
pip install fastmcp psycopg2-binary supabase
Or using the project file:
pip install -e .
2. Set Up Supabase Database
Run the simplified database setup script:
python setup_database_simple.py
This will:
- Connect to your Supabase database (port 6543 - connection pooler)
- Create the
inventorytable - Insert sample data (24 items across 4 locations)
You'll be prompted for:
- Your Supabase database password
Note: Your Supabase URL and configuration are already set in the script:
- Host:
db.sitomhzoqsoqpkaglxzg.supabase.co - Port:
6543(connection pooler) - Database:
postgres - User:
postgres
3. Server Configuration
The server is already configured with your Supabase credentials:
- Supabase URL:
https://sitomhzoqsoqpkaglxzg.supabase.co - Database password is set to
root(default) - Port:
6543(connection pooler)
If you need to change the password, edit inventory-mcp-server.py:
DB_PASSWORD = os.getenv("SUPABASE_DB_PASSWORD", "your_password")
Or set an environment variable:
set SUPABASE_DB_PASSWORD=your_password
4. Run the Server
python inventory-mcp-server.py
Database Schema
The inventory table has the following structure (PostgreSQL/Supabase):
item_id(VARCHAR(50)) - Unique item identifierproduct_name(VARCHAR(100)) - Name of the productlocation(VARCHAR(50)) - Location/warehouse namequantity(INT) - Stock quantity- Primary Key: (
item_id,location)
Available Tools
add_inventory
Adds or updates inventory items.
Parameters:
item_id(str): Unique identifier for the itemproduct_name(str): Name of the productlocation(str): Location/warehouse namequantity(int): Quantity to add
Returns: Confirmation message
remove_inventory
Removes items from inventory.
Parameters:
item_id(str): Item identifierlocation(str): Location/warehouse namequantity(int): Quantity to remove
Returns: Confirmation message
check_stock
Checks stock level for a specific item at a location.
Parameters:
item_id(str): Item identifierlocation(str): Location/warehouse name
Returns: Item details with current stock level
list_inventory
Lists all inventory items.
Returns: List of all inventory items with their details
Sample Data
The setup script includes sample data for:
- Laptops (LAP-001 to LAP-006)
- Mobile phones (MOB-001 to MOB-006)
- Tablets (TAB-001 to TAB-006)
- Accessories (ACC-001 to ACC-006)
Items are distributed across locations: Bengaluru, Mumbai, Delhi, and Pune.
Troubleshooting
Supabase Connection Issues
-
Verify Database Password:
- Go to: https://supabase.com/dashboard/project/sitomhzoqsoqpkaglxzg/settings/database
- Check or reset your database password
-
Check Connection Settings:
- Default port:
6543(connection pooler - recommended) - Alternative:
5432(direct connection) - Ensure SSL is enabled (
sslmode=require)
- Default port:
-
IP Allowlist:
- Check Supabase Dashboard > Settings > Database > Connection Pooling
- Ensure your IP is allowed or use "Allow all IPs" for development
-
Test Connection:
python test_connection.py
Import Errors
If you encounter import errors, ensure all dependencies are installed:
pip install --upgrade fastmcp psycopg2-binary supabase
License
This project is provided as-is for educational and development purposes.