How to connect Snowflake to Claude

Claude is Anthropic's AI assistant, available on the web, in the desktop app, and on mobile. Cowork is its agent for knowledge work, and it runs on all of those surfaces too. Connected to your apps, Claude can work with your files and services to accomplish complex tasks on your behalf.

This guide walks you through the easiest and most secure way to connect your Snowflake account to Claude via Composio Connect, enabling it to run a SQL query to list today's new users, cancel a long-running data import statement, show all unresolved incidents in Snowflake, and more such actions on your behalf without compromising your account security.

Setup is the same on Claude Web, Desktop, and Cowork, and you only need to do it once. The connector is tied to your account, so it's available in all three.

Connecting Snowflake to Claude Web, Desktop, and Cowork

Two ways to add the Composio connector. Pick whichever you prefer.

1. Add with one click

Click the button. Claude opens with the Composio connector filled in. Click Add, then go to step 2.

Add to Claude

Add manually

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Click Add custom connector and paste in the Composio MCP server URL:

The Snowflake MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Snowflake account. It provides structured and secure access to your cloud data warehouse, so your agent can run complex SQL queries, monitor system health, check scheduled maintenances, and manage incidents seamlessly—no manual intervention needed.

• Automated SQL execution and data retrieval: Direct your agent to execute SQL statements and instantly fetch query results from your data warehouse.
• Query management and cancellation: Have your agent monitor and cancel long-running or stuck SQL statements to keep your workflows running smoothly.
• Maintenance and system status monitoring: Let your agent check for active, upcoming, or completed scheduled maintenances and get real-time updates on system components.
• Incident detection and reporting: Enable your agent to retrieve unresolved incidents and receive summaries of any issues currently affecting your Snowflake environment.
• Integration metadata access: Fetch details about catalog integrations and system status rollups so your agent can keep tabs on the overall health of your Snowflake setup.