mcp-snowflake-reader
0
MCP Snowflake Reader is a server designed to provide secure, read-only access to Snowflake databases using the MCP protocol. It ensures that operations are read-only and restricts certain SQL keywords for safety.
MCP Snowflake Reader
A read-only MCP server for Snowflake databases. This server provides secure, read-only access to Snowflake databases through the MCP protocol.
Features
- Read-only Access: Secure read-only access to Snowflake databases
Setup
Snowflake Connection
The Snowflake connection information should be provided as a JSON string including account, user, password, warehouse, database, schema, and role.
MCP Client Configuration
Configurations can be added to MCP client settings for Docker and UVX.
Installing via Smithery
To install Snowflake Reader for Claude Desktop automatically via Smithery: Follow the given command for installation.
Limitations
- Only read-only operations are allowed
- Table names can only contain alphanumeric characters, underscores, and dots
- The following SQL keywords are prohibited: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, GRANT, REVOKE, COMMIT, ROLLBACK
License
This project is licensed under the MIT License.