Mcp Snowflake Server Nsp

Name: Mcp Snowflake Server Nsp
Author: nsphung

@nsphung

リポジトリ

Mcp Snowflake Server Nsp について

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

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

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

nsphung

投稿者

Nicolas PHUNG

設定

以下の設定を使って、このサーバーを 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"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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

FAQ from Mcp Snowflake Server Nsp

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.

「データベース」の他のコンテンツ

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K