Skip to main content
Snowflake is a cloud data platform for analytics and data warehousing. The Snowflake MCP server lets you run SQL queries and inspect table schemas using natural language.

​
What Can It Do?

  • Run SQL queries and return structured results
  • Describe table schemas to understand your data
  • Bulk load data into tables via staging
  • Tag queries for tracking in Snowflake’s query history
  • Power analytics workflows with live data

​
Where to Use It

Add Snowflake as a tool to any agent. The agent can then query your data warehouse conversationally, choosing the right actions based on context. To add an MCP tool to your agent:
  1. Open your agent’s configuration
  2. Click Add tools → Connect an app with MCP
  3. Search for the integration and select it
  4. Authenticate with your account
You can control which tools your agent has access to. After adding an integration, click on it to enable or disable specific tools based on what your agent needs.

​
In Workflows (Via Agent Node)

For automated pipelines, use an Agent Node with Snowflake tools. This gives you the flexibility of an agent within a deterministic workflow.

​
As a Custom MCP Node

You can also create a standalone MCP node for a specific action. This generates a reusable node that performs one task, useful when you need the same operation repeatedly in workflows.
To create a custom MCP node:
  1. Go to your node library and search for the integration
  2. Click Create a node with AI
  3. Describe the specific action you want (e.g., “Query orders from last month”)
  4. Test the node and save it for reuse
Custom MCP nodes are single-purpose by design. For tasks that require multiple steps or dynamic decision-making, use an agent instead.

​
Available Tools

​
Example Prompts

Use these with your agent or in the Agent Node: Query data:
Check table schema:
Aggregate data:
Run custom SQL:
Run a tagged query:
Bulk load data:

​
Configuration Options

Only enable insecure_mode if you are experiencing OCSP-related errors (e.g., error code 254007) when downloading large result sets. This disables certificate revocation checks on S3 result retrieval.

​
Troubleshooting

Agents are smart enough to chain multiple API calls together. For example, asking “Query the sales table” will describe it first to understand the schema, then run the query. If results seem off, check the agent’s step-by-step reasoning.

​
Need Help?

Use this integration directly in Claude or Cursor. Connect remotely via the Snowflake MCP server using credentials from your Connectors page.