Skip to content

Database

Snowflake MCP connector

The Snowflake connector lets Claude, ChatGPT, Cursor 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.

  • How it connects. Connects over OAuth. The credential goes into a vault nobody reads back.

  • One address. https://api.elaichi.ai/mcp, the same for every user.

  • Their own access. An agent never gets more than the person it acts for.

How to connect

How to connect Snowflake to Claude, ChatGPT or Cursor

Two steps, about a minute.

1

In Elaichi

Connect Snowflake once

  1. Open Connections, choose Add connection, and pick Snowflake.

  2. Optionally set Share with to give a team access, then press Connect.

  3. Supply your own Snowflake app, then approve. Snowflake needs an OAuth app you register yourself, so bring its client ID and secret. One person does this once for the organization.

The credential is vaulted. Nobody reads it back, not even the AI.

Add connection

Choose a connector.

snowflake
Snowflake
1Password
360learning
7shifts
Acquire
Ada
2

In your AI client

Point it at one endpoint

Everyone in the organization uses the same address, and each person only ever reaches what their own account allows.

Connect Snowflake to 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.

Connect Snowflake to 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 today. The plugin directory lives at chatgpt.com/plugins.

Connect Snowflake to 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.

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.

Use cases

What teams do with Snowflake through Elaichi

Every one of these runs inside the access the person already has, and lands in the same audit log.

  • 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 below

AI tools

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.

See it in Elaichi

What connecting Snowflake gets you

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

The agent

Ask about Snowflake users in plain language.

Starter prompts return live answers from Snowflake users, roles, accounts and alerts.

  • users
  • roles
  • accounts
  • alerts

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 or Cursor

MCP clients

Claude, ChatGPT and Cursor share one endpoint.

Every MCP client reaches Snowflake over OAuth, with no SDK and no shared key.

ElaichiMCP clients
Claude ChatGPT Cursor

Copy the endpoint

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

Emma Laurent

• Connected 4 minutes ago
Cursor
S

Sofia Ricci

• Connected 2 hours ago
ChatGPT
C

Clara Nowak

• Connected Yesterday

Tool catalog

205 Snowflake tools are ready to call.

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

  • List all Snowflake users
  • Get single Snowflake user by ID
  • Delete a Snowflake user by ID
  • Create a Snowflake user
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.

Toolboxes

Every team gets its own Snowflake toolbox.

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

  • Data platform
  • Analytics engineering
  • Security
  • Finance
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

Shared connections

Teammates query Snowflake without touching credentials.

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

  • Data platform
  • Analytics EMEA
  • Security
  • Finance
ElaichiConnections
Connection Scope Status Access
SN

Snowflake (Data platform)

Connected by Emma Laurent

Personal • Active 1 team · 6 members
SN

Snowflake (Analytics EMEA)

Connected by James Whitfield

Organization • Active 3 teams · 24 members
SN

Snowflake (Security)

Connected by Sofia Ricci

Organization • Active 2 teams · 11 members
SN

Snowflake (Finance)

Connected by Daniel Ortega

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

Snowflake (Support)

Connected by Clara Nowak

Personal • Active Not shared
SN

Snowflake (Sandbox)

Connected by Michael Brennan

Personal • Active 2 teams · 9 members

Audit log

Every Snowflake call is on the record.

When, who, what happened, type and resource for each role and account change.

  • When
  • Who
  • What happened
  • Type
ElaichiAudit log
When Who What happened Type

2 minutes ago

Mar 6, 2026, 3:10 PM

E

Emma Laurent

[email protected]

Restriction Created Access

8 minutes ago

Mar 6, 2026, 3:04 PM

J

James Whitfield

[email protected]

Restriction Updated Access

14 minutes ago

Mar 6, 2026, 2:58 PM

S

Sofia Ricci

[email protected]

Role Assigned Access

20 minutes ago

Mar 6, 2026, 2:52 PM

D

Daniel Ortega

[email protected]

Snowflake Users Updated MCP

26 minutes ago

Mar 6, 2026, 2:46 PM

C

Clara Nowak

[email protected]

Snowflake Users Created MCP

32 minutes ago

Mar 6, 2026, 2:40 PM

M

Michael Brennan

[email protected]

Snowflake Users List Toolbox

Launching soon

From answering questions to doing the work

A person no longer has to ask. A trigger starts the work, inside the same permissions and the same audit log as everything else. Automations and live dashboards are launching soon, on the Black plan.

Automations

A schedule drafts your Snowflake digest.

Fetch alerts, group them, draft a digest, get approval, post back to Snowflake.

Snowflake digest

Run 418 · started 2 minutes ago · on behalf of Emma Laurent

  1. Schedule

    Every weekday at 08:00

    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 Michael Brennan

    Approve
  6. Post the digest

    Snowflake

    Queued

Collections and dashboards

Snowflake health numbers arrive already computed.

Four metrics, 14 days of records created and a team breakdown, refreshed on schedule.

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%

FAQ

Frequently asked questions

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, 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 hiding actions from a team, 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 blocking the actions that delete users, drop views or remove accounts. A blocked action is never shown to Claude, ChatGPT, Cursor or any other client, so no prompt, however worded, can reach it.

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 and every other client at the same time.

Put Snowflake in front of your team

Fourteen days on Gold, no credit card. Connect it once and pick what each team can call.