OSS Snowflake MCP Server
MCP Server for Snowflake from Snowflake Labs
{
"mcpServers": {
"mcp": {
"command": "uvx",
"args": [
"snowflake-labs-mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "<snowflake_account>",
"SNOWFLAKE_HOST": "<snowflake_host>",
"SNOWFLAKE_USER": "<snowflake_user>",
"SNOWFLAKE_PASSWORD": "<your-snowflake_password>",
"SNOWFLAKE_ROLE": "<snowflake_role>",
"SNOWFLAKE_WAREHOUSE": "<snowflake_warehouse>",
"SNOWFLAKE_PASSCODE": "<snowflake_passcode>",
"SNOWFLAKE_PRIVATE_KEY": "<your-snowflake_private_key>",
"SNOWFLAKE_PRIVATE_KEY_FILE": "<snowflake_private_key_file>",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake_private_key_file_pwd>",
"SNOWFLAKE_MCP_HOST": "<snowflake_mcp_host>",
"SNOWFLAKE_MCP_PORT": "<snowflake_mcp_port>",
"SNOWFLAKE_MCP_ENDPOINT": "<snowflake_mcp_endpoint>"
}
}
}
}SNOWFLAKE_ACCOUNTAccount identifier (e.g. xy12345.us-east-1)
SNOWFLAKE_HOSTSnowflake host URL
SNOWFLAKE_USERUsername for authentication
SNOWFLAKE_PASSWORDPassword or programmatic access token
SNOWFLAKE_ROLERole to use for connection
SNOWFLAKE_WAREHOUSEWarehouse to use for queries
SNOWFLAKE_PASSCODEMFA passcode for authentication
SNOWFLAKE_PRIVATE_KEYPrivate key for key pair authentication
SNOWFLAKE_PRIVATE_KEY_FILEPath to private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWDPassword for encrypted private key
SNOWFLAKE_MCP_HOSTHost address to bind the server to (default: 0.0.0.0)
SNOWFLAKE_MCP_PORTPort number for the server to listen on (default: 9000)
SNOWFLAKE_MCP_ENDPOINTEndpoint path for the MCP server (default: /mcp)
Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite
Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…
Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…