Can MCP Snowflake Reader write or modify data?
No, only read-only operations are allowed. SQL keywords like INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, GRANT, REVOKE, COMMIT, and ROLLBACK are explicitly prohibited.
@fnf-deepHeading
基本信息
A Model Context Protocol (MCP) server that provides secure, read-only access to Snowflake databases. Allows LLMs to safely query tables and describe schemas without write permissions. Built with Python and the official Snowflake SDK.
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mcp-snowflake-reader": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp-snowflake-reader",
"--connection",
"{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
]
}
}
}工具列表暂未提供
当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
MCP Snowflake Reader is a read-only MCP server that provides secure, read-only access to Snowflake databases through the MCP protocol.
Configure your MCP client (Cursor AI or Claude) with a Docker or uvx command, passing a JSON connection string with your Snowflake account, user, password, warehouse, database, schema, and role. Alternatively, install automatically via Smithery.
No, only read-only operations are allowed. SQL keywords like INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, GRANT, REVOKE, COMMIT, and ROLLBACK are explicitly prohibited.
You must provide a JSON object containing account, user, password, warehouse, database, schema, and role.
Table names can only contain alphanumeric characters, underscores, and dots.
The server can be run via Docker or uvx. Configuration is provided in the MCP client settings file.
Run `npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude` via Smithery.
A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
评论