mcp-snowflake-reader
If you are the rightful owner of mcp-snowflake-reader and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A read-only MCP server for Snowflake databases providing secure access through the MCP protocol.
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 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 ๋ผ์ด์ ์ค๋ฅผ ๋ฐ๋ฆ ๋๋ค. ์์ธํ ๋ด์ฉ์ ํ์ผ์ ์ฐธ์กฐํ์ธ์.
