Ads-manager

This MCP server provides a standardized interface for querying and analyzing your Amazon Advertising data via the Claude Desktop App. It connects to a PostgreSQL database to fetch metrics, campaigns, ad groups, and related configurations, and exposes tools that allow natural language driven analysis as well as structured queries. Available resources include Schema to inspect the database structure, Metrics for performance data, Campaigns for configuration details, and Ad Groups for group-level information. Tools exposed by the server include analyzeCampaignPerformance to evaluate campaign-level metrics, analyzeAdGroupPerformance for fine-grained analysis at the ad group level, optimizeBudget to generate budget optimization recommendations, and query to run custom SQL against the database. To use it, configure Claude Desktop App to point at the MCP server via the provided endpoint and supply an API key for authentication. You will receive data responses and analytic insights that you can use to inform advertising decisions.

Prerequisites:

• Node.js and npm installed on your machine
• Access to the internet to install npm packages

1. Install the MCP server package:

npm install ads-manager-mcp

2. Set up your Claude Desktop App configuration. Create or update claude-desktop-config.json with the MCP server entry:

{
  "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"
      }
    }
  }
}

3. Replace YOUR_API_KEY_HERE with your actual API key.

4. Start using the Claude Desktop App to analyze your advertising data. If the package provides a local dev script, you can run:

npm run dev

If no local dev script exists, ensure the installed package is available and your Claude integration points to the correct endpoint supplied in your Claude config.

Notes and tips:

• Authentication is performed via API key in the Authorization header. Keep your API key secure and rotate regularly.
• The server expects a PostgreSQL database connection pre-configured in the package; if you need to override connection details, consult the package documentation for environment variable options.
• When using Claude Desktop, ensure the endpoint uses SSE transport as indicated in the example to receive real-time updates.
• If you encounter connection issues, verify network access to the PostgreSQL host and that the API key has the required permissions.
• Common tools that you can call from Claude include analyzeCampaignPerformance, analyzeAdGroupPerformance, optimizeBudget, and query for running custom SQL statements.
• Monitor server logs for any authentication or database errors to quickly diagnose misconfigurations.