X (Twitter)LinkedInGitHubDiscordYouTube

How to connect Snowflake Basic to Claude

Connect Claude Web, Desktop and Cowork to Snowflake Basic MCP. Run a sql query for daily sales, list all tables in your warehouse, and more using natural language, with authentication handled for you.

Get started for freeGet a demo
Snowflake Basic logoSnowflake Basic
Basic

Snowflake is a cloud-based data warehouse for scalable analytics and secure data sharing. It lets you run fast SQL queries and manage massive datasets in the cloud.

6 Tools

Introduction

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 Basic account to Claude via Composio Connect, enabling it to run a SQL query for daily sales, list all tables in your warehouse, add a new record to customers table, 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.

Also integrate Snowflake Basic with

Claude CodeCursorChatGPTAntigravityOpenAI Agents SDKClaude Agent SDKCodexGrok BuildVS CodeOpenCodeOpenClawHermesAtomic AgentGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAIPydantic AIAutoGen

Connecting Snowflake Basic 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.

Claude Desktop connectors screen with Add custom connector selected

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

bash
https://connect.composio.dev/mcp
Add custom connector dialog with Composio MCP server URL

2. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Web, Desktop, and Cowork

3. Connect your Snowflake Basic account

Back in Claude, ask it to connect to Snowflake Basic or give it any Snowflake Basic-related task.

For example, ask Claude to:

  • "Run a SQL query for daily sales"
  • "List all tables in your warehouse"
  • "Add a new record to customers table"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Claude, and your Snowflake Basic account is ready to use.

What is the Snowflake Basic Claude Connector, and what's possible with it?

The Snowflake Basic 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 Basic account. It provides structured and secure access so your agent can perform Snowflake Basic operations on your behalf.

Troubleshooting

1. Why does Claude not use the Composio connector for Snowflake Basic?

The connector can show as connected, but Claude must use it in each Snowflake Basic conversation.

  • Click + at the lower left of the chat, or type /.
  • Hover Connectors.
  • Turn on Composio.
  • Ask Claude to connect to Snowflake Basic again.

2. Why does Claude show an MCP server error before Snowflake Basic connects?

Claude can show Couldn't reach the MCP server or Authorization with the MCP server failed when you add the connector for Snowflake Basic.

  • Check that the connector URL is https://connect.composio.dev/mcp.
  • Connectors run from Anthropic's cloud, so your device network is usually not the problem.
  • Add the connector again from Customize > Connectors, then ask Claude to connect Snowflake Basic.
  • If it fails again, send the error and the ofid_ reference id to support@composio.dev.

3. Why does the Snowflake Basic authorization link not work?

The Composio connector is one server. Your Snowflake Basic account connects separately when Claude asks for it.

  • If the browser does not open, or the link expires, ask Claude to retry the Snowflake Basic connection.
  • Composio creates a fresh Snowflake Basic authorization link.
  • Open that link in your browser and finish the Snowflake Basic sign-in.

4. Why do Snowflake Basic actions fail after they worked before?

The Snowflake Basic connection can expire or lose permission.

  • Ask Claude to inspect the Snowflake Basic connection.
  • If the connection is unhealthy, disconnect it when Claude prompts you.
  • Reconnect the Snowflake Basic account and retry the action.
  • If Claude shows a permission prompt, approve it before Claude changes data in Snowflake Basic.
  • If the action still fails with a permission error, check that the connected account has that permission in Snowflake Basic itself.

5. How do I switch to a different Snowflake Basic account?

Claude can manage the Snowflake Basic connection for you.

  • Ask Claude to disconnect or delete the current Snowflake Basic account.
  • Ask Claude to connect Snowflake Basic again.
  • Open the new Composio authorization link for Snowflake Basic.
  • Sign in with the other Snowflake Basic account in the browser.
  • After the account connects, ask Claude to retry the Snowflake Basic task.

6. Why is my Snowflake Basic connection missing in Claude Desktop or on a Team plan?

The connector belongs to your Claude account, so your Snowflake Basic connection works in Claude Web, Desktop, and Cowork.

  • In Claude Desktop, open Customize > Connectors.
  • Next to Composio, click ⋮ and click Clear cache.
  • If Snowflake Basic tools still do not appear, click ⋮, disconnect, remove the connector, and add it again.
  • On Team or Enterprise, an Owner or Primary Owner must enable the connector before you can connect Snowflake Basic.
TOOLS

Supported Tools

Every Snowflake Basic action and event your agent gets out of the box.

Describe table

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.

Explore Columns

Retrieves a sample of distinct values for specified columns from a Snowflake table.

Run Query

Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Show databases

Retrieves a list of all databases available in the Snowflake account.

Show schemas

Retrieves a list of all schemas within a specified Snowflake database.

Show Tables

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

FRAMEWORKS

How to build Snowflake Basic MCP Agent with another framework

Claude Code logo

Claude Code

Use Snowflake Basic MCP with Claude Code

Cursor logo

Cursor

Use Snowflake Basic MCP with Cursor

ChatGPT logo

ChatGPT

Use Snowflake Basic MCP with ChatGPT

Antigravity logo

Antigravity

Use Snowflake Basic MCP with Antigravity

OpenAI Agents SDK logo

OpenAI Agents SDK

Use Snowflake Basic MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use Snowflake Basic MCP with Claude Agent SDK

Codex logo

Codex

Use Snowflake Basic MCP with Codex

Grok Build logo

Grok Build

Use Snowflake Basic MCP with Grok Build

VS Code logo

VS Code

Use Snowflake Basic MCP with VS Code

OpenCode logo

OpenCode

Use Snowflake Basic MCP with OpenCode

OpenClaw logo

OpenClaw

Use Snowflake Basic MCP with OpenClaw

Hermes logo

Hermes

Use Snowflake Basic MCP with Hermes

Atomic Agent logo

Atomic Agent

Use Snowflake Basic MCP with Atomic Agent

Google ADK logo

Google ADK

Use Snowflake Basic MCP with Google ADK

LangChain logo

LangChain

Use Snowflake Basic MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Snowflake Basic MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Snowflake Basic MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Snowflake Basic MCP with LlamaIndex

CrewAI logo

CrewAI

Use Snowflake Basic MCP with CrewAI

Pydantic AI logo

Pydantic AI

Use Snowflake Basic MCP with Pydantic AI

AutoGen logo

AutoGen

Use Snowflake Basic MCP with AutoGen

FAQ

Frequently asked questions

With a standalone Snowflake Basic MCP server, the agents and LLMs can only access a fixed set of Snowflake Basic tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Snowflake Basic and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Claude Cowork fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Snowflake Basic tools.

Yes, absolutely. You can configure which Snowflake Basic scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Snowflake Basic data and credentials are handled as safely as possible.

Start with Snowflake Basic.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Snowflake Basic tool your agent needs.Free to start.

Start building