# MCP Snowflake Reader
[English](#english) | [한국어](#korean)
[](https://smithery.ai/server/@fnf-deepHeading/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:
```json
{
"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
```json
{
"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
```json
{
"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](https://smithery.ai/server/@fnf-deepHeading/mcp-snowflake-reader):
```bash
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](LICENSE) file for details.
## Korean
Snowflake 데이터베이스의 테이블을 읽어오는 MCP(Microservice Control Protocol) 서버입니다.
### 주요 기능
- **읽기 전용 접근**: Snowflake 데이터베이스에 대한 안전한 읽기 전용 접근
### 설정
#### Snowflake 연결 정보
Snowflake 연결 정보는 다음과 같은 형식으로 JSON 문자열로 제공됩니다:
```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
```json
{
"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
```json
{
"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](https://smithery.ai/server/@fnf-deepHeading/mcp-snowflake-reader)를 통해 Claude Desktop에서 Snowflake Reader를 자동으로 설치하려면:
```bash
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](LICENSE) 파일을 참조하세요.
