Skip to main content
Back to the Snowflake MCP server

MCP Gateway · ChatGPT

Snowflake icon

Connect Snowflake to ChatGPT

Sales and finance teams can ask ChatGPT questions that need live Snowflake data. A ChatGPT workspace admin decides which roles get the Snowflake plugin, and the Speakeasy MCP Gateway logs every query against the person who asked it. ChatGPT itself never holds a Snowflake credential.

Category
Data & analytics
Tools
3
Authentication
OAuth
ChatGPT
Web, desktop and mobile

Behind the MCP Gateway

Run Snowflake MCP behind the MCP Gateway

One URL for every agent, sign-in through your IdP, RBAC down to the tool, and every Snowflake call inspected and logged.

Deploy on MCP Gateway

Set up

Add Snowflake to ChatGPT in 4 steps

  1. 01

    Add Snowflake from the catalog

    An admin finds Snowflake in the MCP Catalog (MCP Gateway > MCP > Catalog) and clicks Add. Speakeasy registers the vendor's server as a remote MCP server and proxies sessions to it. Nothing is copied or re-hosted.

    Snowflake uses OAuth. Servers that support dynamic client registration get their OAuth configuration applied automatically.

    Where MCP-scoped policies are enabled, the install offers a recommended risk policy for the new server that detects secrets and PII and inspects tool requests and responses.

  2. 02

    Choose who can use Snowflake

    Give teams the mcp:connect scope on the Snowflake server through team access or a role. ChatGPT connects to the Snowflake server's own URL, and the server's authorization decides who can connect and which tools they can call.

  3. 03

    Connect ChatGPT

    Import the organization's plugin marketplace into the ChatGPT workspace and set who gets each plugin.

    New MCP servers join the project's default plugin automatically. Each server's overview page shows which plugin it is published to, with Publish or Update to change it.

    Give the importing workspace admin collaborator access to the marketplace repository, and connect their GitHub account in ChatGPT under Plugins > GitHub > Manage.

    In ChatGPT, open Admin > Plugins > Add > Import marketplace.

    Set each plugin's installation policy, Installed or Available, per role.

    Enable the MCP servers the plugin connects to.

  4. 04

    Sign in and use Snowflake from ChatGPT

    The first time ChatGPT connects, it opens a browser so the person can sign in to Speakeasy through your identity provider.

    Snowflake needs its own OAuth grant, so each person connects it once. Until they do, Snowflake calls fail while the rest of the gateway keeps working.

    From then on, Snowflake's tools appear in ChatGPT, limited to what the person's access allows, and every call lands in the gateway's tool logs.

The marketplace syncs from GitHub once a day. Use Sync now to pick up a change straight away.

Use cases

What ChatGPT users do with Snowflake

Pull pipeline figures for a forecast

Ask ChatGPT for this quarter's deals by stage, and it runs the query in Snowflake and lays the figures out as a table for your forecast.

query

Check customer usage before a renewal

Before a renewal call, ChatGPT queries the customer's usage over the last six months and summarizes the trend in a few lines you can bring to the conversation.

query

Stop a question that runs too long

If a request turns into a heavy query, ChatGPT can cancel the running statement instead of leaving it to run.

cancel_statement

Tools

3 tools

Each Snowflake tool can be allowed or denied per team and role at the MCP Gateway before ChatGPT sees it.

cancel_statement

Cancel a running Snowflake statement by handle.

get_statement

Fetch the status and results of a previously submitted Snowflake statement by handle. Use this after submitting a query with async=true, or to page through large result sets via the partition parameter.

query

Run a SQL statement against Snowflake. Supports overriding warehouse/database/schema/role per call, session parameters, server-side timeout, and async submission (returns a statementHandle to fetch later via get_statement).

Control

What Speakeasy can see and stop in ChatGPT

The gateway covers every client the same way. The rest depends on what ChatGPT exposes to Speakeasy.

Tool logs

Gateway

Every Snowflake call is logged with the person and the client that made it.

Access by role

Gateway

People reach only the Snowflake tools their team or role allows.

Request and response blocking

Gateway

A risk policy scoped to Snowflake can reject a tool request before it reaches the server, or withhold a result from ChatGPT. MCP-scoped policies are enabled per organization.

Conversation import

ChatGPT

ChatGPT activity can be imported through OpenAI's Compliance API for review after the fact. It can't block in real time.

  • The workspace import needs a ChatGPT Business, Enterprise or Edu admin.

Questions

Frequently asked questions

Can Speakeasy block a Snowflake query from ChatGPT in real time?
No. ChatGPT activity can be imported through OpenAI's Compliance API for review after the fact, but it can't be blocked in real time. Limit which Snowflake tools a role can call at the gateway instead.
Who can set up the Snowflake plugin in ChatGPT?
The workspace import needs a ChatGPT Business, Enterprise or Edu admin. That admin imports the marketplace under Admin > Plugins > Add > Import marketplace and sets each plugin's installation policy per role.
How do ChatGPT users get Snowflake?
An admin adds Snowflake from the Speakeasy MCP Catalog and grants access by team or role. Import the organization's plugin marketplace into the ChatGPT workspace and set who gets each plugin. Each person then sees only the Snowflake tools their access allows.
Are Snowflake calls from ChatGPT logged?
Yes. Snowflake calls go through the MCP Gateway, which logs each tool call and attributes it to the person and the client that made it.

Connect more

Snowflake in other clients

AI everywhere.

Control here.