by n0119566
TypeScript REST API ecommerce API, customer data API and orders API — retrieve customers, search by name, and lookup ord
Connects to e-commerce databases to retrieve customer information and order data through a REST API interface.
Store (E-Commerce) is a community-built MCP server published by n0119566 that provides AI assistants with tools and capabilities via the Model Context Protocol. TypeScript REST API ecommerce API, customer data API and orders API — retrieve customers, search by name, and lookup ord It is categorized under databases, developer tools.
You can install Store (E-Commerce) in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.
MIT
Store (E-Commerce) is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.
Enable Claude to query your database directly using natural language
Example
Ask 'Show me top 10 customers by revenue this month' and get SQL results instantly
Eliminate manual SQL writing for ad-hoc queries, get insights 10x faster
Generate complex reports and analytics without leaving conversation
Example
Analyze sales trends, cohort retention, user behavior patterns conversationally
Democratize data access—non-technical team members can query databases
Understand database structure, relationships, and data models
Example
'Explain the user_orders table schema and its relationships'
Onboard engineers faster, explore unfamiliar databases efficiently
Share your MCP server with the developer community
I recommend Store (E-Commerce) for teams standardizing on MCP; the explainx.ai page compares cleanly with sibling servers.
According to our notes, Store (E-Commerce) benefits from clear Model Context Protocol framing — fewer ambiguous “AI plugin” claims.
Useful MCP listing: Store (E-Commerce) is the kind of server we cite when onboarding engineers to host + tool permissions.
According to our notes, Store (E-Commerce) benefits from clear Model Context Protocol framing — fewer ambiguous “AI plugin” claims.
Useful MCP listing: Store (E-Commerce) is the kind of server we cite when onboarding engineers to host + tool permissions.
Strong directory entry: Store (E-Commerce) surfaces stars and publisher context so we could sanity-check maintenance before adopting.
Useful MCP listing: Store (E-Commerce) is the kind of server we cite when onboarding engineers to host + tool permissions.
According to our notes, Store (E-Commerce) benefits from clear Model Context Protocol framing — fewer ambiguous “AI plugin” claims.
Strong directory entry: Store (E-Commerce) surfaces stars and publisher context so we could sanity-check maintenance before adopting.
I recommend Store (E-Commerce) for teams standardizing on MCP; the explainx.ai page compares cleanly with sibling servers.
showing 1-10 of 57
A Model Context Protocol (MCP) server for retrieving customer and order information from a store API.
This project implements a Model Context Protocol server that provides tools for interacting with a store's customer and order data. It allows Claude to:
# Clone the repository
git clone <repository-url>
cd mcp-store
# Install dependencies
npm install
# Build the project
npm run build
The MCP server provides the following tools:
Returns a list of all customers in the store database.
Searches for customers by name and returns all matching results.
Parameters:
customerName: The name to search forRetrieves all orders placed by a specific customer.
Parameters:
customerId: The unique identifier for the customerThe server works with the following data models:
interface ICustomer {
name: string;
email: string;
phone?: string;
address?: {
street?: string;
city?: string;
state?: string;
zip?: string;
country?: string;
};
createdAt?: Date;
}
interface IOrder {
customer: string;
items: IOrderItem[];
totalAmount: number;
status?: "pending" | "processing" | "shipped" | "delivered" | "cancelled";
paymentMethod?: "credit_card" | "debit_card" | "paypal" | "cash";
createdAt?: Date;
}
interface IOrderItem {
product: string;
quantity: number;
price: number;
}
interface IProduct {
name: string;
description?: string;
price: number;
category?: string;
inStock?: boolean;
createdAt?: Date;
}
To work on this project:
src directorynpm run buildISC
Run data quality queries to catch anomalies and inconsistencies
Example
Find duplicate records, missing values, orphaned foreign keys automatically
Maintain data integrity with less manual SQL work
Prerequisites
Time Estimate
15-30 minutes including configuration and testing
Steps
Troubleshooting
✓ Do
✗ Don't
💡 Pro Tips
Architecture
MCP server acts as bridge between Claude and database, translating natural language to SQL queries and returning results in structured format.
Protocols
Compatibility
✓ Use when
Use for ad-hoc data queries, exploratory analysis, report generation, schema exploration, and democratizing data access. Best for read-heavy analytics workloads.
✗ Avoid when
Avoid for production write operations, mission-critical transactions, real-time OLTP workloads, or when database contains sensitive PII without proper access controls. Use read replicas, not primary.