Skip to content

Snowflake MCP and API

Snowflake provides SQL queries, warehouse data and schema access in an authorized account. An agent can query warehouse tables and inspect database schemas. Add your SNOWFLAKE_MCP_URL and SNOWFLAKE_PAT when you install the Snowflake MCP server in Longwave.

Add to Longwave

Install elsewhere

Install Snowflake

Choose a harness. These instructions connect to the hosted MCP endpoint shown on this page.

Claude Code

Run this in your terminal. It adds a user-scoped server; use --scope project instead if it should apply only to the current project.

terminal
claude mcp add --scope user --transport http --header 'Authorization: Bearer YOUR_SNOWFLAKE_PAT' snowflake env:SNOWFLAKE_MCP_URL

Replace each YOUR_… value with the required secret before running the command.

access
Your key

Use Snowflake on Longwave

  1. Download Longwave or open app.longwave.run.
  2. Add your SNOWFLAKE_MCP_URL and SNOWFLAKE_PAT when you install the Snowflake MCP server in Longwave.
  3. Ask for the result in any thread, for example: “Inspect a warehouse table before writing SQL”. The agent picks the Snowflake function and calls it.

Use cases

Questions people ask

What can a Snowflake MCP connection query?

A SQL tool uses a Snowflake connection to query permitted data. Snowflake roles and grants determine the accessible databases, schemas and tables. Snowflake documentation

Does Snowflake separate compute and storage charges?

Snowflake prices compute and storage separately. Compute charges depend on the resources used, while storage charges depend on stored data. Snowflake documentation

How do I add the Snowflake MCP server to Claude Code?

Run claude mcp add --transport http snowflake env:SNOWFLAKE_MCP_URL in a terminal. Add your SNOWFLAKE_MCP_URL and SNOWFLAKE_PAT when you install the Snowflake MCP server in Longwave.

Who publishes the Snowflake MCP server?

Snowflake publishes the Snowflake MCP server that Longwave installs.

Use Snowflake in Longwave

Call Snowflake from any agent thread, on your machine or in the cloud.

Add to Longwave