Snowflake MCP Server

An MCP (Model Context Protocol) server for Snowflake — exposes Snowflake database operations as MCP tools.

Installation

No installation required. Just configure and use via npx.

Configuration

Add the following to your .mcp.json:

{
    "mcpServers": {
        "snowflake": {
            "command": "npx",
            "args": ["@naganpm/snowflake-mcp-server"],
            "env": {
                "SNOWFLAKE_ACCOUNT": "your-account.region.cloud",
                "SNOWFLAKE_USER": "your-username",
                "SNOWFLAKE_PASSWORD": "your-password",
                "SNOWFLAKE_WAREHOUSE": "your-warehouse",
                "SNOWFLAKE_DATABASE": "your-database",
                "SNOWFLAKE_SCHEMA": "your-schema",
                "SNOWFLAKE_ROLE": "your-role"
            }
        }
    }
}

Environment Variables

| Variable | Required | Description | |---|---|---| | SNOWFLAKE_ACCOUNT | Yes | Your Snowflake account identifier | | SNOWFLAKE_USER | Yes | Snowflake username | | SNOWFLAKE_PASSWORD | Yes | Snowflake password | | SNOWFLAKE_WAREHOUSE | No | Virtual warehouse to use | | SNOWFLAKE_DATABASE | No | Default database | | SNOWFLAKE_SCHEMA | No | Default schema | | SNOWFLAKE_ROLE | No | Role to assume |

Available Tools

| Tool | Description | |---|---| | test_connection | Test the Snowflake connection | | execute_query | Execute a SQL query | | list_databases | List all accessible databases | | list_schemas | List schemas in a database | | list_tables | List tables in a schema | | list_views | List views in a schema | | describe_table | Describe columns of a table | | get_table_ddl | Get CREATE TABLE statement | | get_query_history | Get recent query history | | list_warehouses | List all warehouses | | list_stages | List stages in a schema |