Developer builds MCP server connecting 18 e-commerce tools to Claude
What this MCP server does
A developer built a Model Context Protocol (MCP) server that connects 18 different e-commerce tools and platforms to Claude, allowing users to query data across multiple systems simultaneously. Instead of manually checking separate dashboards for Shopify, Klaviyo, Google Analytics, Triple Whale, Gorgias, and Xero, users can ask Claude questions that cross-reference data between these sources.
Key capabilities and queries
The MCP server enables queries like:
- "Which Klaviyo campaigns drove the most Shopify orders this month?"
- "Compare my Google Ads ROAS to my Meta Ads ROAS"
- "Show me outstanding Xero invoices over 60 days and my current cash position"
- "What's my shipping margin - am I making or losing money on shipping via ShipStation?"
- "Which products have the highest refund rate and worst reviews?"
The developer notes that "cross-references data between sources in one query" is the key functionality that no single dashboard can provide.
Technical implementation details
The entire codebase was built with Claude Code (Opus), including:
- Full-stack development: React Router app, Prisma schema
- OAuth flows for Google, Xero, Meta, and Shopify
- API clients for all 18 data sources
- The MCP server itself with 30+ tools
- Stripe billing with seats, invoices, and subscription gating
- Email verification, Google login, password reset
- Marketing site with SEO, blog with MDX, and live demo
- Referral program
The developer ported a Xero integration from another project by having Claude read the source code and adapt it. The development process involved the developer acting as product owner and QA, testing features, reporting bugs, and having Claude fix them. The developer describes the back-and-forth as "remarkably efficient," with examples like "fly logs show this error" → Claude reads the logs → identifies the issue → fixes it in one go.
Supported platforms and access
The MCP server currently supports: Shopify, Klaviyo, Google Analytics, Google Ads, Google Search Console, Triple Whale, Gorgias, Recharge, Xero, ShipStation, Meta Ads, Microsoft Clarity, YouTube, Judge.me, Yotpo, Reviews.io, Smile.io, and Swish.
It works with Claude.ai via Connectors by pasting the MCP URL, and also works with Claude Desktop and Claude Code. There's a live demo available at https://ask-ai-data-connector.co.uk/demo where users can try it with simulated data without signing up.
📖 Read the full source: r/ClaudeAI
👀 See Also
Tastebud Memory: Reversible Agent Memory via Hyperdimensional Computing Vectors
Hyperdimensional computing replaces vector search for complete recall: list ALL days touching a project, detect unnamed workstreams, and decompose daily logs losslessly via dot products.
Claudraband: Terminal Wrapper for Persistent Claude Code Sessions
Claudraband wraps the official Claude Code TUI in a controlled terminal to enable resumable workflows, remote session control via HTTP daemon, and ACP server integration for alternative frontends like Zed or Toad. It requires Node.js/Bun, authenticated Claude Code, and tmux for first-class local workflows.
Kvaser: An Open-Source Local-First AI Orchestrator with Sub-Agent Routing and Wolfram Integration
Kvaser is a Man-in-the-Middle MCP proxy that orchestrates sub-agents with smart tool whitelisting, zero-embedding RAG via Kiwix, and Wolfram Engine integration for symbolic math. Built with Qwen 3.6 35B and sub-agent routing to different models/machines.
Dual-model architecture reduces token consumption by half for long conversations
A developer built a dual-model system where a small 'subconscious' model compresses conversation history in the background, allowing the main model to work with a curated ~35K context instead of 120K tokens of raw history. This architecture cuts token consumption roughly in half for sustained project work.