How do I enable write operations?
Write operations (`write_query`, `create_table`) are disabled by default. Enable them with the `--allow-write` flag.
@isaacwasserman
Basic information
No overview available yet
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-snowflake-server": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp_snowflake_server",
"--client",
"claude"
]
}
}
}Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
Fetch the live tool list by running this server in a temporary sandbox using the button above.
A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. It enables running SQL queries via tools and exposes data insights and schema context as resources.
Install via Smithery (npx -y @smithery/cli install mcp_snowflake_server --client claude) or locally using uvx. Configure with Snowflake credentials via environment variables, individual parameters, or a TOML connections file, then add the server to your claude_desktop_config.json. Invoke tools such as read_query, write_query, list_databases, list_schemas, list_tables, describe_table, and append_insight.
SELECT queries with the read_query toolINSERT, UPDATE, DELETE) via write_query (requires --allow-write)create_table tool (requires --allow-write)memo://insights resourceWrite operations (`write_query`, `create_table`) are disabled by default. Enable them with the `--allow-write` flag.
The server supports password-based authentication, private key authentication (`--private_key_path`), and external browser authentication (`SNOWFLAKE_AUTHENTICATOR="externalbrowser"`).
Yes. You can set exclusion patterns via a `runtime_config.json` file.
Use the `append_insight` tool to add insights, which automatically updates the `memo://insights` resource. Insights are aggregated in this dynamic memo.
The server uses stdio transport. Configuration can be provided via environment variables, individual command-line arguments, or a TOML connections file (recommended for multiple connections).
A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Model Context Protocol Servers
Connect ClickHouse to your AI assistants.
An official Qdrant Model Context Protocol (MCP) server implementation
Comments