MCP E-commerce Server

A Model Context Protocol (MCP) server for retail e-commerce product management with CRUD operations, AI-powered descriptions, and database integration(Sqlite).

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

Quick start

The 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