Snowflake Snowflake MCP server for secure AI enterprise data access

Connect your AI agents to Snowflake with enterprise-grade governance, observability, and control through MintMCP Gateway.

ChatGPT
ChatGPT
Connected to SnowflakeSnowflake

What were our total sales for this quarter?

You
ChatGPT

Let me query the sales data for Q1 2025:

Connecting to Snowflake warehouse...
Querying sales table (date range: 2025-01-01 to 2025-03-31)...
✓ All actions logged and governed

Tools included with Snowflake MCP

cortex_agent

Combine structured and unstructured data querying with custom tools in a configured Cortex Agent service.

cortex_analyst

Natural language to SQL conversion using Cortex Analyst with semantic models or views.

cortex_search

Semantic search against configured Cortex Search services with filtering and column selection.

run_snowflake_query

Execute SQL queries in Snowflake with support for DML and DDL operations.

query_semantic_view

Query semantic views using dimensions, metrics, and facts with optional filtering.

write_semantic_view_query_tool

Generate query statements for semantic views using dimensions, metrics, and facts.

create_object

Create Snowflake objects including databases, schemas, tables, views, and warehouses.

create_or_alter_object

Create or alter Snowflake objects with a single operation.

describe_object

Describe Snowflake objects to view their structure and properties.

describe_semantic_view

Retrieve detailed information about a semantic view's structure.

drop_object

Remove Snowflake objects including databases, schemas, tables, and views.

list_objects

List Snowflake objects including databases, schemas, tables, views, and warehouses.

list_semantic_views

List all semantic views in the account, database, or schema.

get_semantic_view_ddl

Retrieve the DDL definition for a semantic view.

show_semantic_dimensions

Display all semantic dimensions in the account, database, or schema.

show_semantic_metrics

Display all semantic metrics in the account, database, or schema.

Works with every major client

ClaudeClaude
ChatGPTChatGPT
CopilotCopilot
CursorCursor
GeminiGemini
GooseGoose
LibreChatLibreChat
Open WebUIOpen WebUI
WindsurfWindsurf

Why MintMCP gateway

Centralized governance

Unified authentication, audit logging, and rate control for all Snowflake MCP connections.

One-click deployment

Instantly enable Snowflake MCP for AI teams via MintMCP's standardized gateway without manual server setup.

OAuth + SSO enforcement

Automatic enterprise authentication wrapping for Snowflake MCP endpoints.

Host stdio servers on MintMCP instead of running locally

Containerized servers become accessible to clients like ChatGPT without local installations. Better risk management and security posture without requiring users to run servers on their machines.

Observability and control

Real-time dashboards for monitoring usage, detecting anomalies, and maintaining SLA compliance.

Enterprise hardening

High availability, security, and compliance alignment transform MCP from developer utility to production-grade infrastructure.

Supports shared and per-user auth

Flexibility to configure service accounts at the admin level or enable individual OAuth flows. Secrets remain protected while users gain access, with centralized revocation capabilities.

Granular tool access control

Configure tool access by role. For example, enable read-only operations and exclude write tools like create and delete.

Use cases

Product management teams

Enable AI-driven product analytics and user behavior analysis directly from Snowflake data warehouses with natural language queries.

Finance teams

Automate financial reporting, variance analysis, and forecasting with AI agents accessing Snowflake financial data models.

Executive teams

Generate real-time business intelligence dashboards and strategic insights from governed Snowflake data without SQL expertise.

What can you do with Snowflake MCP?

Product analytics and metrics tracking

Product teams leverage AI agents to query user engagement metrics, feature adoption rates, and cohort analysis directly from Snowflake data warehouses through natural language.

1. Query product metrics
cortex_analyst("Show weekly active users by feature for last 6 months")
2. Analyze results
→ "Feature A: 45K WAU (+12% MoM), Feature B: 32K WAU (+8% MoM)"

Financial reporting and analysis

Finance teams use AI agents to automate revenue reporting, expense tracking, and budget variance analysis by querying Snowflake financial data models with semantic understanding.

1. Generate financial report
query_semantic_view("revenue_view WHERE quarter = Q1_2025")
2. Compare to forecast
→ "Q1 revenue: $4.2M (5% above forecast), Operating margin: 23%"

Executive business intelligence

Leadership teams gain instant access to cross-functional KPIs and strategic insights through AI agents that query Snowflake data across departments with proper governance and access controls.

1. Request executive summary
cortex_agent("Summarize company performance metrics for this month")
2. AI aggregates insights
→ "Revenue: $1.4M (+8%), Customers: 234 (+12), NPS: 67 (+3 pts)"

FAQs

Yes. MintMCP Gateway is SOC 2 compliant and uses OAuth-based authentication for all Snowflake MCP interactions.

Ready to connect Snowflake to your AI agents?

Join enterprises that trust MintMCP Gateway to manage their Snowflake AI integrations securely and efficiently.