MCP Snowflake Server Nsp

@nsphung

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

nsphung

提交者

Nicolas PHUNG

关于 MCP Snowflake Server Nsp

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

#snowflake #mcp#key-pair#sso #oauth2

MCP Snowflake Server Nsp 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "--python=3.13",
        "--from",
        "mcp-snowflake-server-nsp",
        "mcp_snowflake_server",
        "--connections-file",
        "/absolute/path/to/snowflake_connections.toml",
        "--connection-name",
        "myconn"
      ]
    }
  }
}

MCP Snowflake Server Nsp 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Mcp Snowflake Server Nsp?

A Model Context Protocol (MCP) server that connects AI assistants to Snowflake, enabling SQL queries, schema exploration, and data insights directly from an LLM client.

How to use Mcp Snowflake Server Nsp?

Configure the server using a TOML connection file to manage multiple environments (e.g., production, staging), choose an authentication method (password, key-pair, external browser, or TOML file), and invoke it with optional flags such as --exclude-json-results, --exclude_tools, or --prefetch to pre-load schemas.

Key features of Mcp Snowflake Server Nsp

Multiple authentication methods (password, key-pair, external browser, TOML)
TOML multi-connection config for different environments
Write-safety guard (disabled by default, must be explicitly enabled)
Exclusion patterns to filter databases, schemas, or tables
--exclude-json-results flag to reduce context window usage
Prefetch mode to pre-load table schemas as MCP resources

Use cases of Mcp Snowflake Server Nsp

Run SQL queries on Snowflake from an AI assistant (e.g., Claude Desktop)
Explore Snowflake schemas and table structures without leaving your chat
Derive data insights by combining natural language with query results
Manage multiple Snowflake environments (production, staging, development) via one config file
Pre-load table schemas to speed up repeated schema lookups

常见问题

Are write operations allowed?

Write operations are disabled by default. They must be explicitly enabled by the user.

Can I exclude certain databases or tables from discovery?

Yes, MCP Snowflake Server Nsp supports exclusion patterns to filter out databases, schemas, or tables from automatic discovery.

What authentication methods does the server support?

The server supports password, key-pair, external browser, and TOML connection file authentication methods.

How can I manage multiple Snowflake environments?

You can use a TOML multi-connection configuration file to define separate settings for `production`, `staging`, and `development` environments.

Does the server pre-load table schemas?

Yes, using `--prefetch` mode, table schemas can be pre-loaded as MCP resources to reduce latency on first query.

数据库分类下的更多 MCP 服务器

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s