home / mcp / woocommerce mcp server

WooCommerce MCP Server

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

You can query live WooCommerce data with a local, read-only MCP server that exposes the WooCommerce data via the CData JDBC Driver. This setup lets you ask natural language questions and receive live data without writing SQL, making it easier for AI assistants to access up-to-date information from your WooCommerce store.

How to use

Once the MCP server is configured, you can ask your AI client to retrieve data, answer questions, and run read-only operations against WooCommerce data. Typical usage patterns include asking for sales metrics, order counts by status, customer activity over a period, or product inventory snapshots. The server exposes a small set of tools you can call implicitly by asking natural questions, without needing to craft SQL queries.

How to install

Prerequisites: Java and Maven must be installed on your machine.

Clone the project and build the MCP server jar.

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

Additional configuration and running tips

The server is run locally and reads a .prp configuration file that describes the JDBC connection and the data source. You will need to license the CData JDBC Driver, configure a connection, and create a .prp file for the JDBC connection. Placeholders are shown in examples below; replace them with your actual paths and connection details.

To start the MCP server, use the following runtime command. This runs the MCP server in stdio mode on the local machine and points it at your .prp file that defines the WooCommerce connection.

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

Notes on configuration flow

1) Install and license the CData JDBC Driver for WooCommerce. 2) Use the JDBC Driver’s connection utility to create and test a connection string. 3) Create a properties file (woocommerce.prp) with fields such as Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl. 4) Run the MCP server with the created .prp file.

Here is the typical .prp structure you would fill in with your actual values.

Prefix=woocommerce
ServerName=CDataWooCommerce
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.woocommerce.jar
DriverClass=cdata.jdbc.woocommerce.WooCommerceDriver
JdbcUrl=jdbc:woocommerce:InitiateOAuth=GETANDREFRESH;
Tables=

Available tools

woocommerce_get_tables

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

woocommerce_get_columns

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

woocommerce_run_query

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