Facebook Ads MCP Server by CData

Name: Facebook Ads MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About Facebook Ads MCP Server by CData

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 Facebook Ads (beta): https://www.cdata.com/download/download.aspx?sku=HRZK-V&type=beta

#facebook-ads #mcp-server #data-integration

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Facebook Ads MCP Server by CData?

Facebook Ads MCP Server by CData is a read-only MCP server that allows LLMs like Claude Desktop to query live Facebook Ads data. It wraps the CData JDBC Driver for Facebook Ads, exposing the data as relational SQL models and enabling natural language questions without requiring SQL.

How to use Facebook Ads MCP Server by CData?

Clone the repository and build the server with mvn clean install. Download and license the CData JDBC Driver for Facebook Ads, then generate a JDBC connection string using the driver’s utility. Create a .prp file with the connection details and add the server to your MCP client (e.g., Claude Desktop) by editing claude_desktop_config.json. Start the client and ask questions about your Facebook Ads data.

Key features of Facebook Ads MCP Server by CData

Read-only access to live Facebook Ads data.
Wraps the CData JDBC Driver for Facebook Ads.
Exposes tables and columns for querying.
Supports SQL SELECT queries via the run_query tool.
Enables natural language question answering through LLMs.
Uses stdio transport for local client-server communication.

Use cases of Facebook Ads MCP Server by CData

Query Facebook Ads performance metrics using natural language.
Analyze ad campaign data alongside other data sources.
Retrieve live Facebook Ads data for reporting or dashboards.
Explore Facebook Ads schema and column details.
Integrate Facebook Ads data into AI-powered conversational agents.

FAQ from Facebook Ads MCP Server by CData

What is the difference between this server and the CData MCP Server for Facebook Ads (beta)?

This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.

What are the prerequisites to run this server?

Java, Maven, and the CData JDBC Driver for Facebook Ads (with a valid license or trial) are required. The server is built from source using Maven.

What transport does the server use?

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

How can I troubleshoot connection issues?

Use the Connection String builder to test the connection and ensure OAuth authentication is completed. For further help, contact the CData Support Team or join the CData Community.