home / mcp / bigcommerce mcp server

BigCommerce MCP Server

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

You run a local, read-only MCP server that exposes live BigCommerce data via the CData JDBC Driver. This lets you ask natural-language questions and receive up-to-date results without writing SQL. It’s useful for AI assistants to query products, orders, customers, and other BigCommerce data in real time.

How to use

Once the MCP server is running, you connect your MCP client (such as Claude Desktop or another compatible AI client) to the local process. The server exposes live BigCommerce data through a simple MCP interface, so you can ask questions like “What are my open orders this week?” or “Show me customer counts by region.” You typically do not call individual tools directly; instead, your AI client selects the appropriate built-in tools when answering questions about the data source.

How to install

Prerequisites you need before starting are a Java runtime and a Java build tool as appropriate for the project you’re using.

Step 1. Clone the MCP server repository and navigate into it.

git clone https://github.com/cdatasoftware/bigcommerce-mcp-server-by-cdata.git
cd bigcommerce-mcp-server-by-cdata

Step 2. Build the server to create the runnable JAR.

mvn clean install

Step 3. Download and install the CData JDBC Driver for BigCommerce from the official site.

Step 4. License the CData JDBC Driver by running the license command from the driver’s lib folder and entering your user details and license type.

java -jar cdata.jdbc.bigcommerce.jar --license

Step 5. Configure the connection to the BigCommerce data source using the Connection String utility and test the connection. Copy the resulting JDBC URL for later use.

java -jar cdata.jdbc.bigcommerce.jar

Step 6. Create a properties file for the MCP server using the JDBC connection string you obtained. Example (bigcommerce.prp):

Prefix=bigcommerce
ServerName=CDataBigCommerce
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.bigcommerce.jar
DriverClass=cdata.jdbc.bigcommerce.BigCommerceDriver
JdbcUrl=jdbc:bigcommerce:InitiateOAuth=GETANDREFRESH;
Tables=

Additional configuration and running notes

To run the MCP server on its own, use the following command. This starts the server in stdio mode, so it must be used with a client running on the same machine.

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

Note: The example uses Salesforce.prp to illustrate the required format. You can substitute your own configuration file (for BigCommerce) following the same structure.

Troubleshooting tips

If you cannot see the MCP server in your client, make sure you fully quit the client and restart it so the new server appears.

If data cannot be retrieved, verify that the connection string is correct and that the .prp file points to the right JDBC URL and driver JAR.

If you run into connection issues, contact CData Support or ask the CData Community for help.

Available tools

bigcommerce_get_tables

Retrieves a list of tables available in the BigCommerce data source. Output is CSV with headers.

bigcommerce_get_columns

Retrieves a list of columns for a specified table. Output is CSV with headers.

bigcommerce_run_query

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