MCP Snowflake Reader
About
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.
Details
- Author
- fnf-deepHeading
- Downloads
- 125
- Categories
- Database, Other
Jump to
- Read-only access to Snowflake databases
- Connection via JSON configuration string
- Supports Docker and uvx runtimes
- Installable via Smithery for Claude Desktop
- MIT licensed
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP Snowflake ReaderCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp snowflake reader": {
"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\"}"
]
}
}
}
}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\"}"
]
}
}MCP Snowflake Reader
English
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 in the following format:
{
"account": "your-account",
"user": "your-user",
"password": "your-password",
"warehouse": "your-warehouse",
"database": "your-database",
"schema": "your-schema",
"role": "your-role"
}
MCP Client Configuration
Add the following configuration to your MCP client settings file (Cursor AI or Claude):
Docker
{
"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\"}"
]
}
}
}
UVX
{
"mcpServers": {
"mcp-snowflake-reader": {
"command": "uvx",
"args": [
"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\"}"
]
}
}
}
Installing via Smithery
To install Snowflake Reader for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude
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 - see the LICENSE file for details.
Korean
Snowflake 데이터베이스의 테이블을 읽어오는 MCP(Microservice Control Protocol) 서버입니다.
주요 기능
- 읽기 전용 접근: Snowflake 데이터베이스에 대한 안전한 읽기 전용 접근
설정
Snowflake 연결 정보
Snowflake 연결 정보는 다음과 같은 형식으로 JSON 문자열로 제공됩니다:
{
"account": "your-account",
"user": "your-user",
"password": "your-password",
"warehouse": "your-warehouse",
"database": "your-database",
"schema": "your-schema",
"role": "your-role"
}
MCP 클라이언트 설정
Cursor AI나 Claude와 같은 MCP 클라이언트의 설정 파일에 다음 설정을 추가하세요:
Docker
{
"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\"}"
]
}
}
}
UVX
{
"mcpServers": {
"mcp-snowflake-reader": {
"command": "uvx",
"args": [
"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\"}"
]
}
}
}
Smithery 사용하여 설치
Smithery를 통해 Claude Desktop에서 Snowflake Reader를 자동으로 설치하려면:
npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude
제한사항
- 읽기 전용 작업만 허용됩니다
- 테이블 이름은 영숫자, 언더스코어, 점만 허용됩니다
- 다음 SQL 키워드는 금지됩니다:
- INSERT
- UPDATE
- DELETE
- DROP
- TRUNCATE
- ALTER
- CREATE
- GRANT
- REVOKE
- COMMIT
- ROLLBACK
라이선스
이 프로젝트는 MIT 라이선스를 따릅니다. 자세한 내용은 LICENSE 파일을 참조하세요.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
