Official Snowflake integration — query data, manage warehouses, and inspect pipelines through AI
The official Snowflake MCP server gives AI agents access to your data warehouse. It can query tables, inspect schemas, manage warehouses, and surface analytics insights. Features: - Execute SQL queries and return structured results - Inspect schemas, tables, and views - Manage warehouses and compute usage - Access query history and performance metrics - Create and manage tasks and streams - Query external tables and shares - Integrate with BI workflows Snowflake MCP is designed for analytics teams who want AI to work directly with enterprise data.
File location: .cursor/mcp.json (project) or ~/.cursor/mcp.json (global)
{
"snowflakeMcp": {
"command": "npx",
"args": [
"-y",
"@snowflake/mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "xyz12345",
"SNOWFLAKE_USER": "your_user",
"SNOWFLAKE_ROLE": "ANALYST",
"SNOWFLAKE_WAREHOUSE": "COMPUTE_WH"
}
}
}If you maintain Snowflake MCP, add this badge to your README to show it's verified on CuratedMCP:
[](https://curatedmcp.com/marketplace/snowflake-mcp)