home / mcp / google ads mcp server

Google Ads MCP Server

Provides live Google AdWords data through a read-only MCP interface for querying campaigns, keywords, and performance data.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

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

This MCP Server lets you query live Google AdWords data through a simple MCP interface. It wraps the CData JDBC Driver for Google AdWords so your AI client can read data in natural language without writing SQL, while running locally on your machine.

How to use

You configure the MCP server once, then connect your MCP-capable client to it. After it's running, you can ask questions like you would about any data source: explore tables, inspect columns, and read records. The server exposes dedicated tools that let your client discover available tables and columns, and run queries to retrieve data. Because this setup is local, you can query data in real time and use natural language to obtain the exact information you need.

How to install

# Prerequisites
# 1) Install Java Development Kit (JDK 8+)
# 2) Install Maven
# 3) Ensure mvn is in your PATH

# 1. Clone the MCP server repo and enter the directory

git clone https://github.com/cdatasoftware/google-adwords-mcp-server-by-cdata.git
cd google-adwords-mcp-server-by-cdata

# 2. Build the MCP server jar
mvn clean install
# This creates CDataMCP-jar-with-dependencies.jar

# 3. Install the CData JDBC Driver for Google AdWords
# Download from: https://www.cdata.com/drivers/adwords/download/jdbc

# 4. License the CData JDBC Driver
# Navigate to the driver's lib folder and run the license command
java -jar cdata.jdbc.googleads.jar --license
# Enter your name, email, and TRIAL (or your license key)

# 5. Configure the connection to Google AdWords
# Open the Connection String utility
java -jar cdata.jdbc.googleads.jar
# Test the connection, authenticate if OAuth is required, and copy the connection string

# 6. Create a .prp file for the JDBC connection
# Example content (save as google-adwords.prp):
Prefix=googleads
ServerName=CDataGoogleAds
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.googleads.jar
DriverClass=cdata.jdbc.googleads.GoogleAdsDriver
JdbcUrl=jdbc:googleads:InitiateOAuth=GETANDREFRESH;
Tables=

# 7. Run the MCP server using the .prp file
# The final run command will be provided in the next step
```

"},{"type":"paragraph","text":"Note: The typical flow is to install Java and Maven, build the MCP server JAR, license and configure the CData JDBC Driver for Google AdWords, create the .prp connection file, and then start the MCP server with that file.","items":null,

Available tools

googleads_mcp_get_tables

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

googleads_mcp_get_columns

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

googleads_mcp_run_query

Executes a SQL SELECT query against the Google AdWords data source and returns the results.