{"type":"mcp_server","name":"mcp-snowflake-server","description":"This repository provides a Model Context Protocol (MCP) server for interacting with Snowflake databases, offering tools for querying, schema exploration, and appending data insights to a dynamic memo resource.","category":"Database","language":"Python","stars":183,"forks":6,"owner":"isaacwasserman","github_url":"https://github.com/isaacwasserman/mcp-snowflake-server","homepage":null,"setup":"## Setup\n\nTo install Snowflake Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp_snowflake_server):\n\n```bash\nnpx -y @smithery/cli install mcp_snowflake_server --client claude\n```\n\nTo install via UVX, add the server to your `claude_desktop_config.json`:\n\n```json\n\"mcpServers\": {\n  \"snowflake_pip\": {\n      \"command\": \"uvx\",\n      \"args\": [\n          \"mcp_snowflake_server\",\n          \"--account\",\n          \"the_account\",\n          \"--warehouse\",\n          \"the_warehouse\",\n          \"--user\",\n          \"the_user\",\n          \"--password\",\n          \"their_password\",\n          \"--role\",\n          \"the_role\"\n          \"--database\",\n          \"the_database\",\n          \"--schema\",\n          \"the_schema\",\n          # Optionally: \"--allow_write\" (but not recommended)\n          # Optionally: \"--log_dir\", \"/absolute/path/to/logs\"\n          # Optionally: \"--log_level\", \"DEBUG\"/\"INFO\"/\"WARNING\"/\"ERROR\"/\"CRITICAL\"\n          # Optionally: \"--exclude_tools\", \"{tool name}\", [\"{other tool name}\"]\n      ]\n  }\n}\n```\n\nTo install locally, add the server to your `claude_desktop_config.json`:\n\n```json\n\"mcpServers\": {\n  \"snowflake_local\": {\n      \"command\": \"uv\",\n      \"args\": [\n          \"--directory\",\n          \"/absolute/path/to/mcp_snowflake_server\",\n          \"run\",\n          \"mcp_snowflake_server\",\n          \"--account\",\n          \"the_account\",\n          \"--warehouse\",\n          \"the_warehouse\",\n          \"--user\",\n          \"the_user\",\n          \"--password\",\n          \"their_password\",\n          \"--role\",\n          \"the_role\"\n          \"--database\",\n          \"the_database\",\n          \"--schema\",\n          \"the_schema\",\n          # Optionally: \"--allow_write\" (but not recommended)\n          # Optionally: \"--log_dir\", \"/absolute/path/to/logs\"\n          # Optionally: \"--log_level\", \"DEBUG\"/\"INFO\"/\"WARNING\"/\"ERROR\"/\"CRITICAL\"\n          # Optionally: \"--exclude_tools\", \"{tool name}\", [\"{other tool name}\"]\n      ]\n  }\n}\n```","tools":"## Available Tools\n\n1.  `read_query` (Execute SELECT queries to read data from the database.)\n2.  `write_query` (Execute INSERT, UPDATE, or DELETE queries.)\n3.  `create_table` (Create new tables in the database.)\n4.  `list_tables` (Get a list of all tables in the database.)\n5.  `describe-table` (View column information for a specific table.)\n6.  `append_insight` (Add new data insights to the memo resource.)","faq":null,"created_at":"2024-12-13T20:30:59+00:00","updated_at":"2025-03-28T01:56:59+00:00","source_url":"https://model-context-protocol.com/servers/mcp-snowflake-database-query-insights-server","related_articles":[]}