Skip to content
Back to search

mcp-snowflake-server

A 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…

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/isaacwasserman--mcp-snowflake-server/badge.svg)](/listings/isaacwasserman--mcp-snowflake-server)

HTML

<a href="/listings/isaacwasserman--mcp-snowflake-server"><img src="/api/listings/isaacwasserman--mcp-snowflake-server/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

To install Snowflake Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp_snowflake_server):

npx -y @smithery/cli install mcp_snowflake_server --client claude

---

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 249 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

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

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.