A
licenseA
qualityD
maintenanceSnowflake integration implementing read and (optional) write operations as well as insight tracking
6
185
GPL 3.0
snowflake-mcp
Provides tools for interacting with Snowflake, enabling listing databases, schemas, and tables, describing table structures, running read queries, and optionally performing write operations such as writing queries, creating tables, and appending insights.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@snowflake-mcpWhat tables are in the analytics schema?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
snowflake-mcp
Snowflake MCP server built with FastMCP.
Quick Start
Windows PowerShell
python -m venv .venv
.venv\Scripts\activate
pip install -r requirements.txtmacOS / Linux
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txtRelated MCP server: Snowflake MCP Server
Configuration
Create an empty .env file in the project root with follwing credentials.
Provide credentials through environment variables configuration.
You can also copy the values from .env.example into .env and fill in your Snowflake details.
- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USER
- SNOWFLAKE_PASSWORD
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_DATABASE
- SNOWFLAKE_SCHEMA
- SNOWFLAKE_ROLE
- SNOWFLAKE_ALLOW_WRITE=falseKeep SNOWFLAKE_ALLOW_WRITE=false unless you want to allow write operations.
Use the VS Code MCP start button in .vscode/mcp.json to launch the server.
Tools
list_databases
list_schemas
list_tables
describe_table
read_query
write_query
create_table
append_insight
This server cannot be installed
Maintenance
–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- AlicenseBqualityDmaintenanceEnables interaction with Snowflake databases through SQL queries, schema exploration, and data analysis. Supports read/write operations, table management, and automatic insight tracking for comprehensive database operations through natural language.7GPL 3.0
- Alicense-qualityCmaintenanceEnables read-only interaction with Snowflake databases through SQL queries, schema exploration, and data insight tracking. Provides tools to query data, list databases/schemas/tables, describe table structures, and maintain a memo of discovered insights.GPL 3.0
- Alicense-qualityDmaintenanceIntegrates Snowflake Cortex AI features like Cortex Search and Analyst into the MCP ecosystem, enabling retrieval-augmented generation and structured data analysis. It also provides tools for chat completions and agentic orchestration using Snowflake-hosted large language models.Apache 2.0
Related MCP Connectors
Run SOQL queries to explore and retrieve Salesforce data. Access accounts, contacts, opportunities…
Run SOQL queries against your Salesforce org to retrieve records and insights. Explore objects, fi…
Monday.com MCP — wraps the Monday.com GraphQL API (BYO API key)
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/rakheshkrishna2005/snowflake-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server