Ads Manager

You set up and run an MCP server that connects to a PostgreSQL database, authenticates requests with an API key, and exposes real-time analytics for Amazon Advertising data through an easy client interface. This lets you query campaign metrics, analyze performance, and get actionable insights using natural language queries.

How to use

Use a compatible MCP client to connect to your Ads Manager MCP Server. Once connected, you can ask questions like how campaigns performed over a period, review key metrics by ad group, or request budget recommendations. The server supports real-time analytics and natural language querying, so you can analyze data without writing SQL.

How to install

npm install ads-manager-mcp

Next, create a configuration file for your MCP client to connect to the server. Use the following configuration snippet and replace YOUR_API_KEY_HERE with your actual API key.

{
  "name": "Amazon Ads Manager",
  "version": "1.0.4",
  "description": "Connect to your Amazon Advertising data and analyze campaign performance",
  "mcpServers": {
    "ads-manager": {
      "name": "Ads Manager MCP Server",
      "version": "1.0.4",
      "description": "MCP Server for Amazon Advertising data analysis",
      "transport": "sse",
      "endpoint": "https://mcp-server-sync-abhilashreddi.replit.app/mcp/sse",
      "headers": {
        "Authorization": "Bearer YOUR_API_KEY_HERE"
      }
    }
  }
}

Save this configuration file as claude-desktop-config.json in your project workspace. Then start using the Claude Desktop App to analyze your advertising data.

Additional sections

Configuration at a glance: you connect to a remote MCP server over HTTP that streams data via SSE and requires an API key for authorization. All data access is secured through the API key header.

Security: treat your API key as a secret. Do not commit it to version control. Use environment-specific configurations and consider rotating keys periodically.

Development and troubleshooting: if you need to run locally for testing, install dependencies, then run the development flow shown below to start the local environment and build the package.

# Install dependencies
npm install

# Start the development server
npm run dev

# Build the package for production
npm run build

Available tools

analyzeCampaignPerformance

Analyze campaign-level metrics and performance trends to identify top performers, underperforming campaigns, and opportunities for optimization.

analyzeAdGroupPerformance

Provide detailed analysis of ad group performance including spend, reach, clicks, conversions, and ROI by ad group.

optimizeBudget

Generate budget optimization recommendations across campaigns based on historical performance and target metrics.

query

Run custom SQL queries against the connected PostgreSQL database to extract ad data and metrics.