Skip to main content
Glama
Sign In
MCP Snowflake Reader

MCP Snowflake Reader

by fnf-deepHeading
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

MCP Snowflake Reader

English | 한국어

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.

Related MCP server: Snowflake MCP Server

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 파일을 참조하세요.

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Resources

Related MCP Connectors

Related MCP Servers

  • MCP MySQL Server

    gakkiismywife
    A
    license
    Not graded
    quality
    D
    maintenance
    Provides read-only access to MySQL databases, enabling schema inspection, table listing, and execution of SELECT queries through the Model Context Protocol.
    751 npm
    MIT

  • Snowflake MCP Server

    ncejda-g2
    A
    license
    A
    quality
    C
    maintenance
    Provides secure, read-only access to Snowflake data warehouses, enabling AI assistants to explore schemas, write queries, and analyze data with SSO authentication and smart caching.
    6
    45 npm
    5
    MIT

  • MCP Database Connector +

    keerthivanan
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables natural language queries to a company database through the Model Context Protocol, with read-only enforcement and agentic error recovery.
    MIT