home / mcp / shopify mcp server

Shopify MCP Server

This read-only MCP Server allows you to connect to Shopify data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-shopify-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/shopify.prp"
      ]
    }
  }
}

You can run a read-only MCP server that exposes live Shopify data via the CData JDBC Driver. This server lets you ask natural-language questions and receive up-to-date results from Shopify without writing SQL. It wraps the JDBC driver and exposes a simple MCP interface that client applications can query locally.

How to use

After you start the MCP server, you can use an MCP client to read data from Shopify. Ask questions like which accounts have the highest open orders, or how many customers placed orders in the last 30 days. The server provides built-in tools to list available tables and columns and to run queries against Shopify data. You don’t need to write SQL queries yourself unless you want to; simply request information in natural language and the client translates it to the underlying queries.

How to install

Prerequisites: Java and Maven are required to build and run the MCP server.

git clone https://github.com/cdatasoftware/shopify-mcp-server-by-cdata.git
cd shopify-mcp-server-by-cdata
mvn clean install

Obtain and license the CData JDBC Driver for Shopify from the vendor. The driver is necessary to connect to Shopify data.

https://www.cdata.com/drivers/shopify/download/jdbc

License the driver using the driver jar. Follow these steps exactly as shown.

java -jar cdata.jdbc.shopify.jar --license

Configure a connection to Shopify. Use the Connection String utility to generate a JDBC URL, then save it for the next step.

java -jar cdata.jdbc.shopify.jar

Create a .prp configuration file with the JDBC details. Adjust paths to your environment.

env
Prefix=shopify
ServerName=CDataShopify
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.shopify.jar
DriverClass=cdata.jdbc.shopify.ShopifyDriver
JdbcUrl=jdbc:shopify:InitiateOAuth=GETANDREFRESH;
Tables=

Running the server

Start the MCP server using the prepared .prp file. The server runs locally (stdio) and can be accessed by a local MCP client.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/shopify.prp

Notes and usage tips

The MCP server exposes a small set of tools for interacting with Shopify data. You can request a list of available tables and columns, or run a SELECT-like query through the MCP interface. No SQL is required for simple queries when using an MCP client that translates your natural-language requests into the underlying operations.

Available tools

shopify_get_tables

Retrieves a list of tables available in the data source. Output is provided in CSV format with the first line containing column headers.

shopify_get_columns

Retrieves a list of columns for a specified table. Output is CSV with headers on the first line.

shopify_run_query

Executes a SQL SELECT query against the connected Shopify data source.