Google Ads

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

other

0

GitHub Stars

other

Language

4 months ago

First Indexed

3 weeks ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

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.