E-commerce MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | The database host | |
| DB_PORT | No | The database port | |
| DB_USER | No | The database user | |
| DB_DATABASE | No | The database name | |
| DB_PASSWORD | No | The database password |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| prompts | {
"listChanged": true
} |
| resources | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| add_productC | Create a new product with sku, name, description(optional but better to have), price, and quantity. |
| get_product_by_idA | Fetch a product's details using its unique ID(number). |
| delete_productB | Delete a product using its unique ID(number). Returns true if deletion was successful, false otherwise. |
| update_productB | Update an existing product by providing correct id(mandatory) as input along with with sku(optional), name(optional), description(optional but better to have), price(optional), and quantity(optional). |
| add_product_smartlyC | Create a new product with sku, name, description(optional), price, and quantity. Since description is optional, is description is missing, use smart AI generated description if missing. This tool also checks for existing products with the same SKU to prevent duplicates. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| generate_product_description_template | Generates a concise and appealing product description template based on the product name provided. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| product_catalog | A catalog of products available in the e-commerce store, including their details such as SKU, name, description, price, and quantity in stock. |
| low_product_inventory | A list of products that have low inventory levels and may need restocking soon. |
TDQS
Scored across 5 tools
add_product and add_product_smartly overlap significantly, both creating products with the same parameters, though add_product_smartly adds AI description generation and duplicate checking. The other tools are distinct CRUD operations, so the main ambiguity is between the two creation tools.
Most tools follow a verb_noun pattern (add_product, get_product_by_id, delete_product, update_product), but add_product_smartly breaks the convention with an adverb suffix. The naming is mostly consistent but the smartly variant is a deviation.
Five tools is a reasonable count for a simple product CRUD server. The add_product_smartly tool is somewhat redundant, making the count feel slightly padded, but it's still within an appropriate range.
The server covers the core CRUD lifecycle for products: create, read, update, delete. A list/search products tool is missing, which is a notable gap for an e-commerce server, but the essential operations are present.