mcpserver.so LogoMCPFly
Submit
MCP Snowflake Reader logo

MCP Snowflake Reader

by fnf-deepHeading

Data/DatabasesSnowflakeRead-onlyDatabase Access

A read-only MCP server for Snowflake databases. This server provides secure, read-only access to Snowflake databases through the MCP protocol.

View on GitHub

Last updated: N/A

What is MCP Snowflake Reader?

The MCP Snowflake Reader is a server that allows read-only access to Snowflake databases via the MCP protocol. It enables secure querying of Snowflake data without the risk of data modification or deletion.

How to use MCP Snowflake Reader?

To use the server, configure the Snowflake connection details in JSON format (account, user, password, warehouse, database, schema, role). Then, configure your MCP client (e.g., Cursor AI, Claude) with the server's command and arguments, specifying either Docker or UVX. Alternatively, install using Smithery with the provided command.

Key features of MCP Snowflake Reader

  • Read-only Access

  • Secure Access

  • Integration with MCP Clients

  • Docker Support

  • UVX Support

Use cases of MCP Snowflake Reader

  • Data Analysis

  • Reporting

  • Data Visualization

  • Secure Data Access

FAQ from MCP Snowflake Reader

What types of operations are allowed?

Only read-only operations are permitted. Data modification operations like INSERT, UPDATE, DELETE, etc., are prohibited.

What characters are allowed in table names?

Table names can only contain alphanumeric characters, underscores, and dots.

What SQL keywords are prohibited?

The following SQL keywords are prohibited: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, GRANT, REVOKE, COMMIT, ROLLBACK.

How do I configure the Snowflake connection?

Provide the Snowflake connection information as a JSON string including account, user, password, warehouse, database, schema, and role.

How do I install the Snowflake Reader?

You can install it via Smithery using the command: npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude