Skip to main content
Glama
mvacha

shopify-reports-mcp

by mvacha
OverviewSchemaRelated ServersScoreDiscussions
TypeScript

shopify-reports-mcp

An MCP server that lets AI agents query Shopify analytics with ShopifyQL via the Admin GraphQL shopifyqlQuery endpoint. Ask your agent "show me the products with the highest margins" — it writes the ShopifyQL, runs it through this server, and interprets the results.

Tools

  • query_shopify — executes a ShopifyQL query, returns { columns, rows } as JSON. Parse errors come back as error results so the agent can self-correct and retry.

  • shopifyql_reference — returns the bundled ShopifyQL reference (syntax, schemas, columns, examples). Also exposed as the MCP resource shopifyql://reference.

Related MCP server: Shopify MCP Server

Shopify prerequisites

  1. Create an app in your organization's Dev Dashboard (the client-credentials grant only works for org-owned apps installed on stores your org owns).

  2. Grant it the read_reports access scope (plus customer-data access if you want to query customer PII columns).

  3. Install the app on your store and note the Client ID and Client Secret.

Access tokens are exchanged automatically and cached for their full 24-hour lifetime.

Running

Via npx (no clone needed)

Run straight from GitHub — npm clones, builds, and caches the package on first use:

# stdio mode
npx --yes github:mvacha/shopify-reports-mcp --stdio \
  --shop yourstore.myshopify.com \
  --client-id <client id> \
  --client-secret <client secret>

# HTTP mode
npx --yes github:mvacha/shopify-reports-mcp --http --port 3000

Claude Code one-liner:

claude mcp add shopify-reports -- npx --yes github:mvacha/shopify-reports-mcp --stdio \
  --shop yourstore.myshopify.com --client-id <client id> --client-secret <client secret>

Claude Desktop config (claude_desktop_config.json):

{
  "mcpServers": {
    "shopifyReports": {
      "command": "npx",
      "args": [
        "--yes",
        "github:mvacha/shopify-reports-mcp",
        "--stdio",
        "--shop", "yourstore.myshopify.com",
        "--client-id", "<client id>",
        "--client-secret", "<client secret>"
      ]
    }
  }
}

HTTP mode (primary)

npm install && npm run build
node dist/index.js --http --port 3000

Clients authenticate by sending their Shopify credentials with every request:

{
  "mcpServers": {
    "shopify-reports": {
      "type": "http",
      "url": "http://your-host:3000/mcp",
      "headers": {
        "X-Shopify-Shop": "yourstore.myshopify.com",
        "X-Shopify-Client-Id": "<client id>",
        "X-Shopify-Client-Secret": "<client secret>"
      }
    }
  }
}

Or with the Claude Code CLI:

claude mcp add --transport http shopify-reports http://your-host:3000/mcp \
  --header "X-Shopify-Shop: yourstore.myshopify.com" \
  --header "X-Shopify-Client-Id: <client id>" \
  --header "X-Shopify-Client-Secret: <client secret>"

Requests without all three headers are rejected with 401. The server is stateless and multi-tenant: different clients can point it at different stores.

stdio mode (local testing)

{
  "mcpServers": {
    "shopify-reports": {
      "command": "node",
      "args": [
        "/path/to/shopify-reports-mcp/dist/index.js",
        "--stdio",
        "--shop", "yourstore.myshopify.com",
        "--client-id", "<client id>",
        "--client-secret", "<client secret>"
      ]
    }
  }
}

The SHOPIFY_SHOP, SHOPIFY_CLIENT_ID and SHOPIFY_CLIENT_SECRET environment variables work as fallbacks for the CLI flags.

Development

npm test        # vitest unit tests (mocked Shopify API)
npm run dev     # run from source with tsx
npm run build   # compile to dist/

Design doc: docs/superpowers/specs/2026-07-21-shopify-reports-mcp-design.md.

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivitySlowing
ResponsivenessSyncing

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • Shopify MCP Server

    hamzashahbaz
    A
    license
    A
    quality
    D
    maintenance
    Provides AI assistants with real-time access to Shopify store analytics, sales data, and inventory through ShopifyQL and the Admin GraphQL API. It enables users to query store performance, customer metrics, and marketing insights using natural language.
    13
    MIT

  • shopify

    AIWerk
    A
    license
    A
    quality
    C
    maintenance
    Enables AI agents to read and write Shopify store data including products, orders, customers, inventory, and more via the Admin GraphQL API.
    28
    82
    MIT

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/mvacha/shopify-reports-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server