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 confirmationconfirmed- Order confirmed, stock reservedshipped- Order shipped to customerdelivered- Order deliveredcancelled- Order cancelled, stock restored