FREE CLAUDE SKILL · AMC

Write Custom AMC SQL Queries Using AI

/amc-sql-writer

Describe the report you want. Get back AMC SQL that runs first time, with the units and privacy rules already handled.

Download the skill ↓ Setup guide

v1.0 · Sep 2026 · Free · No email gate · Read-only

starter-queries.sql

SETUP · NOTHING TO CONNECT

How To Run The Skill. Three Steps, Under Three Minutes.

STEP 01

Upload the skill file once

Download it above, then drop it into Claude under Customize, then Skills. It becomes /amc-sql-writer in every chat after that.

Desktop or web: Sidebar → Customize → Skills → Add → Upload a skill

Claude Code: unzip it into ~/.claude/skills/

WHAT TO GIVE IT

MetricNew-to-brand rate

Grainby ASIN

Pathdisplay before search

Windowset in the AMC date picker

STEP 02

Describe the report

Plain English. Say the metric, the grain and the audience path. You do not need to know the schema; the skill carries 29 tables and the unit and privacy rules.

Before the first run

An AMC instance you can query

The metric and grain you want

No MCP needed, paste the SQL yourself

Optional: AdLabs MCP to validate and run it

New-to-brand rate by ASIN for shoppers who saw display before search.

CLAUDE, USING THE SKILL

Picked tables: dsp_impressions, sponsored_ads_traffic

Units: DSP millicents, sponsored microcents

Dates on _dt, advertiser-local

Aggregation kept above the privacy thresholds

Returned the query, metrics derived in a CTE

ntb-by-asin-display-then-search.sql

STEP 03

Say this

Take the query to the AMC console. Or connect the AdLabs MCP and have it validated and run for you.

Then, in the same chat

›This query returns empty. Here it is, what is wrong with it?

›Why is my spend column 100,000 times too big?

Open the full setup guide →

THE OUTPUT

What You Get Back. Deep AMC Insights on Your Brand and Ads.

A query you paste into the AMC console. Base logic isolated as a CTE, metrics derived in the outer select, units converted and privacy thresholds respected, so it runs on the first try instead of failing quietly.

starter-queries.sql

Base logic as a CTEMetrics derived in the outer selectUnits converted, not guessedDivide-by-zero guarded

See the starter queries ↗ Eight field-tested queries ship inside the skill.

Back to all skills

6,500+brands on AdLabs

$1B+annual ad spend managed

4.7on Trustpilot

FREE CLAUDE SKILL · AMC SQL WRITER

Download It Once.
Run It On Any Account.

Free, no email gate, read-only. It runs on live data through the AdLabs MCP, so start the 30-day Pro trial and point it at your account.

Download the skill ↓ Start Free Trial

Write Custom AMC SQL Queries Using AI