home / mcp / google ad manager mcp server

Google Ad Manager MCP Server

This read-only MCP Server allows you to connect to Google Ad Manager data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for Google Ad Manager (https://www.cdata.com/drivers/dfp/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-google-ad-manager-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/google-ad-manager.prp"
      ]
    }
  }
}

You will run a read-only MCP server that exposes Google Ad Manager data through a simple MCP interface. This server lets large language models query live data supported by the CData JDBC Driver, enabling natural language questions like what opportunities are open or which accounts fall into a given category, without writing SQL.

How to use

You interact with the MCP server through an MCP client. After you configure and start the server, your client can retrieve data by asking natural language questions. Use the built-in tools to read data from Google Ad Manager, and leverage the server’s read-only access to understand live information such as campaigns, reports, and related objects. You do not need to write SQL; you simply ask the client questions and it uses the server’s exposed tables and columns to fetch results.

How to install

Prerequisites: Java Runtime Environment (JRE) or JDK, and Maven for building the MCP server.

# 1) Clone the MCP server repository
git clone https://github.com/cdatasoftware/google-ad-manager-mcp-server-by-cdata.git
cd google-ad-manager-mcp-server-by-cdata

# 2) Build the server
mvn clean install

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

3) Obtain and install the CData JDBC Driver for Google Ad Manager. Follow the driver’s installation notes and license steps as you would for a typical JDBC driver. This enables the MCP server to connect to Google Ad Manager data sources.

4) Create the MCP connection profile. You will generate a .prp file with the JDBC connection details including the DriverPath, DriverClass, and JdbcUrl. The exact values depend on your local installation and connection preferences.

Additional content

5) Start the MCP server using the prepared profile. The server runs through standard input/output (stdio) and is intended to be used with clients on the same machine.

6) Configure your MCP client to discover and connect to the server. You will typically place a config entry pointing to the Java process that runs the MCP JAR and the path to your .prp file. After launching, you may need to restart your client to detect the new MCP server.

Available tools

google_ad_manager_get_tables

Retrieves a list of available tables from Google Ad Manager through the MCP server. The output is CSV with column headers on the first line.

google_ad_manager_get_columns

Retrieves a list of columns for a specified table. The output is CSV with column headers on the first line.

google_ad_manager_run_query

Executes a SQL SELECT query against the exposed data model and returns the result set.