Google Ad Manager MCP Server by CData

Provides read-only access to ADP data through SQL queries, enabling retrieval of HR and payroll information.

Provides read-only access to Airtable bases and records through SQL queries, enabling retrieval of structured data from Airtable databases.

Provides read-only access to Amazon DynamoDB tables through SQL queries, enabling retrieval of NoSQL data.

Provides read-only access to Amazon S3 buckets and objects through SQL queries, enabling retrieval of file metadata and content.

Provides read-only access to Asana projects, tasks, and team data through SQL queries, enabling retrieval of project management information.

Provides read-only access to Basecamp projects, messages, and team data through SQL queries, enabling retrieval of project collaboration information.

Provides read-only access to BigCommerce store data including products, orders, and customers through SQL queries.

Provides read-only access to Bitbucket repositories, issues, and pull requests through SQL queries, enabling retrieval of code repository information.

Provides read-only access to Box files, folders, and metadata through SQL queries, enabling retrieval of cloud storage information.

Provides read-only access to Confluence pages, spaces, and content through SQL queries, enabling retrieval of knowledge base information.

Provides read-only access to Couchbase databases and documents through SQL queries, enabling retrieval of NoSQL data.

Provides read-only access to Databricks data and analytics through SQL queries, enabling retrieval of data science and analytics information.

Provides read-only access to Dropbox files, folders, and metadata through SQL queries, enabling retrieval of cloud storage information.

Provides read-only access to eBay marketplace data including listings, orders, and seller information through SQL queries.

Provides read-only access to Elasticsearch indices and documents through SQL queries, enabling retrieval of search and analytics data.

Provides read-only access to EnterpriseDB databases through SQL queries, enabling retrieval of PostgreSQL-compatible data.

Provides read-only access to Facebook data through SQL queries, enabling retrieval of social media information.

Provides read-only access to GitHub repositories, issues, pull requests, and user data through SQL queries.

Provides read-only access to Gmail messages, threads, and labels through SQL queries, enabling retrieval of email data.

Provides read-only access to Google Ads campaigns, ad groups, keywords, and performance data through SQL queries.

Provides read-only access to Google Analytics data including traffic, conversions, and user behavior metrics through SQL queries.

Provides read-only access to Google Calendar events, calendars, and scheduling data through SQL queries.

Provides read-only access to Google Campaign Manager 360 advertising data and campaign performance through SQL queries.

Provides read-only access to Google Cloud Storage buckets and objects through SQL queries, enabling retrieval of cloud file metadata.

Provides read-only access to Google Drive files, folders, and metadata through SQL queries, enabling retrieval of cloud storage information.

Provides read-only access to Google Sheets data through SQL queries, enabling retrieval of spreadsheet content and metadata.

Provides read-only access to GraphQL endpoints through SQL queries, enabling retrieval of API data.

Provides read-only access to Greenhouse recruiting data including candidates, jobs, and hiring pipeline information through SQL queries.

Provides read-only access to HubSpot CRM data including contacts, companies, deals, and marketing data through SQL queries.

Provides read-only access to Instagram data through SQL queries, enabling retrieval of social media content and metrics.

Provides read-only access to Jira issues, projects, and workflow data through SQL queries, enabling retrieval of project tracking information.

Provides read-only access to MailChimp campaigns, lists, and subscriber data through SQL queries, enabling retrieval of email marketing information.

Provides read-only access to MariaDB databases through SQL queries, enabling retrieval of relational database data.

Provides read-only access to MongoDB collections and documents through SQL queries, enabling retrieval of NoSQL data.

Provides read-only access to MYOB accounting data through SQL queries, enabling retrieval of financial and business information.

Provides read-only access to MySQL databases through SQL queries, enabling retrieval of relational database data.

Provides read-only access to Neo4j graph databases through SQL queries, enabling retrieval of graph data and relationships.

Provides read-only access to Odoo ERP data through SQL queries, enabling retrieval of business management information.

Provides read-only access to Okta identity and access management data through SQL queries, enabling retrieval of user and authentication information.

Provides read-only access to PayPal transaction and payment data through SQL queries, enabling retrieval of financial information.

Provides read-only access to Pinterest data through SQL queries, enabling retrieval of social media content and analytics.

Provides read-only access to PostgreSQL databases through SQL queries, enabling retrieval of relational database data.

Provides read-only access to Presto distributed SQL query engine data through SQL queries, enabling retrieval of big data analytics.

Provides read-only access to QuickBooks accounting data through SQL queries, enabling retrieval of financial and business information.

Provides read-only access to Redis data structures through SQL queries, enabling retrieval of cached and session data.

Provides read-only access to RSS feeds through SQL queries, enabling retrieval of syndicated content and news.

Provides read-only access to Sage business management data through SQL queries, enabling retrieval of financial and operational information.

Provides read-only access to Salesforce CRM data including accounts, contacts, opportunities, and custom objects through SQL queries.

Provides read-only access to SAP business data through SQL queries, enabling retrieval of enterprise resource planning information.

Provides read-only access to SendGrid email delivery data through SQL queries, enabling retrieval of email analytics and campaign information.

Provides read-only access to Shopify store data including products, orders, customers, and inventory through SQL queries.

Provides read-only access to SingleStore databases through SQL queries, enabling retrieval of distributed database data.

Provides read-only access to Slack workspace data including messages, channels, and user information through SQL queries.

Provides read-only access to Snapchat Ads data through SQL queries, enabling retrieval of advertising campaign and performance information.

Provides read-only access to Snowflake data warehouse through SQL queries, enabling retrieval of cloud data platform information.

Provides read-only access to Splunk data through SQL queries, enabling retrieval of machine data and analytics information.

Provides read-only access to Square payment and business data through SQL queries, enabling retrieval of transaction and merchant information.

Provides read-only access to Stripe payment data through SQL queries, enabling retrieval of transaction, customer, and subscription information.

Provides read-only access to SurveyMonkey survey data and responses through SQL queries, enabling retrieval of market research information.

Provides read-only access to Teradata data warehouse through SQL queries, enabling retrieval of enterprise analytics data.

Provides read-only access to Trello boards, cards, and lists through SQL queries, enabling retrieval of project management information.

Provides read-only access to Trino distributed SQL query engine data through SQL queries, enabling retrieval of big data analytics.

Provides read-only access to Twilio communication data through SQL queries, enabling retrieval of messaging and voice service information.

Provides read-only access to WooCommerce store data including products, orders, and customers through SQL queries.

Provides read-only access to WordPress site data including posts, pages, users, and metadata through SQL queries.

Provides read-only access to Xero accounting data through SQL queries, enabling retrieval of financial and business information.

Provides read-only access to XML data sources through SQL queries, enabling retrieval of structured markup data.

Provides read-only access to YouTube Analytics data through SQL queries, enabling retrieval of video performance and channel metrics.

Provides read-only access to Zendesk support data including tickets, users, and organizations through SQL queries.

Provides read-only access to Zoho business application data through SQL queries, enabling retrieval of CRM, project, and productivity information.

google-ad-manager-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for Google Ad Manager

: This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Google Ad Manager (beta).

Purpose

We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Google Ad Manager supported by the CData JDBC Driver for Google Ad Manager.

CData JDBC Driver connects to Google Ad Manager by exposing them as relational SQL models.

This server wraps that driver and makes Google Ad Manager data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.

Setup Guide

Clone the repository:
git clone https://github.com/cdatasoftware/google-ad-manager-mcp-server-by-cdata.git cd google-ad-manager-mcp-server-by-cdata
Build the server:
mvn clean install
This creates the JAR file: CDataMCP-jar-with-dependencies.jar
Download and install the CData JDBC Driver for {source}: https://www.cdata.com/drivers/dfp/download/jdbc
License the CData JDBC Driver:
- Navigate to the lib folder in the installation directory, typically:
  - (Windows) C:\Program Files\CData\CData JDBC Driver for Google Ad Manager\
  - (Mac/Linux) /Applications/CData JDBC Driver for Google Ad Manager/
- Run the command java -jar cdata.jdbc.doubleclickfp.jar --license
- Enter your name, email, and "TRIAL" (or your license key).
Configure your connection to the data source (Salesforce as an example):
- Run the command java -jar cdata.jdbc.doubleclickfp.jar to open the Connection String utility.
- Configure the connection string and click "Test Connection"
  Note: If the data sources uses OAuth, you will need to authenticate in your browser.
- Once successful, copy the connection string for use later.
Create a .prp file for your JDBC connection (e.g. google-ad-manager.prp) using the following properties and format:
- Prefix - a prefix to be used for the tools exposed
- ServerName - a name for your server
- ServerVersion - a version for your server
- DriverPath - the full path to the JAR file for your JDBC driver
- DriverClass - the name of the JDBC Driver Class (e.g. cdata.jdbc.doubleclickfp.DoubleClickFPDriver)
- JdbcUrl - the JDBC connection string to use with the CData JDBC Driver to connect to your data (copied from above)
- Tables - leave blank to access all data, otherwise you can explicitly declare the tables you wish to create access for
  Prefix=doubleclickfp ServerName=CDataDoubleClickFP ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.doubleclickfp.jar DriverClass=cdata.jdbc.doubleclickfp.DoubleClickFPDriver JdbcUrl=jdbc:doubleclickfp:InitiateOAuth=GETANDREFRESH; Tables=

Using the Server with Claude Desktop

Create the config file for Claude Desktop ( claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the mcpServers in the config file. Windows
{ "mcpServers": { "{classname_dash}": { "command": "PATH\\TO\\java.exe", "args": [ "-jar", "PATH\\TO\\CDataMCP-jar-with-dependencies.jar", "PATH\\TO\\google-ad-manager.prp" ] }, ... } }
Linux/Mac
{ "mcpServers": { "{classname_dash}": { "command": "/PATH/TO/java", "args": [ "-jar", "/PATH/TO/CDataMCP-jar-with-dependencies.jar", "/PATH/TO/google-ad-manager.prp" ] }, ... } }
If needed, copy the config file to the appropriate directory (Claude Desktop as the example). 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'
Run or refresh your client (Claude Desktop).

Note: You may need to fully exit or quit your Claude Desktop client and re-open it for the MCP Servers to appear.

Running the Server

Run the follow the command to run the MCP Server on its own
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp > **Note:** The server uses `stdio` so can only be used with clients that run on the same machine as the server.

Usage Details

Once the MCP Server is configured, the AI client will be able to use the built-in tools to read, write, update, and delete the underlying data. In general, you do not need to call the tools explicitly. Simply ask the client to answer questions about the underlying 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?"

The list of tools available and their descriptions follow:

Tools & Descriptions

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

{servername}_get_tables - Retrieves a list of tables available in the data source. Use the {servername}_get_columns tool to list available columns on a table. The output of the tool will be returned in CSV format, with the first line containing column headers.
{servername}_get_columns - Retrieves a list of columns for a table. Use the {servername}_get_tables tool to get a list of available tables. The output of the tool will be returned in CSV format, with the first line containing column headers.
{servername}_run_query - Execute a SQL SELECT query

JSON-RPC Request Examples

If you are scripting out the requests sent to the MCP Server instead of using an AI Client (e.g. Claude), then you can refer to the JSON payload examples below – following the JSON-RPC 2.0 specification - when calling the available tools.

source_get_tables

{
    "jsonrpc": "2.0",
    "id": 1,
    "method": "tools/call",
    "params": {
        "name": "source_get_tables",
        "arguments": {}
    }
}

source_get_columns

{
    "jsonrpc": "2.0",
    "id": 2,
    "method": "tools/call",
    "params": {
        "name": "source_get_columns",
        "arguments": {
            "table":  "Account"
        }
    }
}

source_run_query

{
    "jsonrpc": "2.0",
    "id": 3,
    "method": "tools/call",
    "params": {
        "name": "source_run_query",
        "arguments": {
            "sql":  "SELECT * FROM [Account] WHERE [IsDeleted] = true"
        }
    }
}

Troubleshooting

If you cannot see your CData MCP Server in Claude Desktop, be sure that you have fully quit Claude Desktop (Windows: use the Task Manager, Mac: use the Activity Monitor)
If Claude Desktop is unable to retrieve data, be sure that you have configured your connection properly. Use the Connection String builder to create the connection string (see above) and copy the connection string into the property (.prp) file.
If you are having trouble connecting to your data source, contact the CData Support Team.
If you are having trouble using the MCP server, or have any other feedback, join the CData Community.

License

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

All Supported Sources

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

How are these scores calculated?

local-only server

The server can only run on the client's local machine because it depends on local resources.

This read-only MCP Server allows you to connect to Google Ad Manager data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp

Related MCP Servers

Google Search MCP Server by CData
CDataSoftware
-
security
A
license
-
quality
This read-only MCP Server allows you to connect to Google Search data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp
Last updated -
MIT License
Google Contacts MCP Server by CData
CDataSoftware
-
security
A
license
-
quality
This read-only MCP Server allows you to connect to Google Contacts data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp
Last updated -
MIT License
Bing Ads MCP Server by CData
CDataSoftware
-
security
A
license
-
quality
This read-only MCP Server allows you to connect to Bing Ads data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp
Last updated -
1
MIT License
Google Campaign Manager 360 MCP Server by CData
CDataSoftware
-
security
A
license
-
quality
This read-only MCP Server allows you to connect to Google Campaign Manager 360 data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp
Last updated -
MIT License

View all related MCP servers