home / mcp / adobecommerce mcp server

AdobeCommerce MCP Server

This read-only MCP Server allows you to connect to Adobe Commerce 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-adobe-commerce-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/adobe-commerce.prp"
      ]
    }
  }
}

You run a read-only MCP server that exposes live Adobe Commerce data via a simple MCP interface. This lets you ask natural language questions and retrieve up-to-date data without writing SQL, while keeping the underlying data source secure and centralized for querying by your AI client.

How to use

Use an MCP client to connect to the local MCP server over stdio. Start the server on your machine and point your client to the server process. You can then ask questions like “What is the current open opportunities by region?” or “Show me the number of active orders in the last 24 hours.” The built-in tools let you inspect the data model, list tables, view columns, and run SQL queries under the hood. No SQL knowledge is required for typical queries.

How to install

# Prerequisites: ensure Java is installed
java -version

# 1) Build the MCP server JAR
mvn clean install

# 2) Ensure the CData JDBC Driver for Adobe Commerce is installed and licensed
# 3) Create a JDBC connection properties file (example Adobe Commerce)
# 4) Start the MCP server using a prepared .prp file

Additional configuration and usage notes

The MCP server runs locally and communicates using stdio with the client. To start the server you run a command that references a prepared property file (for example, adobe-commerce.prp) generated during configuration. You can reuse the same workflow to connect Claude Desktop or other MCP clients by supplying the correct path to the .prp file.

Available tools

adobecommerce_mcp_get_tables

Retrieves a list of tables available in the data source. Output is CSV with a header row of column names.

adobecommerce_mcp_get_columns

Retrieves a list of columns for a specified table. Output is CSV with a header row of column names.

adobecommerce_mcp_run_query

Executes a SQL SELECT query against the Adobe Commerce data source and returns results.