mcp snowflake server
pipStandardThe MCP Snowflake Server allows AI agents to query, insert, update, and delete data in Snowflake databases. It exposes SQL execution, transaction management, and metadata retrieval tools. It connects directly to Snowflake's SQL API. Developers use it to build AI agents that automate data workflows, generate reports, or perform analytics on Snowflake-hosted data.
179780Updated 4 months ago
Overview
The MCP Snowflake Server allows AI agents to query, insert, update, and delete data in Snowflake databases. It exposes SQL execution, transaction management, and metadata retrieval tools. It connects directly to Snowflake's SQL API. Developers use it to build AI agents that automate data workflows, generate reports, or perform analytics on Snowflake-hosted data.
Installation
1Install the package
pip
pip install mcp-snowflake-server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"isaacwasserman-mcp-snowflake-server-github": {
"command": "uvx",
"args": [
"pip install mcp-snowflake-server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mcp snowflake server?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
- API key for mcp snowflake server
Configuration
API Key Required
This server requires an API key from mcp snowflake server. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MCP_SNOWFLAKE_SERVER_API_KEY | Yes | Your mcp snowflake server API key |
Usage Examples
List Resources
"What resources are available in mcp snowflake server?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in mcp snowflake server"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in mcp snowflake server with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with mcp snowflake server
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.