Skip to Content

Snowflake

Connect to Snowflake’s official MCP server to use the tools configured on that server in chat.

Key features

  • Use tools configured on the Snowflake MCP server
  • Sign in to Snowflake with OAuth
  • Access data allowed by your Snowflake role

Basic information

Authentication

This integration uses OAuth 2.0. Sign in and authorize access on the Snowflake page. For the older username and password connection, see Snowflake (Legacy).

Required information

  • MCP Server URL: The URL of your Snowflake MCP server, including its database, schema, and server name.
  • OAuth Client ID: The client ID of the Snowflake OAuth Security Integration.
  • OAuth Client Secret: The secret of that integration.

If an administrator has preconfigured the integration, the client ID and secret fields may be hidden.

Available MCP tools

The tools depend on the Snowflake MCP server configuration. If SQL execution is configured, you can query data your role permits. To enable SQL execution, include SYSTEM_EXECUTE_SQL in the server’s tool configuration. See the Snowflake MCP guide . Check the server configuration and your Snowflake role if a tool is missing.

Connect to Snowflake

  1. Ask your Snowflake administrator for the MCP Server URL, OAuth Client ID, and Client Secret. If the server has not been created, configure the required tools using the Snowflake MCP guide .
  2. In Integrations > All Integrations, select Snowflake.
  3. Register the Callback URL shown on the connection page in the Snowflake OAuth Security Integration. Use the URL shown for your environment; send it to your administrator if they manage the configuration.
  4. Enter the MCP Server URL, OAuth Client ID, and OAuth Client Secret. Example URL: https://<account>.snowflakecomputing.com/api/v2/databases/<database>/schemas/<schema>/mcp-servers/<server>.
  5. Click Connect & Install, then authorize the connection on the Snowflake sign-in page.
  6. Check the available tools. If an expected tool is missing, ask your administrator to check the server configuration and your Snowflake permissions.
Last updated on