Snowflake MCP connector
The Snowflake connector lets Claude, ChatGPT, Cursor, Microsoft Copilot and other AI clients manage Snowflake users, roles, warehouses, views, alerts and accounts on your behalf, with every action limited to your own Snowflake access and recorded in an audit log.
- Connects over OAuth
- Free 14-day trial
- No credit card
List Snowflake roles created in the last 30 days.
Working in Snowflake with Elaichi
-
List all Snowflake users
-
Get single Snowflake user by ID
-
List all Snowflake roles
How to connect Snowflake to Claude, ChatGPT, Cursor or Microsoft Copilot
Step by step, for each AI app
Snowflake MCP connector for Claude
-
1
Open Customize, then Connectors.
-
2
Press Add.
-
3
Name it, paste the MCP server URL, then Continue.
https://api.elaichi.ai/mcp -
4
Sign in and approve.
On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.
Snowflake MCP connector for Claude Code
-
1
In a terminal, run
claude mcp addwith the endpoint.https://api.elaichi.ai/mcp -
2
Start Claude Code and run
/mcp. -
3
Pick elaichi, then sign in and approve in the browser.
Terminal
$ claude mcp add --transport http elaichi --scope user https://api.elaichi.ai/mcp
Use --scope project instead to share it with the repository through .mcp.json.
Snowflake MCP connector for ChatGPT
-
1
Open Plugins, then press the + button.
-
2
Name it and paste the endpoint into Server URL.
https://api.elaichi.ai/mcp -
3
Leave Authentication on OAuth, then tick the risk acknowledgement.
-
4
Press Create, then sign in and approve.
Works on the web. The plugin directory lives at chatgpt.com/plugins.
Snowflake MCP connector for Cursor
-
1
Open
~/.cursor/mcp.json. -
2
Add the endpoint under
mcpServers.https://api.elaichi.ai/mcp -
3
Reload Cursor, then sign in and approve.
~/.cursor/mcp.json
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
Set up per machine, so repeat it on each computer you work from.
Snowflake MCP connector for Microsoft Copilot
-
1
In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.
-
2
Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.
https://api.elaichi.ai/mcp -
3
Create a new connection, sign in and approve, then press Add to agent.
-
4
Under Channels, open Teams and Microsoft Copilot and make the agent available in Microsoft Copilot.
- Server URL
- https://api.elaichi.ai/mcp
- Authentication
- OAuth 2.0
- Type
- Dynamic discovery
Microsoft Copilot was called Microsoft 365 Copilot. Keep the tool on end-user credentials, so each person signs in as themselves.
Connect Snowflake to any MCP client
-
1
Add the endpoint as a remote MCP server.
https://api.elaichi.ai/mcp -
2
Sign in and approve.
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
The Elaichi Agent already has these tools, with nothing to set up.
What teams do with Snowflake through Elaichi
Ask in plain English. Each person’s AI can do only what they’re allowed to, and every action it takes in Snowflake is logged.
-
Data engineering
Create a view without opening a worksheet
Describe the view you need and have it created in the right database and schema, then confirm it is there before pointing a dashboard at it.
-
Data platform
Onboard a new analyst in one ask
Create the Snowflake user, grant the right role and check the warehouse they will use, all from the same conversation that started with the hiring ticket.
-
Security
Review who holds which Snowflake roles
Pull the full list of Snowflake users and roles ahead of an access review, spot accounts that should have been removed and clean them up on the spot.
-
Analytics
Set up alerts on the numbers that matter
Create a Snowflake alert for a threshold your team watches, run it once to check the condition is right, then clone it for a second region.
-
Finance
See every warehouse before the bill arrives
List the warehouses in your Snowflake account, ask which ones were created recently, and stand up a properly sized one for a new project instead of reusing the biggest.
-
IT
Offboard a leaver cleanly from Snowflake
Remove the departed person's Snowflake user and the roles nobody else needs, and if an account was dropped by mistake, restore it without a support ticket.
Try asking
- “List Snowflake roles created in the last 30 days.”
- “Which Snowflake users have no role assigned?”
- “Show open Snowflake alerts by account.”
What connecting Snowflake gets you
6 screens from Elaichi, each doing one job for your Snowflake account.
Ask Elaichi to work across your apps.
List Snowflake roles created in the last 30 days.
Which Snowflake users have no role assigned?
Show open Snowflake alerts by account.
Also runs in Claude, ChatGPT, Cursor or Microsoft Copilot
The agent
Ask about Snowflake users in plain language.
Starter prompts return live answers from Snowflake users, roles, accounts and alerts.
Copy the endpoint
AI apps
Claude, ChatGPT, Cursor and Microsoft Copilot share one endpoint.
Every MCP client reaches Snowflake over OAuth, with no SDK and no shared key.
Tool catalog
205 Snowflake tools are ready to call.
Browse tool names, resources and methods for users, roles, accounts and alerts.
Toolboxes
Every team gets its own Snowflake toolbox.
Curate one toolbox per team, each scoped to the Snowflake work it does.
Shared connections
Teammates query Snowflake without touching credentials.
See who connected each Snowflake account and how many teams and members share it.
Audit log
Every Snowflake call is on the record.
When, who, what happened, type and resource for each role and account change.
From answering questions to doing the work
A trigger starts the work, inside the same permissions and the same audit log as everything else. Automations, collections and live dashboards come with the Black plan.
Snowflake digest
Run 418 · started 2 minutes ago · on behalf of Emily Carter
-
✓
Schedule
Every weekday at 8:00 AM
0.2s -
✓
Fetch users
Snowflake
1.4s -
✓
Group by owner
Transform
0.1s -
✓
Draft the digest
Agent step
Ran with 4 tools, returned a structured summary
6.2s -
Approve the digest
Needs approval
Assigned to Jake Morgan
Approve Deny -
Post the digest
Snowflake
Queued
Automations
A schedule drafts your Snowflake digest.
Fetch alerts, group them, draft a digest, get approval, post back to Snowflake.
Snowflake health
Refreshed 4 minutes ago · every 15 minutes · from the users collection
Users
1,284 ↓ 12%
Roles
96 ↓ 8%
Needs attention
3 ↑ 2
Updated this week
412 ↑ 9%
Users created
Last 14 days
By team
Share of activity
Data platform 34%
Analytics EMEA 27%
Security 21%
Finance 18%
Collections and dashboards
Snowflake health numbers arrive already computed.
Four metrics, 14 days of records created and a team breakdown, refreshed on schedule.
For IT and engineering
Elaichi vs Zapier MCP vs Composio for Snowflake
All three can connect Snowflake to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.
| What to check | Elaichi | Zapier MCP | Composio |
|---|---|---|---|
| Where the AI connects |
One address for the whole organization.
https://api.elaichi.ai/mcp
|
A server per member, created at sign-in. | An MCP endpoint per team, or an SDK. |
| Control over Snowflake tools | Allow or restrict single Snowflake tools, per role or user. | App and action restrictions on the account. | Role permissions, down to the action. |
| Record of calls | One audit entry per Snowflake call. | A History tab of tool calls. | A log of every tool call. |
| Single sign-on | SAML or OIDC, plus SCIM, on Gold. | SAML on Enterprise. | SAML and OIDC on Enterprise. |
| Price | Free for one person; $15 per user per month on Gold. | 2 tasks per successful call. | Billed per tool call. |
Sources: Zapier MCP docs, security, usage; Composio docs, gateway, enterprise, pricing. Checked September 2026.
Longer take: Zapier MCP alternative and when you don't need an MCP gateway.
Snowflake tools for your AI agents
205 tools are ready to call through Elaichi's MCP endpoint the moment you connect Snowflake, governed by the same roles, restrictions, and audit log as everything else in Elaichi.
No tools match your search.
Questions, answered
How do I connect Snowflake to Claude?
First connect Snowflake in Elaichi, then in Claude go to Customize, then Connectors, then Add, and paste the endpoint https://api.elaichi.ai/mcp. Snowflake requires an OAuth application registered inside your Snowflake account, so one administrator brings a client ID and secret once during setup; after that, everyone signs in to Snowflake with their normal username and password and nobody else touches a credential. Because Snowflake exposes a large number of actions, short concrete asks such as "list the warehouses" get better results than long paragraphs.
Does Snowflake work with ChatGPT and Cursor as well as Claude?
Yes. Once Snowflake is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, Microsoft Copilot, the Elaichi Agent and any other MCP client. You connect Snowflake once and every client you use picks it up.
What can an AI agent actually do with my Snowflake account?
With Snowflake connected, an AI agent can list, create, update and remove Snowflake users, list and create roles, list and create warehouses, create and look up views, and set up, run and clone alerts. It can also list Snowflake accounts, create new ones and restore an account that was dropped. It works on live records in your Snowflake account, so an answer about who has which role reflects what is true right now.
Does connecting Snowflake give the AI access to everything in my account?
No. Every action runs as the person who signed in to Snowflake, so the AI can only see and change what that person's own Snowflake roles already allow. Elaichi can narrow that further by restricting actions for a role, but it can never grant anything the person's Snowflake account does not already have.
Can I stop an agent from deleting or changing things in Snowflake?
Yes. Restrictions in Elaichi apply per action, so you can allow listing Snowflake users, roles and warehouses while restricting the actions that delete users, drop views or remove accounts. A restricted action still appears in Elaichi's tool search, flagged as restricted, but Claude, ChatGPT, Cursor, Microsoft Copilot or any other client cannot run it, whatever the prompt says.
What happens to a Snowflake connection when someone leaves?
When you offboard a person in Elaichi, their access to Snowflake through every AI client ends at once. A shared Snowflake connection keeps working for everyone else on the team. If you ever want to remove Snowflake entirely, disconnecting it once in Elaichi removes it from Claude, ChatGPT, Cursor, Microsoft Copilot and every other client at the same time.
Does the Snowflake MCP connector work with Gemini, Codex, Claude Code or other MCP clients?
Yes. Snowflake is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, Microsoft Copilot, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.
Is Elaichi an alternative to Zapier MCP for Snowflake?
Yes. Both let Claude, ChatGPT or Cursor use Snowflake. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every Snowflake call.
How is Elaichi different from Composio for Snowflake?
Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to Snowflake: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.
Put Snowflake in front of your team
14 days of Black, no credit card. Connect it once and pick what each team can call.
When the trial ends, nothing is deleted. You move to the free Personal plan, and connections, roles and the audit log stay where they are.
Add one link to your AI app
The same link for everyone on your team.
https://api.elaichi.ai/mcp
ChatGPT
Claude
Cursor
Microsoft Copilot