A
licenseNot graded
qualityD
maintenanceEnables comprehensive product management for e-commerce with CRUD operations, AI-powered product description generation, inventory tracking, and MySQL database integration.
6
1
MIT
E-commerce MCP Server
by eeshapatel12
Click on "Deploy 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 aiosqliteRelated MCP server: MCP E-commerce Server
Running 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 deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Manage products, orders, customers, inventory, and store configuration
Manage your NanoCart store from any AI agent: products, orders, coupons, subscribers, reports.
Run storefronts, listings, orders, content, fulfillment, and analytics through AI.
Hosted storefront backend for AI agents: products, cart, Stripe + PayPal, delivery, order tracking.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables management of retail e-commerce products with CRUD operations, AI-powered product description generation, and inventory tracking through SQLite database integration.MIT
- FlicenseNot gradedqualityCmaintenanceEnables AI to view and manage e-commerce data such as products, orders, and coupons, and perform actions like updating prices, stock, and generating sales reports.-
- AlicenseCqualityCmaintenanceEnables e-commerce product management with CRUD operations, AI-powered descriptions, and MySQL database integration via MCP.46MIT