VERIFIED

Snowflake

Safety: 65/100

0.0(0)

Snowflake MCP server enables data interaction and analysis via SQL queries and schema exploration, with configurable write access and insight aggregation.

MCP ServersFreemium

Boost this tool

Subscribe to listing upgrades or segmented pushes.

Overview

Snowflake MCP server enables data interaction and analysis via SQL queries and schema exploration, with configurable write access and insight aggregation.

The Snowflake MCP server is relatively safe in its default read-only configuration. Enabling write access significantly increases the risk, requiring careful management of permissions and input validation to prevent data corruption or unauthorized modifications. Use of connection files is recommended to avoid hardcoding credentials.

Performance depends on the complexity of the SQL queries and the size of the data being processed. Consider optimizing queries for better performance.

Snowflake charges for compute and storage. Running complex queries or storing large amounts of data can incur significant costs.

CloudPython177 starsGPL-3.0Released 4/10/2025CI/CD

Connections & Capabilities

Connects To

GitHubTwitter

Capabilities

ReadWriteExec

Client Compatibility

Claude Desktop

full

Cursor

untested

Windsurf

untested

VS Code (Copilot)

untested

Quickstart

Install

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

Environment Variables

SNOWFLAKE_USERSNOWFLAKE_ACCOUNTSNOWFLAKE_ROLESNOWFLAKE_DATABASESNOWFLAKE_SCHEMASNOWFLAKE_WAREHOUSESNOWFLAKE_PASSWORD

Tools (8)

safe

read_query

Executes SELECT queries to retrieve data from the Snowflake database.

Read-only operation, no data modification.

high

write_query

Executes INSERT, UPDATE, or DELETE queries to modify data in the Snowflake database.

Allows modification and deletion of data.

high

create_table

Creates new tables within the Snowflake database.

Allows structural changes to the database schema.

safe

list_databases

Lists all databases available in the Snowflake instance.

Read-only operation, no data modification.

safe

list_schemas

Lists all schemas within a specified database.

Read-only operation, no data modification.

safe

list_tables

Lists all tables within a specified database and schema.

Read-only operation, no data modification.

safe

describe_table

Retrieves column information for a specified table.

Read-only operation, no data modification.

moderate

append_insight

Adds a new data insight to the insights memo.

Non-destructive write operation, but could be used to inject misleading information.

Security

Auth Method

Environment Variable

Data Locality

cloud

Known Risks

!SQL injection vulnerabilities if queries are not properly sanitized
!Exposure of sensitive credentials if not managed securely
!Potential for data corruption or deletion if write access is enabled without proper controls
!Lack of rate limiting could lead to resource exhaustion or abuse
!Insufficient auditing or monitoring could hinder incident response

Safety Score

moderate risk

Positive

+Read-only access by default
+Option to disable specific tools
+Logging capabilities for auditing
+Connection parameters can be managed via TOML files for better security
+Exclusion patterns for databases, schemas, or tables

Risks

-Write access can be enabled, posing a risk of data modification or deletion
-Direct SQL execution can lead to injection vulnerabilities if queries are not properly sanitized
-Sensitive credentials (passwords, private keys) need to be securely managed
-Lack of built-in rate limiting could lead to abuse
-No explicit sandboxing of SQL execution

Use Cases

Data Analysis

-Running ad-hoc queries to explore data
-Generating reports and dashboards
-Identifying trends and patterns in data

Schema Exploration

-Discovering available databases, schemas, and tables
-Understanding table structures and column definitions
-Documenting database schemas

Data Integration

-Extracting data for use in other applications
-Loading data from external sources into Snowflake
-Automating data pipelines

Data Governance

-Auditing data access and modifications
-Monitoring data quality
-Enforcing data security policies

Who Is This For?

Best For

Data analysts who need to explore and analyze data in Snowflake
Developers who need to integrate Snowflake with other applications
Database administrators who need to manage and monitor Snowflake instances
Security engineers who need to audit data access and modifications
Teams using Claude Desktop for data-driven tasks

Not Ideal For

Environments where write access to the database is strictly prohibited
Applications that require real-time data access with low latency
Use cases that require complex data transformations or processing outside of SQL

Autonomy & Execution

Default ModeRead-only

Destructive Tools

Autonomy is limited by the enabled tools and the permissions of the Snowflake user. Write operations should be carefully considered before enabling.

StatelessYes

Retry LogicNot documented

ConcurrencySingle-threaded

Production Tip

Use a dedicated Snowflake user with restricted permissions for the MCP server to minimize the impact of potential security breaches.

FAQ

How do I enable write access to the Snowflake database?

Use the `--allow-write` command-line option when starting the server.

How do I secure my Snowflake credentials?

Use a TOML configuration file to store connection parameters and avoid hardcoding credentials in the command line. Consider using private key authentication instead of passwords.

Can I restrict access to specific databases or schemas?

Yes, you can use exclusion patterns in the `runtime_config.json` file to filter out specific databases, schemas, or tables.

How do I monitor the server's activity?

Configure logging using the `--log_dir` and `--log_level` options. Review the logs for errors and security events.

What Python version is required?

Python 3.12 or lower is recommended.

Does this server support connection via external browser authentication?

Yes, set the `SNOWFLAKE_AUTHENTICATOR` environment variable to `externalbrowser`.

How do I install this server for Claude Desktop?

Use Smithery or UVX as described in the README.

Metrics

Discovered2/14/2026

Reviews0

Saved By0 users

Related Tools

Snowflake - AI Tool Review & Alternatives | Flaex AI