How do I install the snowflake mcp sp integration mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `SNOWFLAKE_HOST` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Snowflake MCP Sp Integration MCP Server

This project simplifies the integration of Snowflake stored procedures with an MCP (Model Context Protocol) server. It provides a framework to

Local serverstdioPython

What is the Snowflake MCP Sp Integration MCP Server?

This project simplifies the integration of Snowflake stored procedures with an MCP (Model Context Protocol) server. It provides a framework to define, manage, and

What it needs from you

Python 3.8 or higher - uv installed

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Snowflake MCP Sp Integration MCP Server

{
  "mcpServers": {
    "snowflake_sp_server": {
      "command": "absolute/path/to/your/uv/uv.exe",
      "args": [
        "--directory",
        "absolute/path/to/snowflake-mcp-sp-integration",
        "run",
        "main.py",
        "--schemas",
        "DB_NAME.SCHEMA_NAME",
        "--procedures",
        "DB_NAME.OTHER_SCHEMA_NAME.PROCEDURE_NAME"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Python 3.8 or higher - uv installed

Example prompts to try

“Use Snowflake MCP Sp Integration to Schemas.”
“Use Snowflake MCP Sp Integration to Procedures.”

Frequently asked questions

This project simplifies the integration of Snowflake stored procedures with an MCP (Model Context Protocol) server. It provides a framework to define, manage, and Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.