MCP E-commerce Server
Provides product management capabilities including CRUD operations, smart search, and low stock monitoring, backed by a MySQL database.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
MCP E-commerce Server
A comprehensive Model Context Protocol (MCP) server for e-commerce product management with CRUD operations, AI-powered descriptions, and database integration.
Features
🛍️ Complete CRUD Operations - Create, read, update, delete products
🤖 AI-Powered Descriptions - Automatic product description generation using MCP sampling
📊 Database Integration - MySQL database with proper schema
🔍 Smart Search - Search products by name with pagination
📦 Low Stock Monitoring - Resource for tracking inventory levels
🌐 Dual Transport Support - Both stdio and HTTP/SSE transports
🔧 TypeScript - Fully typed with Zod validation
📋 MCP Resources - Product catalog and low-stock resources
🎯 MCP Prompts - Pre-built prompt templates
Related MCP server: MCP E-commerce Server
Quick start
# 1) Install deps
npm i
# 2) Prepare env
cp .env.example .env
# 3) Create schema (optional, run in your MySQL)
# See sql/schema.sql
# 4) Run demo (non-MCP) usage
npm run dev:demo
# 5) Run MCP server (stdio transport)
npm run dev:mcpThe MCP server prints nothing special; it waits on stdio for a client like Claude Desktop / MCP Inspector / Apps SDK to connect.
Notes
This is intentionally minimal and tutorial‑friendly.
All database params come from environment variables.
You can extend with transactions, pagination, auth, etc.
#package.json npm link
npm login npm publish --access public
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Unified MCP server for 70+ eCommerce platforms: products, orders, customers, and more.
Hosted MCP for e-commerce: live product catalog, stock, and pricing for AI agents.
AI commerce for Shopify: product search, comparison, recommendations, and checkout via MCP.
Let your AI manage WooCommerce and Shopify stores: products, SEO, descriptions and images.
Related MCP Servers
- AlicenseBqualityDmaintenanceEnables comprehensive product management for e-commerce with CRUD operations, AI-powered product description generation, inventory tracking, and MySQL database integration.51MIT
- AlicenseNot gradedqualityNot gradedmaintenanceEnables management of retail e-commerce products with CRUD operations, AI-powered product description generation, and inventory tracking through SQLite database integration.MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that enables full CRUD operations for e-commerce product management, featuring MySQL integration and AI-powered product description generation. It provides tools for inventory monitoring and supports both stdio and HTTP/SSE transports.MIT
- AlicenseCqualityDmaintenanceEnables e-commerce product management with CRUD operations, AI-powered descriptions, and MySQL database integration via MCP.4MIT