Snowflake MCP server for secure AI enterprise data access
Connect your AI agents to Snowflake with enterprise-grade governance, observability, and control through Mintive Gateway.
What were our total sales for this quarter?
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
Why Mintive gateway
Centralized governance
One-click deployment
OAuth + SSO enforcement
Host stdio servers on Mint instead of running locally
Observability and control
Enterprise hardening
Supports shared and per-user auth
Granular tool access control
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.
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.
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.
FAQs
Yes. Mintive Gateway is SOC 2 compliant and uses OAuth-based authentication for all Snowflake MCP interactions.
ChatGPT, Claude, Claude Code, and any MCP-compatible client.
Schedule a demo to receive Mintive Gateway credentials and configuration details for connecting your AI client to the Snowflake MCP Server.
The Model Context Protocol (MCP) is an open standard that lets AI models connect to external tools and data sources through a single, secure interface—the "USB-C for AI."
Access is managed centrally in Mintive Gateway. Administrators can grant, suspend, or revoke connections and control authentication through identity-based policies.
Mint provides usage dashboards and audit logs for monitoring authentication, tool invocations, and connection activity.
No. Mint supports OAuth authentication and delegated token marshalling, allowing secure, automatic credential handling without manual entry.
Yes. Integrate Mint with Okta or another identity provider to enable role-based access. Map teams or groups to Virtual MCPs (VMCPs) for structured permissions.
Yes. Teams can define VMCPs with custom tool prompts, configurations, and behavior tailored to their workflows.
Yes. You can bring your own MCP servers and manage them through Mint with governance and security controls.
Create a Mintive app in Okta, upload the metadata XML, map groups to roles, and verify the connection.
Mint detects and notifies administrators of changes to tool definitions and descriptions, including new tools, renamed tools, removals, and updates to metadata.
Yes. Each invocation is logged with timestamp, user identity, and client metadata for traceable auditing.