Skip to main content
Glama
Sign In
deenesjakoruzh
Product Catalog MCP

Product Catalog MCP

by v-swaggarwal
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Hybrid

Product Catalog MCP

An Excel-backed MCP server plus a JOUST product management app.

Local MCP server

npm install
npm run init-data
npm start

The catalog is stored in data\products.xlsx. The MCP server exposes:

  • list_products

  • search_products

  • add_product

  • update_product

  • delete_product

VS Code configuration is included in .vscode\mcp.json, and the custom agent is in .github\agents\product-catalog.agent.md. The agent embeds the MCP server configuration for GitHub Copilot cloud agent. Its setup workflow installs Node.js dependencies before the agent starts.

Set PRODUCT_CATALOG_FILE to use a different workbook.

For an HTTP MCP endpoint:

npm run start:http

The local endpoint is http://localhost:3000/mcp. Deploy this Node.js process to a server-capable host to obtain a public MCP URL; JOUST itself hosts only static apps.

Related MCP server: ExcelReadMCP

JOUST app

The static app in web\ stores its shared data in JOUST and supports product CRUD, search, and Excel import/export. The hosted JOUST database and local Excel workbook are separate stores.

Available Tools

5 tools
add_productC

Add a product to the Excel catalog.

Inputs: id (required), name (required), price (required), sku, +5 more.

delete_productA

Delete a product selected by ID or exact name.

Inputs: identifier (required).

list_productsA

List every product in the Excel catalog.

Inputs: no named parameters.

search_productsA

Search products by ID, name, description, category, SKU, manufacturer, or status.

Inputs: query (required).

update_productB

Update a product selected by its current ID or exact name.

Inputs: identifier (required), id, sku, name, +6 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Deploy Server
    One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

    TDQS

    A3.7/5.0

    Scored across 5 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: list all, search with filters, add, update, and delete. No overlap or ambiguity between the operations.

    Naming Consistency5/5

    All tool names follow the exact same verb_noun pattern (list_products, search_products, add_product, update_product, delete_product). Consistent and predictable.

    Tool Count5/5

    Five tools perfectly cover the core catalog operations (CRUD plus search). The number is well-scoped and each tool earns its place.

    Completeness5/5

    The set provides complete lifecycle coverage: list, search, add, update, and delete. There are no obvious dead ends or missing essential operations for a product catalog.

    Resources

    Related MCP Connectors

    Related MCP Servers