# Snowflake MCP Server

> Lets AI clients query and manage Snowflake data via MCP

- Page on StartupList: https://startuplist.tech/launches/snowflake-mcp-server
- Website: https://github.com/Snowflake-Labs/mcp
- Category: MCP Servers
- Price: Open source
- Company: Snowflake (https://startuplist.tech/companies/snowflake)
- Used for: Analyse data, Answer questions with AI

## At a glance

- The problem it solves: Lets AI assistants query and manage Snowflake data without custom integration work
- Who it's for: Businesses (B2B)

## About

This is a community MCP server for Snowflake. It gives MCP clients such as Claude Desktop, Cursor and VS Code access to Snowflake Cortex AI, object management, SQL execution and Snowflake Semantic Views. The repository is marked as deprecated and no longer maintained, and it asks users to move to the official Snowflake MCP Server.

The server supports Cortex Search for querying unstructured data, Cortex Analyst for querying structured data through semantic models, and Cortex Agent for orchestrating across both. Object management covers basic creation, dropping and updating of common Snowflake objects. SQL execution runs LLM-generated statements, limited by the permissions set in a configuration file.

Setup uses a YAML service configuration file that lists Cortex services and turns tool groups on or off. Connection parameters can be passed as command-line arguments or environment variables. The server supports the authentication methods of the Snowflake Python Connector, including key pair, OAuth and single sign-on. It runs over stdio by default, or over streamable HTTP for container deployments. It honours the RBAC permissions of the role it connects with.

It is aimed at teams that already use Snowflake and want AI assistants to work with their data. The repository is licensed under Apache-2.0. The page does not state a price for the server itself, and the pricing shown on the fetched pages belongs to GitHub, so no price is listed here.

## Links

- [Snowflake MCP Server on StartupList](https://startuplist.tech/launches/snowflake-mcp-server)
- [Website](https://github.com/Snowflake-Labs/mcp)