WooCommerce MCP Server by CData
@CDataSoftware
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for WooCommerce (beta): https://www.cdata.com/download/download.aspx?sku=UZZK-V&type=beta
Overview
What is WooCommerce MCP Server by CData?
This read-only MCP Server allows LLMs (like Claude Desktop) to query live WooCommerce data using natural language, powered by the CData JDBC Driver for WooCommerce.
How to use WooCommerce MCP Server by CData?
Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for WooCommerce, configure a connection string, then create a .prp file with properties. Add the server to Claude Desktop’s claude_desktop_config.json and restart the client.
Key features of WooCommerce MCP Server by CData
- Read-only queries to live WooCommerce data.
- Exposes WooCommerce as relational SQL models.
- Provides three tools:
get_tables,get_columns,run_query. - Outputs results in CSV format.
- Uses stdio transport (client on same machine).
Use cases of WooCommerce MCP Server by CData
- Ask an LLM about product inventory or order history.
- Correlate sales data with customer segments.
- Retrieve live WooCommerce data without SQL.
FAQ from WooCommerce MCP Server by CData
Is this server read-only?
Yes, this MCP server is read-only. For full create, read, update, delete, and action capabilities, see the CData MCP Server for WooCommerce (beta).
What dependencies are required?
Java (to run the JAR), Maven (to build), and the CData JDBC Driver for WooCommerce (must be downloaded and licensed separately).
Where does the data live?
The server connects to your WooCommerce instance via the JDBC driver; data remains in WooCommerce – it is not stored locally.
How do I authenticate?
Authentication depends on the WooCommerce setup. The CData JDBC Driver supports OAuth if required; use the connection string utility to configure it.
What transport does the server use?
It uses stdio, so the MCP client must be on the same machine as the server.
