Snowflake MCP server for 
AI agents
Ask Claude, ChatGPT or Cursor about the numbers in your Snowflake warehouse, with live ad spend next to them.
No card needed. Works with any MCP client.
LemonadoSnowflake MCP
Ask about orders, customers and subscription models in Claude, ChatGPT or any AI agent, from live Snowflake data.
What is the Snowflake MCP server?
Lemonado's Snowflake MCP server gives Claude, ChatGPT and other AI apps read access to the tables and views in your Snowflake account: orders, customers, subscriptions and the revenue models your data team already built. Connect Snowflake to Lemonado, connect Lemonado to your AI, and ask in plain words instead of writing SQL. The same connection reaches Google Ads, Meta and GA4, so warehouse revenue and platform spend meet in one answer.
All your Snowflake data
Tables and views your role can read, ready to ask about.
Always today's numbers
Column names, types and descriptions, synced from Snowflake automatically, so answers use today's numbers.
Connect all your tools
Questions like "What does a paying customer cost?" use Snowflake and BigQuery, GA4 at once.
Connecting takes minutes.
- 1
Connect Snowflake
Sign in to Snowflake in Lemonado.
- 2
Copy the server URL
Turn on external access and copy one URL.
- 3
Ask in Claude
Add the URL to Claude and ask away.
Ask it anything.
Claude reads your Snowflake numbers, explains what moved and turns the answer into an artifact you can share.
ClaudeFrom our Snowflake orders model, what is 12-month revenue per customer for each first-order month in 2025?
January 2025 customers earned $214 each in their first year, the best cohort. Customers from the June sale earned $131, mostly one-time buyers.
Source: Snowflake
Rank product categories by gross margin dollars last quarter, using the margin view in Snowflake.
Tents bring 38% of margin dollars on 24% of revenue. Accessories sell the most units but bring only 9% of margin after shipping.
Source: Snowflake
Which Snowflake view defines active customer, and what rule does it use?
analytics.dim_customers sets is_active when a customer ordered in the last 180 days. finance.customers uses 365 days, so the two counts differ by about 4,100.
Source: Snowflake
Compare net revenue in our Snowflake finance model with gross orders for each week of October. Where is the gap biggest?
Week 42 has the widest gap: $186k gross against $151k net. Returns from the rain jacket recall explain most of it.
Source: Snowflake
Join first orders from Snowflake with Meta and Google Ads spend by month this year. What did each new customer cost per channel?
Meta: $41 per first-time customer, Google Ads: $33. Meta customers reorder more, so their 12-month value is 18% higher.
Source: Snowflake + ads
Compare the purchases Google Ads reported last week with orders in Snowflake that have a gclid.
Google Ads reported 412 purchases, Snowflake has 371 orders with a gclid. Most of the gap is view-through conversions Google counts and your store never sees.
Source: Snowflake + Google Ads
Let Lemonado check Snowflake for you.
Copy one of these into Lemonado and it runs on a schedule.
Every Monday, send last week's net revenue, orders and new customers from our Snowflake finance model, with the change from the week before.
Monday revenue from the warehouse
Every morning at 7, check that the orders and ad spend tables in Snowflake have yesterday's rows, and post in #data if either is behind.
Daily freshness check
On the 2nd of each month, send last month's cost per new customer for Meta, Google Ads and TikTok, using first orders from Snowflake.
Monthly CAC by channel
Why Lemonado?
Your whole stack in one connection
Google, Meta, GA4, TikTok and 3,000+ more tools, in every AI app.
No API keys or servers
Sign in once. Nothing to install, host or keep alive.
Scoped to each client
Each connection only reaches the clients you allow. Built for agencies.
Actions with guardrails
Set each action to Off, Ask or Approve. Nothing runs that you haven't allowed.
Use Snowflake with any AI agent.
Claude
Connect Snowflake to Claude
ChatGPT
Connect Snowflake to ChatGPT
Claude Code
Connect Snowflake to Claude Code
Cursor
Connect Snowflake to Cursor
VS Code (GitHub Copilot)
Connect Snowflake to VS Code (GitHub Copilot)
Codex
Connect Snowflake to Codex
Perplexity
Connect Snowflake to Perplexity
Google Antigravity
Connect Snowflake to Google Antigravity
Windsurf (Devin Desktop)
Connect Snowflake to Windsurf (Devin Desktop)
Zed
Connect Snowflake to Zed
n8n
Connect Snowflake to n8n
Is there an official Snowflake MCP server?
Yes. Snowflake runs managed MCP servers inside your own account. An admin creates one with SQL, chooses which tools it exposes and sets up OAuth for each AI app. It answers from what's already in Snowflake, so ad spend only shows up if your team loads it there.
| Snowflake's managed MCP server | Lemonado | |
|---|---|---|
| Setup | An admin creates the server, grants each tool and registers OAuth clients | Connect a read-only role once, paste one URL |
| Live ad platform data | Only what's loaded into Snowflake | Google Ads, Meta, TikTok and GA4, live |
| Warehouse revenue next to ad spend | If you build the pipelines first | Yes, in one question |
| Reports and alerts on a schedule | No | Yes, in Slack or email |
| Price | Normal Snowflake compute | See pricing |
Explore other integrations
All 3,000+ integrations
Google BigQueryAsk Claude, ChatGPT or Cursor about your GA4 export and BigQuery tables without writing SQL.
Google AnalyticsAsk Claude, ChatGPT or Cursor about GA4 traffic, conversions and funnels, next to your ad spend.
Meta AdsAsk Claude, ChatGPT or Cursor about your Facebook and Instagram ads, creatives and results.
StripePut Stripe revenue next to your ad spend in Claude, ChatGPT or Cursor.
PipedriveAsk Claude, ChatGPT or Cursor about your Pipedrive deals, and which ads bring the ones that close.
AmplitudeAsk Claude, ChatGPT or Cursor which campaigns bring Amplitude users who stick around.
Reading this as an AI agent?
Everything an agent needs to set this up, in plain text. Paste this page's link into your AI app and ask it to connect you, or copy the block.
# Lemonado MCP server for Snowflake Lemonado is a hosted MCP server that gives AI apps the user's live Snowflake, plus any other marketing tool they connect (Google Ads, Meta Ads, GA4 and 3,000+ more). - Server URL: https://mcp.lemonado.io/mcp - Transport: Streamable HTTP - Auth: OAuth; the user signs in to Lemonado in the browser. No API keys. - Snowflake data: Tables and views your role can read; Orders, customers and subscription models; Column names, types and descriptions; Revenue and margin tables built by your data team; Query results, with the SQL that produced them; Schemas across several databases - Connecting Snowflake: Create a read-only role that can use one warehouse and the schemas marketing should see, and connect with that. Keep raw PII schemas out of the grant. - Tools on https://mcp.lemonado.io/mcp (custom connectors, coding agents, n8n): list_objects, get_object_details, execute_sql, get_google_ads_resource_metadata, list_companies, get_company_details, list_actions, get_action_details, execute_action - Lemonado's Claude directory app and ChatGPT plugin (read-only): list_projects, list_project_sources, answer_data_question, explain_metric_change ## Setup 1. The user connects Snowflake in Lemonado (Connectors) and signs in. 2. In the company's settings → External tools, they turn the connection on and copy the server URL. 3. They add the server URL to their AI app. Setup per app: https://lemonado.io/integrations Docs: https://docs.lemonado.io/mcp-reference Full index for agents: https://lemonado.io/llms.txt
Frequently Asked Questions
No. Lemonado queries Snowflake with the role you give it and returns the result to your AI app. Use a read-only role limited to the schemas you want marketing to see, and nothing else in the account is visible.
Connect your Snowflake role and warehouse in Lemonado, turn on External tools, and add Lemonado to Claude or ChatGPT. Each guide on this page has the exact steps. Create a read-only role that can use one warehouse and the schemas marketing should see, and connect with that. Keep raw PII schemas out of the grant. Then ask something like "From our Snowflake orders model, what is 12-month revenue per customer for each first-order month in 2025?"
Yes. It's a standard remote MCP server (https://mcp.lemonado.io/mcp): one command in Claude Code, one entry in Cursor's mcp.json, and an MCP Client Tool with a Lemonado token in n8n. In a coding agent, try "Compare daily order totals in our Snowflake fct_orders model with the raw orders table for October, and point to the SQL that causes any gap."
Yes. Besides answering in Claude or ChatGPT, Lemonado runs Snowflake reports and alerts on a schedule, in Slack or email. For example: "Every Monday, send last week's net revenue, orders and new customers from our Snowflake finance model, with the change from the week before."
It reads your Snowflake data. Snowflake stays untouched; the only changes Lemonado can make are in ad accounts you connect, and only once you approve them.
MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.
Still have a question?
Shoot us an email at hello@lemonado.io.
Try for freeStop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
Try Lemonado free