cosmic-mcp

All servers

Snowflake MCP Server

io.github.nsphung/mcp-snowflake-server · version 0.14.4

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

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

https://github.com/nsphung/mcp-snowflake-server

Quick facts

  • Listing: Community
  • Published Sep 24, 11:37 UTC
  • Transport: stdio
  • Package: pypi mcp-snowflake-server-nsp 0.14.4
  • Listed by cosmic-mcp: Nov 9, 04:26 UTC

Data and analytics Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (pypi)

uvx 'mcp-snowflake-server-nsp==0.14.4'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "command": "uvx",
      "env": {
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_AUTHENTICATOR": "<your snowflake authenticator>",
        "SNOWFLAKE_DATABASE": "<your snowflake database>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<your snowflake oauth client id>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<your snowflake oauth client secret>",
        "SNOWFLAKE_OAUTH_SCOPE": "<your snowflake oauth scope>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<your snowflake oauth token request url>",
        "SNOWFLAKE_PASSWORD": "<your snowflake password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<your snowflake private key file>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<your snowflake private key file pwd>",
        "SNOWFLAKE_ROLE": "<your snowflake role>",
        "SNOWFLAKE_SCHEMA": "<your snowflake schema>",
        "SNOWFLAKE_TOKEN": "<your snowflake token>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "SNOWFLAKE_WAREHOUSE": "<your snowflake warehouse>"
      }
    }
  }
}

Claude Code

claude mcp add 'mcp-snowflake-server' -- uvx 'mcp-snowflake-server-nsp==0.14.4'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "command": "uvx",
      "env": {
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_AUTHENTICATOR": "<your snowflake authenticator>",
        "SNOWFLAKE_DATABASE": "<your snowflake database>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<your snowflake oauth client id>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<your snowflake oauth client secret>",
        "SNOWFLAKE_OAUTH_SCOPE": "<your snowflake oauth scope>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<your snowflake oauth token request url>",
        "SNOWFLAKE_PASSWORD": "<your snowflake password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<your snowflake private key file>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<your snowflake private key file pwd>",
        "SNOWFLAKE_ROLE": "<your snowflake role>",
        "SNOWFLAKE_SCHEMA": "<your snowflake schema>",
        "SNOWFLAKE_TOKEN": "<your snowflake token>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "SNOWFLAKE_WAREHOUSE": "<your snowflake warehouse>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "command": "uvx",
      "env": {
        "SNOWFLAKE_ACCOUNT": "<your snowflake account>",
        "SNOWFLAKE_AUTHENTICATOR": "<your snowflake authenticator>",
        "SNOWFLAKE_DATABASE": "<your snowflake database>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<your snowflake oauth client id>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<your snowflake oauth client secret>",
        "SNOWFLAKE_OAUTH_SCOPE": "<your snowflake oauth scope>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<your snowflake oauth token request url>",
        "SNOWFLAKE_PASSWORD": "<your snowflake password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<your snowflake private key file>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<your snowflake private key file pwd>",
        "SNOWFLAKE_ROLE": "<your snowflake role>",
        "SNOWFLAKE_SCHEMA": "<your snowflake schema>",
        "SNOWFLAKE_TOKEN": "<your snowflake token>",
        "SNOWFLAKE_USER": "<your snowflake user>",
        "SNOWFLAKE_WAREHOUSE": "<your snowflake warehouse>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Analytics Legends — SAP AI & Analytics MCP Server Verified domain
    SAP AI & analytics market data for agents: SAP firms, day rates, jobs, Joule & BDC news
  • Ankra Verified domain
    Deploy and operate Kubernetes: clusters, stacks, apps, logs, metrics and security, with OAuth.
  • AutoRFP.ai Verified domain
    Search AutoRFP.ai projects, requirements, content library, and tags for Q&A and analytics.
  • Dubai Data — Dubai real estate statistics Verified domain
    Dubai property prices, AED/sqft, sales, rents, yields and projects from DLD registered transactions.
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.