A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries with tools and intereacting with a memo of data insights presented as a resource.
The server exposes a single dynamic resource:
memo://insights: A continuously updated data insights memo that aggregates discovered insights during analysis
The server offers six core tools:
read_query
query (string): The SELECT SQL query to executewrite_query (with --allow-write flag)
query (string): The SQL modification query{ affected_rows: number }create_table (with --allow-write flag)
query (string): CREATE TABLE SQL statementlist_tables
describe-table
table_name (string): Name of table to describe (can be fully qualified)append_insight
insight (string): data insight discovered from analysisTo install Snowflake Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install mcp_snowflake_server --client claude
## Add the server to your claude_desktop_config.json
"mcpServers": {
"snowflake_pip": {
"command": "uvx",
"args": [
"mcp_snowflake_server",
"--account",
"the_account",
"--warehouse",
"the_warehouse",
"--user",
"the_user",
"--password",
"their_password",
"--role",
"the_role"
"--database",
"the_database",
"--schema",
"the_schema",
# Optionally: "--allow_write" (but not recommended)
# Optionally: "--log_dir", "/absolute/path/to/logs"
# Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
# Optionally: "--exclude_tools", "{tool name}", ["{other tool name}"]
]
}
}
## Add the server to your claude_desktop_config.json
"mcpServers": {
"snowflake_local": {
"command": "uv",
"args": [
"--directory",
"/absolute/path/to/mcp_snowflake_server",
"run",
"mcp_snowflake_server",
"--account",
"the_account",
"--warehouse",
"the_warehouse",
"--user",
"the_user",
"--password",
"their_password",
"--role",
"the_role"
"--database",
"the_database",
"--schema",
"the_schema",
# Optionally: "--allow_write" (but not recommended)
# Optionally: "--log_dir", "/absolute/path/to/logs"
# Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
# Optionally: "--exclude_tools", "{tool name}", ["{other tool name}"]
]
}
}
Ragie Model Context Protocol Server
A Python-based MCP (Model Context Protocol) server that predicts the origin
A Model Context Protocol (MCP) server that provides real-time cryptocurrency analysis via CoinCap's API. Enables Claude and other MCP clients to fetch crypto prices, analyze market trends, and track historical data.
Model Context Server Protocol for your HANA DB