Back to connectors
Snowflake logo

Snowflake

FeaturedYour key

Run SQL against your Snowflake data warehouse and inspect its databases, schemas, and tables.

Needs your own Snowflake key. Included on Free.

What you can ask

  • “What does Snowflake have for the area or asset I'm working on?”
  • “Pull the most recent Snowflake records and put them in a table.”
  • “What does Snowflake cover, and how fresh is the data?”

Connect to your AI assistant

Paste this URL into Claude, ChatGPT, or any MCP client, then sign in when prompted. After you sign in, add your Snowflake key in PatchOps.

https://patchops.ai/api/mcp

Claude: use Add to Claude, or Settings > Connectors > Add custom connector and paste the URL.

Claude Code

claude mcp add --transport http patchops https://patchops.ai/api/mcp

Step by step

  1. 1

    Open connectors

    In Claude, open Settings > Connectors and click "Add custom connector".

  2. 2

    Paste the URL

    Name it PatchOps and paste https://patchops.ai/api/mcp as the server URL, then click Add.

  3. 3

    Sign in

    Click Connect and sign in to PatchOps when Claude asks.

  4. 4

    Start using

    Ask Claude a question. It uses Snowflake through PatchOps when it needs to.

› Technical details

Run SQL against your Snowflake data warehouse and inspect its databases, schemas, and tables.

View the data contract and method schemas →

Setup

A few steps to connect your AI agents to Snowflake.

Continue setup
  1. 1

    Create Your Account

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

  2. 2

    Add Snowflake Credentials

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

  3. 3

    Configure Your AI Agent

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

  4. 4

    Start Querying

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