# Product Catalog MCP

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

## Local MCP server

```powershell
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:

```powershell
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.

## 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.