Skip to content
ecommerceguide.
Explore ecommerceguide.

MCP server

MCP E-commerce Server

MCP server that manages product records in a MySQL database, with create, read, update, delete, search, AI-generated descriptions and low-stock resources.

View on GitHub (opens in a new tab)Compare alternatives
  • Community
  • Runs locally
  • No credentials

Repository and documentation last checked Built from public product pages and documentation. SourcesClaim this listing

ecommerceguide summary

MCP Ecommerce Server is a community MCP server that exposes a MySQL product table to MCP clients. It covers create, read, update, delete and paginated name search, generates product descriptions through MCP sampling, and publishes product catalogue and low-stock resources plus prebuilt prompts. Written in TypeScript with Zod validation, it runs locally over stdio or HTTP/SSE after npm install, reading database settings from environment variables. MIT licensed, maintained by Preetash.

Why it stands out

Generates product descriptions through MCP sampling, so the connected client's model does the writing rather than a vendor API key.

What MCP E-commerce Server does

ecommerceguide editorial
  • Create, read, update, delete and search products in MySQL
  • Product description generation through MCP sampling, using the client's model
  • Resources for the product catalogue and low-stock monitoring
  • stdio plus HTTP/SSE transports, run locally from source
  • Database credentials come from environment variables, no vendor account
  • MIT licensed TypeScript code, published by Preetash on GitHub
  • README points at clients such as Claude Desktop and MCP Inspector

How ecommerce teams could use it

ecommerceguide editorial

Illustrative scenarios written by ecommerceguide from the product's documented capabilities. They are not customer case studies.

  1. A developer running a custom storefront backed by a MySQL product table

    Connecting Claude Desktop over stdio to look up SKUs and edit product records conversationally

    Intended outcomeThe server handles the create, read, update, delete and search calls against MySQL

  2. A team keeping stock levels in MySQL

    Watching which products are running low without building a separate report

    Intended outcomeThe low-stock resource exposes inventory levels to the connected MCP client

  3. An engineer learning how to build MCP servers

    Reading a small TypeScript example that covers tools, resources, prompts and sampling

    Intended outcomeThe MIT-licensed repository can be installed with npm and run over stdio or HTTP/SSE

Who it suits

ecommerceguide editorial

Best for

You store products in MySQL and want a local, MIT-licensed MCP server covering product CRUD, search, low-stock resources and sampled descriptions.

Probably not for

You need a hosted endpoint, authentication beyond local environment variables, or a connector to a platform other than MySQL.

Business size
Any stageNo pricing or stated audience; the README describes a minimal server you run yourself against your own MySQL database.

Technical details

From the vendor's own pages

From the server's repository, documentation and MCP directory listings.

What an agent can do
Manage products, Inventory, Product content
Transport
stdio (local), HTTP (remote), SSE (deprecated)
Authentication
No credentials"All database params come from environment variables" (.env.example); no vendor credential required.
Package
mcp-ecommerce-crud
Language
JavaScript
Licence
MIT
Repository last updated
12 Nov 2025

Connect MCP E-commerce Server

Third-party data
Install command
npm i

Command as listed on the repository README, not tested by ecommerceguide. Check the repository README (opens in a new tab) for configuration and credentials before running it.

Categories and use cases

Alternatives to MCP E-commerce Server

Listings that share this one's category, platforms or use cases. Ordered by how many relationships they share, not by quality or payment.

View all MCP servers

Sources

ecommerceguide profiles are built from public product information and written for ecommerce teams. We do not test products, and paying never changes where a listing ranks.

Also listed on PulseMCP.

See something incorrect? Report an update

View all MCP servers