# Snowflake (Labs) (MCP Server)

> Deprecated Snowflake Labs MCP server for Cortex AI and SQL

- Type: MCP server
- Publisher: Snowflake Labs (official)
- Categories: Data & Analytics
- Website: https://github.com/Snowflake-Labs/mcp
- Docs: https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp
- Source: https://github.com/Snowflake-Labs/mcp
- Transport: stdio
- Launch command: uvx snowflake-labs-mcp --service-config-file config.yaml
- Sign-in: api-key
- Environment variables: SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD
- GitHub stars: 298
- Listed: 2025-05-22

## About

Deprecated, no-longer-maintained Snowflake Labs MCP server that provided Cortex Search, Cortex Analyst, Cortex Agents, object management, SQL execution and semantic view querying. Snowflake recommends migrating to its official managed Snowflake MCP Server.

## Install

1. **Add the server to Codex**

   Codex CLI:

   ```bash
   codex mcp add snowflake --env SNOWFLAKE_ACCOUNT=YOUR_SNOWFLAKE_ACCOUNT --env SNOWFLAKE_USER=YOUR_SNOWFLAKE_USER --env SNOWFLAKE_PASSWORD=YOUR_SNOWFLAKE_PASSWORD -- uvx snowflake-labs-mcp --service-config-file config.yaml
   ```

   config.toml:

   ```toml
   [mcp_servers.snowflake]
   command = "uvx"
   args = ["snowflake-labs-mcp", "--service-config-file", "config.yaml"]
   
   [mcp_servers.snowflake.env]
   SNOWFLAKE_ACCOUNT = "YOUR_SNOWFLAKE_ACCOUNT"
   SNOWFLAKE_USER = "YOUR_SNOWFLAKE_USER"
   SNOWFLAKE_PASSWORD = "YOUR_SNOWFLAKE_PASSWORD"
   ```

   Agents SDK:

   ```python
   from agents import Agent, Runner
   from agents.mcp import MCPServerStdio
   
   async with MCPServerStdio(
       name="Snowflake (Labs)",
       params={"command": "uvx", "args": ["snowflake-labs-mcp", "--service-config-file", "config.yaml"]},
   ) as server:
       agent = Agent(name="Assistant", mcp_servers=[server])
       result = await Runner.run(agent, "Search our support docs with Cortex Search")
       print(result.final_output)
   ```

## Example prompts

- "Search our support docs with Cortex Search"
- "Ask Cortex Analyst for revenue by region last quarter"
- "List the schemas in ANALYTICS_DB"

## Also available as

- plugin: [Snowflake](https://chatgptplugins.directory/plugins/snowflake.md)

## Related

- [Supabase](https://chatgptplugins.directory/mcp/supabase.md): Manage Supabase databases, migrations, edge functions and logs
- [Graphiti MCP](https://chatgptplugins.directory/mcp/graphiti.md): Temporal knowledge graph memory for agents, by Zep
- [MCP Toolbox for Databases](https://chatgptplugins.directory/mcp/mcp-toolbox-databases.md): Google's open-source MCP server for 20+ databases
- [PostHog](https://chatgptplugins.directory/mcp/posthog.md): Query product analytics, feature flags, experiments and errors in PostHog
- [Apify](https://chatgptplugins.directory/mcp/apify.md): Run thousands of Apify Actors for scraping and automation from your agent
- [Firecrawl](https://chatgptplugins.directory/mcp/firecrawl.md): Scrape, search, crawl and interact with live web pages for LLMs

---
Source: https://chatgptplugins.directory/mcp/snowflake · Index: https://chatgptplugins.directory/llms.txt · Independent and community-run. Not affiliated with or endorsed by OpenAI. ChatGPT is a trademark of OpenAI.