Skip to content

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
ChatGPT Elaichi connected

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
Ask anything…
Governance / Audit log Last 24 hours
Snowflake List all Snowflake roles Emily Carter · ChatGPT · 9:41 AM Done
Snowflake Get single Snowflake user by ID Emily Carter · ChatGPT · 9:41 AM Done
Snowflake List all Snowflake users Emily Carter · ChatGPT · 9:41 AM Done
Snowflake Create a Snowflake user Megan Brooks · Claude · 9:38 AM Done
Snowflake Update a Snowflake user by ID Ryan Hayes · Cursor · 9:35 AM Done

How to connect Snowflake to Claude, ChatGPT, Cursor or Microsoft Copilot

Step by step, for each AI app

Snowflake MCP connector for Claude

  1. 1

    Open Customize, then Connectors.

  2. 2

    Press Add.

  3. 3

    Name it, paste the MCP server URL, then Continue.

    https://api.elaichi.ai/mcp
  4. 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. 1

    In a terminal, run claude mcp add with the endpoint.

    https://api.elaichi.ai/mcp
  2. 2

    Start Claude Code and run /mcp.

  3. 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. 1

    Open Plugins, then press the + button.

  2. 2

    Name it and paste the endpoint into Server URL.

    https://api.elaichi.ai/mcp
  3. 3

    Leave Authentication on OAuth, then tick the risk acknowledgement.

  4. 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. 1

    Open ~/.cursor/mcp.json.

  2. 2

    Add the endpoint under mcpServers.

    https://api.elaichi.ai/mcp
  3. 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. 1

    In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.

  2. 2

    Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.

    https://api.elaichi.ai/mcp
  3. 3

    Create a new connection, sign in and approve, then press Add to agent.

  4. 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. 1

    Add the endpoint as a remote MCP server.

    https://api.elaichi.ai/mcp
  2. 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.”

See all 205 Snowflake tools →

What connecting Snowflake gets you

6 screens from Elaichi, each doing one job for your Snowflake account.

Elaichi Agent

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.

ElaichiAI apps
Claude ChatGPT Cursor Microsoft Copilot

Copy the endpoint

https://api.elaichi.ai/mcp
Client Connected by Status Last used
Claude
E

Emily Carter

• Connected 4 minutes ago
Cursor
M

Megan Brooks

• Connected 2 hours ago
ChatGPT
R

Ryan Hayes

• Connected Yesterday

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.

ElaichiTools
Tool Action Description
List all Snowflake users List Use this endpoint to retrieve a list of all users.
Get single Snowflake user by ID Get Use this endpoint to retrieve data for a single user. It always requires an ID to fetch.
Delete a Snowflake user by ID Delete Use this endpoint to delete a user. It always requires an ID to delete.
Create a Snowflake user Create Create a user in Snowflake with the required name parameter and optional createMode query parameter. Returns user creation status and details including name, email, and roles.
Update a Snowflake user by ID Update Update a user in Snowflake by specifying the id. Returns the status of the request, indicating success or acceptance for processing.

Tool catalog

205 Snowflake tools are ready to call.

Browse tool names, resources and methods for users, roles, accounts and alerts.

ElaichiToolboxes
Name Source template Tools Created

Data platform toolbox

Snowflake · warehouses and accounts

Snowflake starter 18 Mar 4, 2026

Analytics engineering toolbox

Snowflake · roles and grants

— 9 Mar 2, 2026

Security toolbox

Snowflake · users and access reviews

— 24 Feb 27, 2026

Finance toolbox

Snowflake · account usage and spend

Snowflake starter 6 Feb 19, 2026

Support toolbox

Snowflake · alerts and incidents

— 31 Jan 30, 2026

Product analytics toolbox

Snowflake · read-only queries

— 12 Jan 22, 2026

Toolboxes

Every team gets its own Snowflake toolbox.

Curate one toolbox per team, each scoped to the Snowflake work it does.

ElaichiConnections
Connection Scope Status Access
SN

Snowflake (Data platform)

Connected by Emily Carter

Personal • Active 1 team · 6 members
SN

Snowflake (Analytics EMEA)

Connected by Jake Morgan

Organization • Active 3 teams · 24 members
SN

Snowflake (Security)

Connected by Megan Brooks

Organization • Active 2 teams · 11 members
SN

Snowflake (Finance)

Connected by Tyler Reed

Personal • Needs re-auth 1 team · 3 members
SN

Snowflake (Support)

Connected by Ryan Hayes

Personal • Active Not shared
SN

Snowflake (Sandbox)

Connected by Ashley Parker

Personal • Active 2 teams · 9 members

Shared connections

Teammates query Snowflake without touching credentials.

See who connected each Snowflake account and how many teams and members share it.

ElaichiAudit log
When Who What happened Type

2 minutes ago

Mar 6, 2026, 3:10 PM

E

Emily Carter

[email protected]

Restriction Created Access

8 minutes ago

Mar 6, 2026, 3:04 PM

J

Jake Morgan

[email protected]

Restriction Updated Access

14 minutes ago

Mar 6, 2026, 2:58 PM

M

Megan Brooks

[email protected]

Role Assigned Access

20 minutes ago

Mar 6, 2026, 2:52 PM

T

Tyler Reed

[email protected]

Snowflake Users Updated MCP

26 minutes ago

Mar 6, 2026, 2:46 PM

R

Ryan Hayes

[email protected]

Snowflake Users Created MCP

32 minutes ago

Mar 6, 2026, 2:40 PM

A

Ashley Parker

[email protected]

Snowflake Users List Toolbox

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

  1. ✓

    Schedule

    Every weekday at 8:00 AM

    0.2s
  2. ✓

    Fetch users

    Snowflake

    1.4s
  3. ✓

    Group by owner

    Transform

    0.1s
  4. ✓

    Draft the digest

    Agent step

    Ran with 4 tools, returned a structured summary

    6.2s
  5. Approve the digest

    Needs approval

    Assigned to Jake Morgan

    Approve
  6. 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

Live

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.

Elaichi compared with Zapier MCP and Composio for Snowflake, by what to check
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.

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 my team share one Snowflake connection?

Yes. One administrator connects Snowflake in Elaichi and shares the connection with a team, and nobody else has to handle the OAuth client details or any other credential. Each teammate still signs in to Snowflake as themselves, so every user created or warehouse changed is logged against the person who did it.

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