Integration · Company data
Connect Claude & ChatGPT to Snowflake
Ask your AI a question about your data, and it writes and runs the SQL in Snowflake for you. It can run a statement in the warehouse, database, schema and role you choose, check on long-running queries, read large results page by page and cancel a query that takes too long. What it can read or change is limited by the Snowflake role behind your token.
Free plan, no credit card. Takes about a minute.
Try asking
“How many orders did we get per month this year?”
The AI writes a query that groups your orders by month, runs it and sums up the result.
“Which tables are in the ANALYTICS database?”
It runs a query against the database's information schema and lists the tables.
“Show the 20 customers with the most revenue last quarter, using the REPORTING warehouse.”
It runs the query in the warehouse you named and returns the rows.
What your AI can do
Run SQL
Run any SQL statement with the warehouse, database, schema and role you pick, right away or asynchronously for long queries.
Status and results
Check a statement's status and read large results one partition at a time.
Stay in control
Cancel statements that are still running. The Snowflake role on your token decides which data the AI can read or change.
“Run the full-year revenue query in the background and tell me when it is done.”
It submits the statement asynchronously, checks its status with the statement handle and fetches the result when it is ready.
“That result is large. Show me the next part.”
It reads the next partition of the result by statement handle.
“That query is taking too long, stop it.”
It cancels the running statement by its handle.
3 tools for Snowflake
These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.
cancel_statementDeletesCancel a statement that is still running, by `statement_handle`.get_statement_resultCheck the status of a submitted statement and fetch its results by `statement_handle`. Use `partition` to read further pages of a large result.run_sql_statementVisible to othersRun a SQL statement in Snowflake and return the results. Pass `statement` and optionally `warehouse`, `database`, `schema` and `role`; set `async` for long queries. The statement runs exactly as written, so INSERT, UPDATE, DELETE or DROP will change data permanently.
Set up in three steps
- 1
Pick the app
Create a free PipMCP account and choose Snowflake from the app list.
- 2
Paste your key
Enter your Snowflake account identifier as it appears in your account URL (the myorg-myaccount in myorg-myaccount.snowflakecomputing.com) and paste a programmatic access token. In Snowsight go to Governance & security > Users & roles, select your user, and under Programmatic access tokens click Generate new token, pick a role and an expiry, and copy it. By default the user must be covered by a network policy to use tokens, so make sure the policy allows PipMCP's servers.
- 3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
- Click your name, then Settings › Connectors › Add custom connector.
- Paste your link as the Remote MCP server URL.
- Switch it on from the + menu in a chat.
Questions
What can the AI do in Snowflake?
It can run SQL statements in your Snowflake account, check the status of a statement, read its results page by page and cancel a statement that is still running. There is no separate tool per table: everything goes through SQL, within what the token's role allows.
Does the AI see my Snowflake access token?
No. You paste your Snowflake access token into PipMCP once. It is encrypted at rest, never shown to the AI and never shown again after you save it. The AI only gets the results of the tools you have switched on.
Can I control what the AI is allowed to do?
Yes. You choose which tools are switched on. run_sql_statement runs SQL exactly as written, so an INSERT, UPDATE, DELETE or DROP changes data permanently. You can require your approval before each statement runs, and every tool call is logged.
Does it work with ChatGPT?
Yes. In ChatGPT, open Settings › Apps & Connectors › Advanced, turn on Developer mode and add your PipMCP link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.
What does it cost?
PipMCP has a free plan, and you do not need a credit card to start. Paid plans are billed per completed task. Queries run on your own Snowflake account, so anything Snowflake charges is between you and Snowflake.
How do I keep the AI read-only?
Generate the token with a Snowflake role that can only read the data you want the AI to see. Snowflake then refuses any statement that role is not allowed to run, whatever the AI sends. You can also require your approval for run_sql_statement in PipMCP, so you see each statement before it runs.
Related integrations
Let your AI work in Snowflake today.
Start free. Your key stays encrypted, and you decide what the AI may do.
Connect Snowflake freePipMCP is not affiliated with Snowflake. Product names are trademarks of their owners.