# Ecommerce MCP Server

> Ecommerce MCP Server — ethan-shapiro-ecommerce-mcp-server. Use this tool when you need to efficiently query large ecommerce datasets, such as TheLook, to retrieve specific information without compromising data security. It solves problems related to data access and retrieval, providing a guarded and read-only interface through SQL tools like dry_run_sql and execute_sql. Ideal for use cases requiring fast and reliable data lookup, bypassing traditional wiki-style documentation methods.

Canonical page: https://skillsregistry.net/skills/ethan-shapiro-ecommerce-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/ethan-shapiro-ecommerce-mcp-server

## Description

Enables AI agents to query BigQuery ecommerce datasets like TheLook via guarded, read-only SQL tools (dry_run_sql and execute_sql), with benchmarked performance over wiki-style documentation lookup.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-08-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-08-28

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/uwyqsrml2t)
- **Repository:** <https://github.com/Ethan-Shapiro/Ecommerce-MCP-Server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "ethan-shapiro-ecommerce-mcp-server"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/ethan-shapiro-ecommerce-mcp-server` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/ethan-shapiro-ecommerce-mcp-server/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt