ecommerce-mcp

MCP server for commerce-operations self-service. Lets an AI agent look up order details and search orders without needing developer or SQL access.

Quick Start

# Install deps
npm install

# Seed the database
npm run seed

# Build
npm run build

# Run dev
npm run dev

MCP Tools

• get_order(orderId) — Look up a single order by ID (e.g. ORD-001). Returns full details including items, tracking, and notes.
• search_orders(filters) — Search orders by status, customer, email, date range. Optionally limit results.

Development

• TypeScript, @modelcontextprotocol/sdk, better-sqlite3
• SQLite database at data/orders.db (committed to repo since it holds only synthetic data)
• MCP communicates over stdio (Cloudflare Tunnel wraps the process for remote access)

Deploy to VPS

# On the VPS
git clone https://github.com/ritz541/ecommerce-mcp.git
cd ecommerce-mcp
npm ci --include=dev
npm run build
npm run seed   # run once after first deploy, or if data needs reset
npm start      # run as a systemd service for production

Cloudflare Tunnel

Add this entry to /etc/cloudflared/config.yml:

ingress:
  - hostname: mcp.chavanpatil.com
    service: http://localhost:8003

Then reload the tunnel: systemctl reload cloudflared.

You'll also need to set up a systemd service for the MCP server so it starts on boot and restarts on failure. Create /etc/systemd/system/ecommerce-mcp.service:

[Unit]
Description=Commerce Operations MCP Server
After=network.target

[Service]
Type=simple
User=root
WorkingDirectory=/root/Code/Projects/github/ecommerce-mcp
ExecStart=/usr/bin/node dist/index.ts
Restart=always
Environment=NODE_ENV=production

[Install]
WantedBy=multi-user.target

Then:

systemctl daemon-reload
systemctl enable ecommerce-mcp
systemctl start ecommerce-mcp

GitHub Actions CI

On push to master, the workflow runs builds and deploys to the VPS via SSH. Set these repository secrets in your GitHub repo settings:

Secret Name	Description
VPS_HOST	VPS IP address (172.236.176.58)
VPS_SSH_KEY	SSH private key (root user)

What's In / Out of Scope

• In: get_order, search_orders, synthetic order data, remote hosting
• Out: Auth, frontend, inventory management, fulfillment tools, real payments, Docker

License

ISC