snapchat-ads -by-cdata

This MCP server provides read-only access to Snapchat Ads data via the CData JDBC Driver. It wraps the driver in a simple MCP interface so large language models can query live Snapchat Ads information without writing SQL. The server runs as a Java application and uses a .prp property file to configure the JDBC connection and the exposed tools. Once configured, you can interact with it through Claude Desktop or any compatible MCP client that supports JSON-RPC style tool calls. The built-in tools allow you to discover available tables, inspect columns, and run read-only queries against the data source.

Prerequisites:

• Java (JDK 8 or newer) installed and available on the command line
• Maven installed for building the MCP server
• Permission to write to a local directory to store the JAR and the .prp file

Step-by-step:

1. Clone the repository and build the MCP server

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

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

2. Download and install the CData JDBC Driver for Snapchat Ads

• Visit: https://www.cdata.com/drivers/snapchatads/download/jdbc
• Install the driver according to your OS. License the driver as required:

java -jar cdata.jdbc.snapchatads.jar --license

3. Configure the connection and create the .prp file

• Run the driver’s connection string utility to generate a JDBC URL that points to Snapchat Ads (OAuth may require browser authentication).
• Create a .prp file (e.g. snapchat-ads.prp) with your connection details, for example:

Prefix=snapchatads
ServerName=CDataSnapchatAds
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.snapchatads.jar
DriverClass=cdata.jdbc.snapchatads.SnapchatAdsDriver
JdbcUrl=jdbc:snapchatads:InitiateOAuth=GETANDREFRESH;
Tables=

4. Run the MCP Server

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/snapchat-ads.prp

Note: The server uses standard input/output (stdio), so it is designed to work with local clients on the same machine.

Tips and notes:

• This MCP server is read-only by design. If you need write or delete capabilities, you would typically configure a different MCP setup or use a fully remote/powered MCP platform.
• The server runs via stdio; ensure your client supports local IPC when deploying on the same host.
• If Claude Desktop cannot see the MCP server, fully quit and relaunch Claude Desktop so it detects new config entries. Ensure the claude_desktop_config.json file includes an entry matching the server name used in your mcpServers configuration.
• Keep your JDBC Driver license details valid to avoid connection failures. If OAuth is required, authenticate in the browser when prompted by the driver utility.
• If you modify the .prp file, you will typically need to restart the MCP server for changes to take effect.