Google Adwords MCP Server By Cdata

🚀 Google AdWords MCP Server by CData

This project by CData provides a Model Context Protocol (MCP) Server for Google AdWords. It allows LLMs to query live data from Google AdWords without the need for SQL.

:heavy_exclamation_mark: This is a read - only MCP server. For full CRUD and action capabilities, along with a simplified setup, check out our free CData MCP Server for Google AdWords (beta).

🚀 Quick Start

This read - only MCP Server enables LLMs (such as Claude Desktop) to query live data from Google AdWords. It utilizes the CData JDBC Driver for Google AdWords to connect to Google AdWords and expose the data as relational SQL models. The server wraps this driver and offers a simple MCP interface for LLMs to access the data.

✨ Features

• Live Data Query: Allows LLMs to retrieve real - time data from Google AdWords.
• Natural Language Interface: No SQL knowledge is required, as LLMs can use natural language to ask questions.
• Relational SQL Model: Exposes Google AdWords data as relational SQL models through the CData JDBC Driver.

📦 Installation

1. Clone the Repository

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

2. Build the Server

mvn clean install

This will generate the JAR file: CDataMCP-jar-with-dependencies.jar.

3. Download and Install the CData JDBC Driver

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

4. License the CData JDBC Driver

• Navigate to the lib folder in the installation directory:
  • Windows: C:\Program Files\CData\CData JDBC Driver for Google AdWords\
  • Mac/Linux: /Applications/CData JDBC Driver for Google AdWords/
• Run the command java -jar cdata.jdbc.googleads.jar --license.
• Enter your name, email, and "TRIAL" (or your license key).

5. Configure the Connection to the Data Source

• Run the command java -jar cdata.jdbc.googleads.jar to open the Connection String utility.
• Configure the connection string and click "Test Connection".

  ⚠️ Important Note

  If the data source uses OAuth, you will need to authenticate in your browser.

• Once successful, copy the connection string for later use.

6. Create a .prp File

Create a .prp file (e.g., google - adwords.prp) with the following properties:

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=

💻 Usage Examples

Using the Server with Claude Desktop

1. Create the Config File

Create the claude_desktop_config.json file to add the new MCP server. If the file already exists, add the entry to the mcpServers section. Windows

{
    "mcpServers": {
        "{classname_dash}": {
            "command": "PATH\\TO\\java.exe",
            "args": [
                "-jar",
                "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
                "PATH\\TO\\google-adwords.prp"
            ]
        }
    }
}

Linux/Mac

{
    "mcpServers": {
        "{classname_dash}": {
            "command": "/PATH/TO/java",
            "args": [
                "-jar",
                "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
                "/PATH/TO/google-adwords.prp"
            ]
        }
    }
}

Copy the config file to the appropriate directory if needed: Windows

cp C:\PATH\TO\claude_desktop_config.json %APPDATA%\Claude\claude_desktop_config.json

Linux/Mac

cp /PATH/TO/claude_desktop_config.json /Users/{user}/Library/Application\ Support/Claude/claude_desktop_config.json

2. Run or Refresh the Client

Run or refresh your Claude Desktop client. You may need to fully exit and re - open it for the MCP Server to appear.

Running the Server

Run the following command to start the MCP Server:

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

⚠️ Important Note

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

Usage Details

Once the MCP Server is configured, the AI client can use the built - in tools to read, write, update, and delete data. You can simply ask the client questions about the data system, for example:

• "What is the correlation between my closed won opportunities and the account industry?"
• "How many open tickets do I have in the SUPPORT project?"
• "Can you tell me what calendar events I have today?"

Tools & Descriptions

In the following definitions, {servername} refers to the name of the MCP Server in the config file (e.g., {classname_dash}).

• {servername}_get_tables: Retrieves a list of available tables in the data source. Use {servername}_get_columns to list columns for a table. The output is in CSV format with column headers in the first line.
• {servername}_get_columns: Retrieves a list of columns for a table. Use {servername}_get_tables to get a list of available tables. The output is in CSV format with column headers in the first line.
• {servername}_run_query: Execute a SQL SELECT query.

📚 Documentation

Troubleshooting

1. Server Not Visible in Claude Desktop: Ensure that you have fully quit Claude Desktop (use Task Manager on Windows or Activity Monitor on Mac).
2. Data Retrieval Issue: Make sure your connection is properly configured. Use the Connection String builder to create the connection string and copy it to the .prp file.
3. Data Source Connection Issue: Contact the CData Support Team.
4. MCP Server Usage Issue or Feedback: Join the CData Community.

📄 License

This MCP server is licensed under the MIT License. You are free to use, modify, and distribute the software in accordance with the terms and conditions of the MIT License. For more details, see the LICENSE file in the project repository.

All Supported Sources