eBay Analytics

You can query live eBay Analytics data through a read-only MCP server that wraps the CData JDBC Driver. This server exposes eBay Analytics data via MCP tools so you can ask natural language questions and receive live results without writing SQL.

How to use

You connect your MCP client (for example, Claude Desktop or another compatible AI client) to the MCP server to access live eBay Analytics data. After the server is running, you simply ask questions like “What is the correlation between my closed won opportunities and the account industry?” or “How many open tickets do I have in the SUPPORT project?” The server handles the underlying data access, exposing tables and columns through the defined tools so you can read data and run queries without writing SQL.

How to install

# Prerequisites: Java and Maven should be installed on your machine
# 1. Clone the project
git clone https://github.com/cdatasoftware/ebay-analytics-mcp-server-by-cdata.git
cd ebay-analytics-mcp-server-by-cdata

# 2. Build the server
mvn clean install

# This creates the JAR: CDataMCP-jar-with-dependencies.jar

# 3. Install the CData JDBC Driver for eBay Analytics
# Download and install from the official CData source (driver is named cdata.jdbc.ebayanalytics.jar)

# 4. License the CData JDBC Driver
# Windows example path shown for reference; adjust to your platform
# Run this in the installation lib folder and provide your name, email, and license (TRIAL or key)
java -jar cdata.jdbc.ebayanalytics.jar --license

# 5. Configure your connection to the data source
# Open the Connection String utility to test and copy the connection string
java -jar cdata.jdbc.ebayanalytics.jar

# If OAuth is used, authenticate in your browser and complete the test

# 6. Create a .prp file for your JDBC connection
# Example (ebay-analytics.prp):
Prefix=ebayanalytics
ServerName=CDataeBayAnalytics
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.ebayanalytics.jar
DriverClass=cdata.jdbc.ebayanalytics.eBayAnalyticsDriver
JdbcUrl=jdbc:ebayanalytics:InitiateOAuth=GETANDREFRESH;
Tables=

Additional configuration and running notes

You will use a PRP file that contains the JDBC connection details. This file is referenced when you start the MCP server. Ensure the path in the command matches where you saved ebay-analytics.prp.

Running the server and connecting clients

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/ebay-analytics.prp

Note: The server runs in stdio mode, so it can be used with clients executing on the same machine.

## Troubleshooting

If you cannot see the MCP server in your client, make sure you completely quit the client and restart it so the server appears. Verify that the JDBC connection is configured correctly using the Connection String utility and that the .prp file contains the correct JdbcUrl and driver information. If you still have issues, contact the CData Support Team or join the CData Community for help.

## Notes

This MCP server is read-only and intended to enable live data access for natural language queries. For full read, write, update, delete, and action capabilities, check out the full MCP Server for eBay Analytics.

## Tools and endpoints

The server exposes a small set of tools to interact with data sources, including retrieving available tables, listing columns for a table, and running queries. These tools are named using the server prefix and follow the pattern `prefix_get_tables`, `prefix_get_columns`, and `prefix_run_query`.

## Security and licensing

Ensure you license the JDBC driver and protect your connection details. Use secure storage for the .prp file and avoid exposing credentials in shared environments.

## License

This MCP server is licensed under the MIT License. You are free to use, modify, and distribute the software, subject to the terms of the MIT License.

## Available tools

### ebayanalytics\_get\_tables

Retrieves a list of tables available in the data source. The output is in CSV format with the first line containing column headers.

### ebayanalytics\_get\_columns

Retrieves a list of columns for a specific table. The output is in CSV format with the first line containing column headers.

### ebayanalytics\_run\_query

Executes a SQL SELECT query against the data source via the MCP server.