Connect Claude, ChatGPT & any AI tool to your store data
Datadrew's secure MCP server gives your AI assistant a live, read-only line to your Shopify, ads, email and analytics data. Ask in plain English — get real numbers, blended ROAS, LTV and cohorts back in seconds. No CSV exports. No hallucinations. Set up in 2 minutes.
Works with
Claude
ChatGPT
Cursor
Windsurf
VS Code
Any MCP client
Claude
Asking AI about your store today is broken
Generic AI doesn't know your numbers — so you get confident guesses, or you spend your evening exporting spreadsheets.
AI that guesses
Ask ChatGPT about last week's ROAS and it invents a plausible-looking number. Without your real data, every answer is a hallucination waiting to mislead a decision.
Death by CSV export
You burn hours exporting from Shopify, Meta and Google, stitching spreadsheets together, then pasting them into a chat window that forgets it all tomorrow.
Dashboards aren't answers
A dozen dashboards tell you what happened. None of them tell you why, or which lever to pull next — so the insight dies in a tab you never reopen.
Datadrew MCP gives your AI real, governed data — so it reasons instead of guessing.
One connector. All your data. Plain English.
MCP (Model Context Protocol) is an open standard that lets AI assistants securely connect to outside tools and data. Datadrew runs a public, OAuth-secured MCP server at mcp.datadrew.io. Connect it once and your AI client can query every platform you've linked to Datadrew — answering with the exact same numbers, metric definitions and permissions as the app.
Open Datadrew MCP
In Datadrew, go to Settings → Datadrew MCP. It's available on the Essentials and Pro plans.
Copy your secure URL
Copy the Datadrew MCP URL — mcp.datadrew.io/mcp — shown right here and in Settings → Datadrew MCP.
Paste into your AI tool
Add it as a connector in Claude, ChatGPT, Cursor or any MCP client, authorize with OAuth, and start asking.
https://mcp.datadrew.io/mcp
Paste this URL into your AI tool, then authorize with OAuth. You'll also find it — with step-by-step instructions — under Settings → Datadrew MCP inside Datadrew.
Set it up in your favourite AI tool
Pick your client and follow the steps. Same URL, same OAuth flow, everywhere.
https://mcp.datadrew.io/mcp
- Open Settings → Connectors in Claude (works in Claude.ai and Claude Desktop).
- Click Add custom connector and paste the URL above.
- Click Connect and authorize with your Datadrew account via OAuth.
- Start any chat and ask "What was my blended ROAS last week?" — Drew's tools run automatically.
- In ChatGPT, open Settings → Connectors (or build a custom GPT).
- Add a new connector and paste the URL above.
- Sign in with OAuth to link your Datadrew workspace.
- Ask your store questions right inside the chat — ChatGPT calls Datadrew for the real numbers.
- Open your MCP config —
mcp.jsonin Cursor, Windsurf or VS Code. - Add a server entry pointing at
https://mcp.datadrew.io/mcp. - Reload and complete the OAuth flow when your editor prompts you.
- Drew's read-only tools appear alongside your other MCP servers, ready to query.
- Point any spec-compliant MCP client at
https://mcp.datadrew.io/mcp(streamable HTTP). - Authenticate with OAuth — access is scoped to your workspace and plan.
- Discover Datadrew's read-only tools across every connected platform.
- Use them from any agent framework, automation or custom app that speaks MCP.
Everything your AI can pull
Connect once and your assistant can query 15+ platforms in plain English — all blended into consistent CAC, ROAS, MER and LTV definitions the AI actually understands.
"Show me yesterday's revenue, AOV and units sold by product type."
"Compare ROAS and CPC across Meta and Google for the last 14 days."
"Which landing pages convert best, and which search queries are rising?"
"How much revenue did my Klaviyo flows drive vs campaigns this month?"
"What's my subscription churn and MRR trend by plan?"
"Break down sales by marketplace and flag any late shipments."
A prompt library to get you started
Copy a prompt, paste it into Claude or ChatGPT, and let Drew pull the numbers. Filter by what you're working on.
Where should I shift budget this week for better blended ROAS?
Show me which ads are winning and which to pause across Meta and Google.
Which campaigns wasted the most budget last week, and why?
Show me my customer segments — who are my champions vs at-risk?
What's my 90-day LTV by acquisition cohort?
Which products drive the most repeat purchases?
Which SKUs are hero products vs ad-spend wasters?
What are my top product bundles by revenue for cross-sell?
Show me repurchase rates by product type over the last 6 months.
Give me an executive summary of this month's performance.
How are we performing vs last month, and what changed?
Which channel should I scale next, and what's the expected payback?
Every client store, in one conversation
Managing more than one Shopify store? Datadrew MCP is built for it. No re-authing between clients, no juggling logins — just ask.
- Query multiple stores in a single chat session.
- Switch the active shop, or compare two stores in one question.
- Every answer reports which store it actually ran against.
- One Datadrew login, OAuth-scoped to exactly the shops you manage.
Your data, on your terms
Plug AI into your store with confidence. Datadrew MCP is read-only, OAuth-secured, and built so your assistant can analyze everything while changing nothing.
OAuth, not API keys
Access is granted through OAuth and tied to your Datadrew workspace. Revoke it anytime from the app — no secret keys to leak.
Read-only by default
The server can read and analyze your data — it can never pause campaigns, edit orders, move budget or place spend.
Data minimization
Drew sends your AI only the data needed to answer the question in front of it — nothing more, never your whole database.
Encrypted & compliant
Data is encrypted in transit and at rest on SOC 2-compliant, GDPR-aligned infrastructure — the same backbone that powers the app.
Why Datadrew MCP, not just ChatGPT?
Plain chatbots guess. Ad-only connectors see a sliver of your funnel. Datadrew gives your AI the whole picture.
| Capability | Datadrew MCP | Plain ChatGPT / Claude | Ad-only AI connectors |
|---|---|---|---|
| Answers from your real store data | ✓ | ✗ | Ads only |
| Connected data sources | 15+ | 0 | 2–3 |
| Shopify orders, products & LTV | ✓ | ✗ | ✗ |
| Blended ROAS, MER & cohorts | ✓ | ✗ | Partial |
| Email, subscriptions & marketplaces | ✓ | ✗ | ✗ |
| Read-only & OAuth-secured | ✓ | n/a | Varies |
| Works in Claude, ChatGPT & Cursor | ✓ | — | ✓ |
| Multi-store for agencies | ✓ | ✗ | Partial |
| Consistent metric definitions | ✓ | ✗ | Partial |
One analyst, everywhere you work
The MCP server is one of three ways to put Drew AI to work. Same brain, same numbers — wherever your team lives.
In the Datadrew app
Chat with Drew right inside Datadrew, next to your dashboards, on every plan.
Meet Drew AIIn Slack
Mention @Drew in any channel and get charts and recommendations back in-thread.
Slack integrationVia MCP (you're here)
Bring Drew's tools into Claude, ChatGPT, Cursor or any MCP client with one URL.
Jump to setupTrusted by fast-growing Shopify brands
"One of the best apps in the Shopify App Store. Saves hours of manual reporting if you track customer lifetime value. Good options for slicing and dicing by customer cohort, product, etc."
"WOW is all I can say. I have spent so much time trying to nail down an accurate LTV and I was amazed at how robust this app is and gives me quality data that I can take action on."
"Needed a tool for historic cohort / LTV analysis. Datadrew hit the sweet spot. Nifty, to the point, quick 1:1 support and great pricing."
Frequently asked questions
mcp.datadrew.io, so your AI client can query the platforms you've connected to Datadrew using your own data — instead of guessing.Bring your store data into Claude & ChatGPT
Connect Datadrew's MCP server and ask your AI anything about your Shopify, ads and analytics data — securely, with OAuth, in two minutes.
MCP access is included on the Essentials and Pro plans.