Back to Connectors
Snowflake logo

Snowflake

featured
Live

Snowflake cloud data platform integration for scalable data storage, processing, and analytics with SQL execution capabilities.

What is Snowflake?

Snowflake cloud data platform integration for scalable data storage, processing, and analytics with SQL execution capabilities. Execute SQL queries, explore databases, tables, and schemas directly from your AI agent.

Available Tools

  • Execute SQL
    Execute SQL queries on your Snowflake data warehouse
  • List databases
    List all accessible databases in your Snowflake account
  • List tables
    List tables in a specific database and schema
  • Describe table
    Get detailed schema information for a table including columns and data types

Requirements

  • Snowflake account
    Active Snowflake account identifier (e.g., xy12345.us-east-1)
  • Snowflake credentials
    Username and password or access token for authentication
  • Compatible AI agent
    Works with Claude, ChatGPT, and other MCP-compatible agents

Quick Setup Guide

Follow these steps to connect your AI agents to this connector

Sign up for PatchOps to access our MCP server management platform.

Navigate to the Dashboard and add your Snowflake account identifier, username, and password to establish the connection.

Add the Snowflake MCP server URL to your AI agent's configuration file.

Begin asking your AI agent to query your Snowflake data warehouse using natural language.

Connect to Your AI Assistant

Choose your AI assistant below for specific setup instructions

Follow these steps to connect Snowflake to Claude:

Step 1: Open Claude Settings

Launch Claude → Click the profile button (bottom left) → Navigate to Settings

Step 2: Access Connectors

Scroll down to the Connectors tab → Navigate to the bottom → Click “Add Custom Connector”

Step 3: Name Your Connector

Enter any name you'd like for this connector

Step 4: Get the Connector URL

Log in to PatchOps → Navigate to the /mcp page → Copy the connector URL you want to use

Step 5: Add the Connector

Paste the URL in the “Remote MCP Server URL” text box → Click Add

Step 6: Start Using

Your connector is now ready to use in Claude

Follow these steps to connect Snowflake to ChatGPT:

Step 1: Enable Developer Mode

Go to Settings → Connectors → Advanced → Enable Developer mode

Step 2: Create New Connector

Go back to Connectors page → Click “Create” (top right)

Step 3: Name Your Connector

Enter any name you'd like for this connector (descriptions are optional)

Step 4: Get the Connector URL

Log in to PatchOps → Navigate to the /mcp page → Copy the connector URL you want to use

Step 5: Add the URL

Paste the URL in the “MCP Server URL” text box

Step 6: Set Authentication

Click the authentication dropdown → Select “No authentication” (PatchOps handles authentication internally)

Step 7: Create the Connector

Click “I understand and want to continue” checkbox → Press Create

Step 8: Using the Connector

Start a new chat → Click the + button (left of text box) → Open dropdown → Hover over three dots labeled “More” → Select your connector

Instructions for connecting Snowflake to GitHub Copilot:

Coming Soon

Detailed setup instructions for GitHub Copilot will be added here.

For other MCP-compatible platforms:

Step 1: Get the Connector URL

Log in to PatchOps → Navigate to the /mcp page → Copy the connector URL you want to use

Step 2: Add to Configuration

Add this configuration to your MCP settings file. Replace the URL with your specific connector URL from the /mcp page:

"Snowflake-MCP": {
  "url": "https://...patchops.ai/mcp/...",
  "type": "http"
}

Example Configuration

Here’s an example using Cambria-MCP:

"Cambria-MCP": {
  "url": "https://cambria.patchops.ai/mcp/...",
  "type": "http"
}