Verified

Snowflake Reader MCP Server

Snowflake database query access for AI agents using read-only SQL execution.

Data last scanned today · Reviewed today

43★ 0PythonMIT

Overview

Snowflake Reader MCP Server allows AI assistants to interact with Snowflake databases. It enables users to retrieve data by executing queries while enforcing a strict read-only model to prevent modifications to the database schema or content. The server handles connection configurations through JSON objects containing standard Snowflake credentials. It implements a blocklist of SQL keywords—including INSERT, UPDATE, and DELETE—to maintain its read-only guarantee and limit operations to data retrieval.

Our verdict

With a security score of 18/100, this server is classified as high-risk. The evaluation flags significant concerns, most notably that the project has not received a commit in 527 days and lacks any community contributors or maintainers. Given these factors, it is recommended primarily for users who can independently audit the code, as the project is essentially abandoned and lacks third-party oversight.

MIT licensed source code
Restricts SQL commands to read-only operations
Single direct dependency minimizes supply-chain surface area

High-risk security score of 18/100
Inactive repository with no updates for over 500 days
Lack of active maintenance and zero community contributors
Authentication mechanisms have not been independently reviewed

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›Does this server support write operations like INSERT or UPDATE?

No, the server provides read-only access and explicitly prohibits keywords such as INSERT, UPDATE, DELETE, and several others to ensure data safety.

›What information is required to connect to my Snowflake database?

You must provide a JSON string containing your account, user, password, warehouse, database, schema, and role details.

›Are there naming restrictions for tables queried through this server?

Yes, table names are restricted to using only alphanumeric characters, underscores, and dots.

›How can I install this server for Claude Desktop?

You can install it automatically using the Smithery CLI by running the command: npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude.