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.

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Model Context Protocol Servers

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
コメント