Advertise
MCP.so
Sign In
M

MCP Snowflake Server Nsp

@nsphung

Repository

Basic information

Category

Databases

Transports

stdio

Author

nsphung

Submitted by

Nicolas PHUNG

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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

Frequently asked questions

1

Are write operations allowed?

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

2

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.

3

What authentication methods does the server support?

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

4

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.

5

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.

Comments

More Databases MCP servers

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

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

Advertise