home / mcp / snapchat ads mcp server

Snapchat Ads MCP Server

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

You can query live Snapchat Ads data through a local MCP server that exposes the Snapchat Ads data as relational models via a simple MCP interface. This enables AI assistants to read Snapchat Ads information in real time without writing SQL, making it easy to answer questions about your data directly from natural language.

How to use

You will connect your MCP client to a local MCP server that serves Snapchat Ads data. Start the local server and point your MCP client to it. Use built‑in tools to list available tables and columns, run read‑only queries, and fetch data for your questions. For example, you can ask things like which ad campaigns are performing best this quarter, what are the top creative assets by spend, or how many campaigns are currently active.

How to install

Prerequisites: Ensure you have Java installed on your machine. You may also want Maven if you intend to build the MCP server from source.

# Optional: clone the project and build the MCP server (if starting from source)
# git clone https://github.com/cdatasoftware/snapchat-ads-mcp-server-by-cdata.git
# cd snapchat-ads-mcp-server-by-cdata
# mvn clean install

# Start the MCP server using the prebuilt JAR and a prepared .prp connection file
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/snapchat-ads.prp

Additional configuration and usage notes

This server is designed to be run locally and queried by an MCP client on the same machine. The setup includes creating a .prp file that defines your JDBC connection to Snapchat Ads via the CData JDBC Driver, and then running the MCP server with that configuration.

If you need to enable the MCP server from your client, use the following configuration to launch the server process from the client side.

MCP server configuration (stdio)

{
  "mcpServers": {
    "snapchat_ads": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/snapchat-ads.prp"
      ]
    }
  }
}

Troubleshooting

If you cannot see the MCP server in your client, ensure you have fully quit and restarted the client so it detects newly created MCP servers. Verify that the .prp file path is correct and that the Java process is running the MCP JAR against the right configuration file. If data cannot be retrieved, double‑check your JDBC connection string and ensure the Snapchat Ads driver is licensed and accessible on your machine.

Available tools

snapchat_ads_get_tables

Retrieves a list of tables (data sources) available from Snapchat Ads through the MCP server. Output is a CSV with column headers in the first line.

snapchat_ads_get_columns

Retrieves a list of columns for a specified table. Output is a CSV with column headers in the first line.

snapchat_ads_run_query

Executes a SQL SELECT query against the Snapchat Ads data exposed by the MCP server and returns the result set.