mcp-snowflake-server
This MCP server enables interaction with Snowflake databases to run SQL queries and access data insights.
The Snowflake MCP Server is a Model Context Protocol implementation that facilitates seamless database interactions with Snowflake. Users can execute SQL queries, retrieve data insights, and access schema context through various exposed resources and tools. The server supports both read and write operations, allowing for comprehensive data management and manipulation. With features like continuously updated insights and per-table schema summaries, the server enhances the user experience by providing valuable context and information. It is designed to streamline data operations, making it easier for users to gain insights and manage their databases effectively.
Compatible with
Install
Claude Desktop
Add to your claude_desktop_config.json:
{
"mcpServers": {
"mcp-snowflake-server": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mcp-snowflake-server"
]
}
}
}Config File Location
Mac: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/claude/claude_desktop_config.json
Some servers require additional setup - check the GitHub README for specific instructions.
Permissions