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.

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

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note