Use Studio chat to drive this server — credentials stay in your workspace.
Snowflake MCP server for cloud data warehouse operations. Execute SQL queries, explore databases and schemas, inspect table structures, manage warehouses, and run analytics workloads against your Snowflake account.
Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.
Browse all toolsDomain knowledge for Snowflake — workflow patterns, data models, and gotchas for your AI agent.
Cloud data warehouse with separation of storage and compute. Authenticate with a Programmatic Access Token (PAT) and your account URL. All operations go through the Snowflake SQL REST API — every tool ultimately executes SQL statements.
org-account.snowflakecomputing.com).: and [] path notation for JSON-like data.SELECT ... AT(TIMESTAMP => ...) or BEFORE(STATEMENT => ...) for historical queries.Get current Snowflake session information: account name, user, role, warehouse, database, schema, and Snowflake version.
Get warehouse credit consumption over time. Shows credits used per warehouse per day — essential for cost monitoring and optimization.
Describe the columns, types, and constraints of a Snowflake table.
Execute SQL statements on Snowflake. Supports all SQL operations including SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, SHOW, DESCRIBE, and mo...
Get the execution plan for a SQL query using EXPLAIN. Shows the operations Snowflake will perform, estimated costs, and data flow without actually run...
Find duplicate rows in a Snowflake table based on specified columns. Returns the duplicate values and their occurrence counts.
Get the full CREATE TABLE statement (DDL) for a Snowflake table, including column definitions, clustering keys, and constraints.
Get storage and clustering statistics for a Snowflake table: row count, size in bytes, active bytes, clustering depth and key, and time travel retenti...
Get the SQL CREATE statement (DDL) for a Snowflake view, showing the underlying query and column definitions.
List all databases in the Snowflake account that the current role can access.
List user-defined functions (UDFs) in a Snowflake schema, including language and return type.
List stored procedures in a Snowflake schema, including their arguments and language.
List all roles in the Snowflake account, showing ownership and granted-to counts.
List all schemas in a Snowflake database.
List data stages (internal and external) in a Snowflake schema for data loading and unloading.
List all tables in a Snowflake schema with row counts and size information.
List all views in a Snowflake schema including materialized views, with their definition status and owner.
List all virtual warehouses in the Snowflake account with their size and status.
Get recent login history for the Snowflake account. Shows successful and failed login attempts with client types and IPs.
Preview rows from a Snowflake table with optional column selection, filtering, and ordering. More flexible than sample — use for targeted data inspect...
Profile a single column in a Snowflake table: row count, distinct values, nulls, min/max, and most common values with frequencies.
Retrieve recent query history from the Snowflake account, including execution times and status.
Resize a Snowflake warehouse to change compute capacity. Larger warehouses process queries faster but consume more credits per second.
Resume a suspended Snowflake warehouse so it can execute queries. Warehouses auto-resume on query if configured, but explicit resume avoids the cold-s...
Get a random sample of rows from a Snowflake table using TABLESAMPLE. Useful for understanding data shape and values without scanning full table.
Get storage usage history across the Snowflake account — average bytes stored, failsafe bytes, and stage bytes over time.
Suspend a running Snowflake warehouse to stop credit consumption. Running queries will complete before suspension.
Get detailed status and configuration of a Snowflake warehouse: state, size, auto-suspend/resume settings, queued and running queries.
Snowflake MCP server for cloud data warehouse operations. Execute SQL queries, explore databases and schemas, inspect table structures, manage warehouses, and run analytics workloads against your Snowflake account. It provides 28 tools that AI agents can use through the Model Context Protocol (MCP).
Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/snowflake. Authentication is handled automatically.
Snowflake provides 28 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.
Snowflake uses API Key. Snowflake requires credentials. Connect via MCPBundles and authentication is handled automatically.
Connect Snowflake to any MCP client in minutes
Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.
Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.
Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.
More analytics integrations you might like
1Forge provides real-time and historical financial market data including forex exchange rates, crypt...
This server provides analytics tools for understanding user behavior and campaign performance. It is...
Anzenna offers a specialized platform for real-time data processing and analysis, enabling users to ...
Apify is a web scraping and automation platform for extracting data from websites at scale. Search t...
Appfigures is an analytics platform that provides app developers with insights into app performance,...
Appfollow provides tools for app management and optimization, offering insights on app performance, ...