Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@E-commerce MCP Servershow me the sales summary for this month"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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 aiosqliteRunning the Server
# Using fastmcp CLI
fastmcp run ecommerce_server.py
# Or directly with Python
python ecommerce_server.pyConfiguring 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 a new product to inventory |
| Get product by ID or SKU |
| List products with filtering (category, stock level) |
| Update product details |
| Soft delete (deactivate) a product |
| Add or subtract stock quantity |
| Search products by name/description |
Customer Management
Tool | Description |
| Add a new customer |
| Get customer by ID or email |
| List customers with filtering |
| Update customer details |
| Soft delete (deactivate) a customer |
| Search customers by name/email |
Order Management
Tool | Description |
| Create a new order for a customer |
| Add a product to an order |
| Remove a product from an order |
| Get order by ID or order number |
| List orders with filtering (customer, status, date range) |
| Update order status (pending → confirmed → shipped → delivered) |
Data Analysis & Reporting
Tool | Description |
| Revenue, order count, average order value for a period |
| Top selling products by quantity and revenue |
| Top customers by spend and order count |
| Stock levels, out-of-stock items, category breakdown |
| Complete order history for a customer |
| 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
This server cannot be installed
Resources
Looking for Admin?
Admins can modify the Dockerfile, update the server description, and track usage metrics. If you are the server author, to access the admin panel.