Snowflake MCP Server

1[![MseeP.ai Security Assessment Badge](https://mseep.net/pr/isaacwasserman-mcp-snowflake-server-badge.png)](https://mseep.ai/app/isaacwasserman-mcp-snowflake-server)
2 
3# Snowflake MCP Server
4---
5 
6## Overview
7 
8A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries via tools and exposes data insights and schema context as resources.
9 
10---
11 
12## Components
13 
14### Resources
15 
16- **`memo://insights`**  
17  A continuously updated memo aggregating discovered data insights.  
18  Updated automatically when new insights are appended via the `append_insight` tool.
19 
20- **`context://table/{table_name}`**  
21  (If prefetch enabled) Per-table schema summaries, including columns and comments, exposed as individual resources.
22 
23---
24 
25### Tools
26 
27The server exposes the following tools:
28 
29#### Query Tools
30 
31- **`read_query`**  
32  Execute `SELECT` queries to read data from the database.  
33  **Input:**
34 
35  - `query` (string): The `SELECT` SQL query to execute  
36    **Returns:** Query results as array of objects
37 
38- **`write_query`** (enabled only with `--allow-write`)  
39  Execute `INSERT`, `UPDATE`, or `DELETE` queries.  
40  **Input:**
41 
42  - `query` (string): The SQL modification query  
43    **Returns:** Number of affected rows or confirmation
44 
45- **`create_table`** (enabled only with `--allow-write`)  
46  Create new tables in the database.  
47  **Input:**
48  - `query` (string): `CREATE TABLE` SQL statement  
49    **Returns:** Confirmation of table creation
50 
51#### Schema Tools
52 
53- **`list_databases`**  
54  List all databases in the Snowflake instance.  
55  **Returns:** Array of database names
56 
57- **`list_schemas`**  
58  List all schemas within a specific database.  
59  **Input:**
60 
61  - `database` (string): Name of the database  
62    **Returns:** Array of schema names
63 
64- **`list_tables`**  
65  List all tables within a specific database and schema.  
66  **Input:**
67 
68  - `database` (string): Name of the database
69  - `schema` (string): Name of the schema  
70    **Returns:** Array of table metadata
71 
72- **`describe_table`**  
73  View column information for a specific table.  
74  **Input:**
75  - `table_name` (string): Fully qualified table name (`database.schema.table`)  
76    **Returns:** Array of column definitions with names, types, nullability, defaults, and comments
77 
78#### Analysis Tools
79 
80- **`append_insight`**  
81  Add new data insights to the memo resource.  
82  **Input:**
83  - `insight` (string): Data insight discovered from analysis  
84    **Returns:** Confirmation of insight addition  
85    **Effect:** Triggers update of `memo://insights` resource
86 
87---
88 
89## Usage with Claude Desktop
90 
91### Installing via Smithery
92 
93To install Snowflake Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp_snowflake_server):
94 
95```bash
96npx -y @smithery/cli install mcp_snowflake_server --client claude
97```
98 
99---
100 
101### Installing via UVX
102 
103#### Traditional Configuration (Individual Parameters)
104 
105```json
106"mcpServers": {
107  "snowflake_pip": {
108    "command": "uvx",
109    "args": [
110      "--python=3.12",  // Optional: specify Python version <=3.12
111      "mcp_snowflake_server",
112      "--account", "your_account",
113      "--warehouse", "your_warehouse",
114      "--user", "your_user",
115      "--password", "your_password",
116      "--role", "your_role",
117      "--database", "your_database",
118      "--schema", "your_schema"
119      // Optionally: "--private_key_path", "your_private_key_absolute_path"
120      // Optionally: "--allow_write"
121      // Optionally: "--log_dir", "/absolute/path/to/logs"
122      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
123      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
124    ]
125  }
126}
127```
128 
129#### TOML Configuration (Recommended)
130 
131```json
132"mcpServers": {
133  "snowflake_production": {
134    "command": "uvx",
135    "args": [
136      "--python=3.12",
137      "mcp_snowflake_server",
138      "--connections-file", "/path/to/snowflake_connections.toml",
139      "--connection-name", "production"
140      // Optionally: "--allow_write"
141      // Optionally: "--log_dir", "/absolute/path/to/logs"
142      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
143      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
144    ]
145  },
146  "snowflake_staging": {
147    "command": "uvx",
148    "args": [
149      "--python=3.12",
150      "mcp_snowflake_server",
151      "--connections-file", "/path/to/snowflake_connections.toml",
152      "--connection-name", "staging"
153    ]
154  }
155}
156```
157 
158---
159 
160### Installing Locally
161 
1621. Install [Claude AI Desktop App](https://claude.ai/download)
163 
1642. Install `uv`:
165 
166```bash
167curl -LsSf https://astral.sh/uv/install.sh | sh
168```
169 
1703. Create a `.env` file with your Snowflake credentials:
171 
172```bash
173SNOWFLAKE_USER="xxx@your_email.com"
174SNOWFLAKE_ACCOUNT="xxx"
175SNOWFLAKE_ROLE="xxx"
176SNOWFLAKE_DATABASE="xxx"
177SNOWFLAKE_SCHEMA="xxx"
178SNOWFLAKE_WAREHOUSE="xxx"
179SNOWFLAKE_PASSWORD="xxx"
180SNOWFLAKE_PASSWORD="xxx"
181SNOWFLAKE_PRIVATE_KEY_PATH=/absolute/path/key.p8
182# Alternatively, use external browser authentication:
183# SNOWFLAKE_AUTHENTICATOR="externalbrowser"
184```
185 
1864. [Optional] Modify `runtime_config.json` to set exclusion patterns for databases, schemas, or tables.
187 
1885. Test locally:
189 
190```bash
191uv --directory /absolute/path/to/mcp_snowflake_server run mcp_snowflake_server
192```
193 
1946. Add the server to your `claude_desktop_config.json`:
195 
196#### Traditional Configuration (Using Environment Variables)
197 
198```json
199"mcpServers": {
200  "snowflake_local": {
201    "command": "/absolute/path/to/uv",
202    "args": [
203      "--python=3.12",  // Optional
204      "--directory", "/absolute/path/to/mcp_snowflake_server",
205      "run", "mcp_snowflake_server"
206      // Optionally: "--allow_write"
207      // Optionally: "--log_dir", "/absolute/path/to/logs"
208      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
209      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
210    ]
211  }
212}
213```
214 
215#### TOML Configuration (Recommended)
216 
217```json
218"mcpServers": {
219  "snowflake_local": {
220    "command": "/absolute/path/to/uv",
221    "args": [
222      "--python=3.12",
223      "--directory", "/absolute/path/to/mcp_snowflake_server",
224      "run", "mcp_snowflake_server",
225      "--connections-file", "/absolute/path/to/snowflake_connections.toml",
226      "--connection-name", "development"
227      // Optionally: "--allow_write"
228      // Optionally: "--log_dir", "/absolute/path/to/logs"
229      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
230      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
231    ]
232  }
233}
234```
235 
236---
237 
238## Notes
239 
240- By default, **write operations are disabled**. Enable them explicitly with `--allow-write`.
241- The server supports filtering out specific databases, schemas, or tables via exclusion patterns.
242- The server exposes additional per-table context resources if prefetching is enabled.
243- The `append_insight` tool updates the `memo://insights` resource dynamically.
244 
245---
246 
247## License
248 
249MIT
250