Google Ad Manager MCP Server by CData

What is Google Ad Manager MCP Server by CData?

This read-only MCP server allows LLMs like Claude Desktop to query live data from Google Ad Manager using natural language. It wraps the CData JDBC Driver for Google Ad Manager, exposing the data as relational SQL models through a simple MCP interface.

How to use Google Ad Manager MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Google Ad Manager, then configure a connection string using the driver's utility. Create a .prp file with the JDBC URL and other properties, then add the server to your Claude Desktop config file. The server uses stdio transport and must run on the same machine as the client.

Key features of Google Ad Manager MCP Server by CData

• Provides a read-only MCP interface to Google Ad Manager data
• Exposes tools: get_tables, get_columns, and run_query (SELECT only)
• Outputs results in CSV format
• No SQL required – query with natural language
• Built on the CData JDBC Driver for Google Ad Manager

Use cases of Google Ad Manager MCP Server by CData

• Ask natural language questions about Google Ad Manager data
• Retrieve ad inventory, performance metrics, or reports without writing SQL
• Explore available tables and columns in Google Ad Manager

FAQ from Google Ad Manager MCP Server by CData

How does this server differ from the full CData MCP Server for Google Ad Manager?

This project is a read-only MCP server. For full read, write, update, delete, and action capabilities with a simplified setup, use the free CData MCP Server for Google Ad Manager (beta) from CData’s website.

What are the runtime requirements?

You need Java, Maven, and the CData JDBC Driver for Google Ad Manager installed and licensed. A trial license is available for testing.

How does authentication work?

OAuth is used. During connection string configuration, the driver opens a browser for authentication. The connection string includes InitiateOAuth=GETANDREFRESH.

What transport does the server use?

The server uses stdio transport, so it can only be used with clients running on the same machine.

Can I write or modify data in Google Ad Manager?

No. This server is read-only; it only supports SELECT queries. For write operations, use the full CData MCP Server beta.