Snowflake MCP server

Connect Snowflake to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Snowflake MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the manage task tool in Snowflake
  • Use the manage warehouse tool in Snowflake
  • Use the check statement status tool in Snowflake
  • Use the manage role tool in Snowflake
  • Use the manage user tool in Snowflake
  • Use the manage grant tool in Snowflake

Supported Tools

manage_task

Manage Task

Create, retrieve, list, execute, or delete Snowflake tasks. Tasks schedule SQL statements or stored procedure calls on a recurring basis. Use the **execute** action to manually trigger a task run.

manage_warehouse

Manage Warehouse

Create, retrieve, list, delete, resume, suspend, or abort queries on Snowflake virtual warehouses. Warehouses provide the compute resources for executing queries. Use the **action** field to control the operation.

check_statement_status

Check Statement Status

Check the execution status of a previously submitted SQL statement and retrieve its results. Use this after submitting an asynchronous query to poll for completion and fetch result data, or to retrieve additional result partitions for large result sets.

manage_role

Manage Role

Create, retrieve, list, or delete Snowflake roles. Roles control access privileges to objects and operations. Use roles in conjunction with grants to manage fine-grained permissions.

manage_user

Manage User

Create, retrieve, list, or delete Snowflake users. Users represent individual accounts that can connect to and interact with Snowflake. When creating a user, optionally assign a default role, warehouse, and namespace.

manage_grant

Manage Grant

Grant or revoke privileges on Snowflake objects. Use this to control access by assigning specific privileges (e.g. SELECT, INSERT, USAGE) on resources (databases, schemas, tables, warehouses) to roles.

manage_database

Manage Database

Create, retrieve, list, or delete Snowflake databases. Use the **action** field to specify the operation. When listing, optionally filter by pattern. When creating, provide the database name and optional settings like comment, data retention, etc.

execute_sql

Execute SQL

Execute one or more SQL statements against Snowflake and return the results. Supports SELECT queries, DDL (CREATE, ALTER, DROP), and DML (INSERT, UPDATE, DELETE) statements. Multiple statements can be separated by semicolons. Results include column metadata and row data for queries, or affected row counts for DML.

cancel_statement

Cancel Statement

Cancel a running or queued SQL statement. Provide the statement handle from a previous execution to stop it.

manage_table

Manage Table

Create, retrieve, list, or delete tables within a Snowflake database and schema. When creating, define columns with their data types. For complex table alterations, use the Execute SQL tool with ALTER TABLE statements.

manage_schema

Manage Schema

Create, retrieve, list, or delete schemas within a Snowflake database. Schemas organize tables and other objects within a database. Provide the parent database name and the desired action.

Connect Snowflake to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Snowflake in Metorial. In your Metorial portal, enable the Snowflake MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Snowflake tools.

Run Snowflake through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Snowflake and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Snowflake tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Snowflake

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Google Drive

Upload, download, create, copy, move, rename, trash, and permanently delete files and folders in Google Drive. Search for files using complex queries filtering by name, MIME type, owner, modification date, labels, and other metadata. Share files and folders with specific users, groups, or domains with role-based permissions (owner, writer, commenter, reader). Manage shared drives and their members. Export Google Workspace files (Docs, Sheets, Slides) to standard formats like PDF, DOCX, and XLSX. Track file revision history and restore earlier versions. Create, read, update, and delete threaded comments and replies on files. Read label definitions and search files by label. Browse the Drive apps installed for your account. Store app-specific data in a hidden per-user folder.

Technical notes for Snowflake

Execute SQL statements and manage cloud data warehouse resources on Snowflake. Run queries synchronously or asynchronously, manage databases, schemas, tables, warehouses, users, roles, grants, tasks, stages, streams, and pipes. Ingest data via Snowpipe batch loading or Snowpipe Streaming for low-latency continuous ingestion. Access Cortex AI services for search, inference, and embeddings. Configure outbound notifications to Slack, Microsoft Teams, PagerDuty, email, or cloud queues (SNS, PubSub, Event Grid). Supports multi-statement transactions, resource creation and alteration without SQL, and dynamic tables.

Frequently asked questions

Common questions about connecting Snowflake to AI agents with Metorial.

  1. How many tools does the Snowflake MCP server have?
    The Snowflake MCP server exposes 11 tools, including Manage Task, Manage Warehouse, Check Statement Status. Each one is governed and traced through Metorial.
  2. Snowflake exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Snowflake MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Snowflake and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Snowflake MCP server yourself or use the hosted gateway.

Connect Snowflake to production AI agents

See how Metorial gives your team governed access to Snowflake, with tracing and security controls built in.