MCP server
CData WooCommerce MCP Server
Local read-only MCP server that exposes WooCommerce data as SQL tables via the CData JDBC driver so AI clients can list tables, columns and run SELECT queries.
Repository and documentation last checked Built from public product pages and documentation. SourcesClaim this listing
ecommerceguide summary
CData WooCommerce MCP Server runs locally and exposes a WooCommerce store as SQL tables through the CData JDBC driver, so an AI client can list tables, list columns and run SELECT queries against catalogue, order and customer records. Access is read-only and communicates over stdio. The server is Java source cloned from GitHub and built with Maven, licensed MIT; the JDBC driver needs a licence key or TRIAL. Setup steps cover Claude Desktop.
Why it stands out
Published by CData and built on its WooCommerce JDBC driver, so store data reaches MCP clients as relational SQL tables.
What CData WooCommerce MCP Server does
ecommerceguide editorial- Three tools: get_tables, get_columns and run_query (SQL SELECT only)
- Read-only; no writes to the WooCommerce store
- Local stdio server, so client and server share one machine
- Built from source with git clone and mvn clean install
- Connection set in a .prp file with the JDBC connection string
- Driver licensing uses a key or TRIAL; connection may require browser OAuth
- Maintained by CData Software, Inc.; MIT licence, Java
How ecommerce teams could use it
ecommerceguide editorialIllustrative scenarios written by ecommerceguide from the product's documented capabilities. They are not customer case studies.
A WooCommerce store's operations team using Claude Desktop
Answering ad hoc questions about orders and customers without writing SQL
Intended outcomeThe server lists available tables and columns, then runs SELECT queries against live WooCommerce data and returns the rows to the client.
An analyst working with a WooCommerce catalogue
Checking which fields and tables exist before building reports elsewhere
Intended outcomeget_tables and get_columns return the schema in CSV form, so field names can be confirmed from inside the AI client.
A developer scripting against a WooCommerce store
Calling the server directly instead of through an AI client
Intended outcomeJSON-RPC 2.0 requests invoke get_tables, get_columns and run_query over stdio, with the README giving example payloads.
Who it suits
ecommerceguide editorialBest for
You run WooCommerce, use Claude Desktop, and want read-only SQL queries over store data from a local server you build yourself.
Probably not for
You need writes to WooCommerce, a remote hosted endpoint, or a server that installs without building Java source and licensing a JDBC driver.
- Business size
- Any stageNo revenue, order or team bounds are stated; the requirement is a WooCommerce store, the CData JDBC driver and a local MCP client.
Technical details
From the vendor's own pagesFrom the server's repository, documentation and MCP directory listings.
- What an agent can do
- Manage products, Orders, Customers, Analytics
- Transport
- stdio (local)
- Authentication
- API key, OAuthLicense the JDBC driver with a license key or TRIAL; connection string may require browser OAuth authentication.
- Package
- woocommerce-mcp-server-by-cdata
- Language
- Java
- Licence
- MIT
- Repository last updated
- 18 Oct 2025
Connect CData WooCommerce MCP Server
Third-party dataSetup documented for
git clone https://github.com/cdatasoftware/woocommerce-mcp-server-by-cdata.git && mvn clean installCommand as listed on the repository README, not tested by ecommerceguide. Check the official documentation (opens in a new tab) for configuration and credentials before running it.
Works with
Often used alongside
ecommerceguide editorialGorgiasConversational AI platform for ecommerce, automating support and driving sales.Why togetherGorgias handles customer tickets for a WooCommerce store while this server answers internal questions from the store's order and customer tables.
Tidio ‑ Live Chat & AI ChatbotImprove customer experience with a chatbot, AI agent, and live chat in one help desk for your store.Why togetherTidio runs shopper-facing chat on WooCommerce; this server gives the same team read-only SQL queries over store data in Claude Desktop.
eDesk ‑ AI, Helpdesk & ChatAI-powered customer service designed for eCommerce.Why togethereDesk centralises customer messages from a WooCommerce store, and this server lets the team query the underlying order and customer data.
Categories and use cases
Alternatives to CData WooCommerce MCP Server
Listings that share this one's category, platforms or use cases. Ordered by how many relationships they share, not by quality or payment.
- IOio.github.AmitGurbani/mcp-server-woocommercemanage WooCommerce products, orders, customers, and coupons via AI assistants like Claude
- WMWooCommerce MCP ServerAPI Integration & Management
- W&WordPress & WooCommerceMCP server to manage WordPress posts, WooCommerce orders, products, and store settings via API
- WOwordpress-mcpLightweight WordPress MCP server for site management.
- WMWordPress MCP ServerAI-Powered Site & E-commerce Control
Sources
ecommerceguide profiles are built from public product information and written for ecommerce teams. We do not test products, and paying never changes where a listing ranks.
Also listed on mcpservers.org.
See something incorrect? Report an update