• CODE
  • STATUS
  • ACCESS
  • HUMAN

How to run SQL queries in Amazon Marketing Cloud with your AI

Connect your AI to Amazon Marketing Cloud once. From there, you just ask for the data you need and your agent handles the SQL and file retrieval.

Ask AI about this page

Short answer

How do I run SQL queries in Amazon Marketing Cloud using AI?

Tell your agent what data you want in plain English. It writes the SQL, runs the job, and hands you the S3 download links for the results. You get the data without writing a single line of code.

The outcomes

What your AI delivers

The AI manages the technical execution so you can focus on the insights.

CODE

Automated SQL

Your agent translates your questions into valid SQL syntax. It handles the query structure so you don't have to.

STATUS

Job monitoring

The AI tracks the execution progress. It knows exactly when the data processing is finished and ready for you.

ACCESS

Secure links

Your agent fetches the S3 download URLs once the job succeeds. You get direct access to your reports immediately.

HUMAN

Data review

You receive the links and inspect the data. The AI provides the access, but you verify the final results.

The workflow

What your AI does when the query arrives.

The AI follows a specific sequence to turn your request into a downloadable file.

  1. Start the job

    Your agent converts your request into a query and submits it to the cloud.

    create_execution

  2. Check progress

    The AI monitors the execution to see if the data is ready.

    get_execution_status

  3. Get links

    Once the status is complete, the AI pulls the S3 download locations.

    get_execution_download_urls

  4. Provide access

    The agent delivers the secure download links directly to your chat.

    get_execution_download_urls

Try it

Copy these to start.

Use these prompts to trigger your first query.

Starting points

These are opening lines. Swap out the specific metrics or date ranges for your own data.

Amazon Marketing Cloud Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_im4kYeyTbSMqZOudko7I4MxH8XnNcyWNp4QSF0Ar/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Amazon Marketing Cloud capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "amazon-marketing-cloud-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_im4kYeyTbSMqZOudko7I4MxH8XnNcyWNp4QSF0Ar/mcp"
    }
  }
}
Copy into chat04

  • Run a query to show me total ad spend by campaign for last month.

  • Get a report on conversion rates for my latest video ads.

  • Find the correlation between impressions and clicks for the summer campaign.

  • Provide the S3 download links for the audience reach report I just requested.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Amazon Marketing Cloud once, then ask.

Link your account once and your credentials stay encrypted. You can then start asking for data immediately.

Connect Amazon Marketing Cloud to your AI

FAQ

How this task behaves

  • 01

    Can the AI change my Amazon Marketing Cloud settings?

    No. The AI only has tools to create, check, and retrieve data from executions.

  • 02

    Does the AI store my data?

    No. The AI only retrieves the S3 download links for the reports you request.

  • 03

    Can I ask for data from a specific date range?

    Yes. You can specify any timeframe in your prompt, and the AI will include it in the SQL.

  • 04

    Will the AI delete any existing reports?

    No. There are no tools available to delete or modify existing executions or data.

  • 05

    Can the AI run multiple queries at once?

    Yes. Your agent can initiate multiple separate executions based on your instructions.

  • More questions about Amazon Marketing Cloud? The Connector page answers them. See everything the Amazon Marketing Cloud Connector can do

Connect Amazon Marketing Cloud to Claude, Cursor, ChatGPT & more