E-commerce MCP Server

A FastMCP server for managing products, customers, and orders with full CRUD operations and data analysis capabilities.

Installation

# Create and activate virtual environment
python3 -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

# Install dependencies
pip install fastmcp sqlalchemy aiosqlite

Running the Server

# Using fastmcp CLI
fastmcp run ecommerce_server.py

# Or directly with Python
python ecommerce_server.py

Configuring with Claude Desktop

Add this to your Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "ecommerce": {
      "command": "/path/to/venv/bin/python",
      "args": ["/path/to/ecommerce_server.py"],
      "env": {
        "ECOMMERCE_DB_PATH": "/path/to/ecommerce.db"
      }
    }
  }
}

Available Tools (25 total)

Product Management

Tool	Description
`add_product`	Add a new product to inventory
`get_product`	Get product by ID or SKU
`list_products`	List products with filtering (category, stock level)
`update_product`	Update product details
`delete_product`	Soft delete (deactivate) a product
`update_stock`	Add or subtract stock quantity
`search_products`	Search products by name/description

Customer Management

Tool	Description
`add_customer`	Add a new customer
`get_customer`	Get customer by ID or email
`list_customers`	List customers with filtering
`update_customer`	Update customer details
`delete_customer`	Soft delete (deactivate) a customer
`search_customers`	Search customers by name/email

Order Management

Tool	Description
`create_order`	Create a new order for a customer
`add_order_item`	Add a product to an order
`remove_order_item`	Remove a product from an order
`get_order`	Get order by ID or order number
`list_orders`	List orders with filtering (customer, status, date range)
`update_order_status`	Update order status (pending → confirmed → shipped → delivered)

Data Analysis & Reporting

Tool	Description
`get_sales_summary`	Revenue, order count, average order value for a period
`get_top_products`	Top selling products by quantity and revenue
`get_top_customers`	Top customers by spend and order count
`get_inventory_report`	Stock levels, out-of-stock items, category breakdown
`get_customer_order_history`	Complete order history for a customer
`get_profit_analysis`	Profit margins by product (requires cost data)

Example Usage

Adding Products

"Add a product: iPhone 15 Pro, SKU: IP15PRO, price $999, cost $750, 50 in stock, category Electronics"

Managing Customers

"Add customer John Doe, email john@example.com, phone 555-1234"
"Find all customers in New York"

Creating Orders

"Create an order for customer ID 1"
"Add 2 units of product ID 3 to order ID 1"
"Mark order 1 as shipped"

Data Analysis

"Show me the sales summary for this month"
"What are the top 5 selling products?"
"Which products are low on stock?"
"Show profit analysis for Q4"

Database

The server uses SQLite by default. The database file location can be configured via the ECOMMERCE_DB_PATH environment variable.

Schema

Products: id, name, description, sku, price, cost, quantity_in_stock, category, is_active
Customers: id, email, first_name, last_name, phone, address, city, state, postal_code, country, is_active
Orders: id, customer_id, order_number, status, total_amount, shipping_address, notes
OrderItems: id, order_id, product_id, quantity, unit_price

Order Statuses

pending - Order created, awaiting confirmation
confirmed - Order confirmed, stock reserved
shipped - Order shipped to customer
delivered - Order delivered
cancelled - Order cancelled, stock restored