Lets LLMs interact with Snowflake databases with read and optional write operations plus insight tracking.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add snowflake-server-isaacwasserman -- npx -y @smithery/cli install mcp_snowflake_server --client claude~/.codex/config.toml
[mcp_servers.snowflake-server-isaacwasserman]
command = "npx"
args = ["-y", "@smithery/cli", "install", "mcp_snowflake_server", "--client", "claude"]
# codex mcp add snowflake-server-isaacwasserman -- npx -y @smithery/cli install mcp_snowflake_server --client claude~/.cursor/mcp.json
{
"mcpServers": {
"snowflake-server-isaacwasserman": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}.vscode/mcp.json
{
"servers": {
"snowflake-server-isaacwasserman": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"snowflake-server-isaacwasserman": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"snowflake-server-isaacwasserman": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"snowflake-server-isaacwasserman": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}