MCP Server: Snowflake (Community Package)

What This Repository Does

mcp-server-snowflake is a community npm package that provides an MCP server for connecting build-cli to a Snowflake instance. It enables the same direct SQL querying and schema exploration capabilities as the official PostgreSQL server, but targeting Snowflake.

Community status: This is not an official package from Anthropic or Snowflake. Validate its legitimacy and maintenance status before use in regulated or production-adjacent environments. Check the npm package page for download trends, last publish date, and GitHub link.

Common use cases:

Query Snowflake tables directly within a build-cli session during development
Explore schemas without switching to the Snowflake UI
Validate data assumptions interactively during pipeline development

For the PostgreSQL / Aurora / Redshift MCP server, see the companion item repo:mcp-postgres.

How to Use It

Add the server to your Claude Code MCP configuration (~/.claude/settings.json):

{
  "mcpServers": {
    "snowflake": {
      "command": "npx",
      "args": ["-y", "mcp-server-snowflake"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "your-account",
        "SNOWFLAKE_USER": "your-user",
        "SNOWFLAKE_PASSWORD": "your-password",
        "SNOWFLAKE_DATABASE": "your-database",
        "SNOWFLAKE_SCHEMA": "your-schema"
      }
    }
  }
}

Security considerations:

Use read-only Snowflake credentials — MCP servers can execute arbitrary SQL.
Do not connect to databases containing PII or regulated data without confirming compliance with your data steward and security team.
Credentials in the config file are stored in plaintext — use environment variables or a secrets manager where possible.
Confirm with your team lead before connecting any MCP server to a production Snowflake environment.
As a community package, validate the package is maintained and legitimate before installing in a corporate environment (see the npm page linked in source_url).

Relevance to the Hub

Snowflake is the primary data warehouse platform for many DMDQP pipelines. This community MCP server enables DMDQP software engineers to query Snowflake data directly from build-cli during development, validation, and pipeline review — reducing context-switching to the Snowflake UI. The community status requires additional validation before adoption in regulated contexts.