{"name":"io.github.nsphung/mcp-snowflake-server","slug":"nsphung-mcp-snowflake-server","title":"Snowflake MCP Server","description":"A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants","url":"https://mcp.market/server/nsphung-mcp-snowflake-server","rating":null,"grade":"B","score":83,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":28,"stars":2,"forks":0,"downloads_week":55,"last_push_at":"2026-09-17T12:36:28.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"mixed","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/nsphung/mcp-snowflake-server","website":null,"version":"0.14.3","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-snowflake-server-nsp","version":"0.14.3","runtimeHint":"uvx","transport":{"type":"stdio"},"packageArguments":[{"description":"Snowflake account identifier","type":"named","name":"--account"},{"description":"Snowflake username","type":"named","name":"--user"},{"description":"Password (not required for key-pair / SSO)","type":"named","name":"--password"},{"description":"Virtual warehouse to use","type":"named","name":"--warehouse"},{"description":"Default database","type":"named","name":"--database"},{"description":"Default schema","type":"named","name":"--schema"},{"description":"Role to assume","type":"named","name":"--role"},{"description":"Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials","type":"named","name":"--authenticator"},{"description":"Absolute path to .p8 private key file","type":"named","name":"--private_key_file"},{"description":"Passphrase for encrypted private key","type":"named","name":"--private_key_file_pwd"},{"description":"Path to TOML connections file","type":"named","name":"--connections-file"},{"description":"Connection profile name in TOML file (required with --connections-file)","type":"named","name":"--connection-name"},{"description":"Enable write_query and create_table tools","type":"named","name":"--allow_write"},{"description":"Pre-load table schema as context://table/* resources (disables list_tables / describe_table)","type":"named","name":"--prefetch"},{"description":"Space-separated list of tool names to disable","type":"named","name":"--exclude_tools"},{"description":"Omit embedded JSON resources from responses (reduces context window usage)","type":"named","name":"--exclude-json-results"},{"description":"Directory for log file output","type":"named","name":"--log_dir"},{"description":"Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL","default":"INFO","choices":["DEBUG","INFO","WARNING","ERROR","CRITICAL"],"type":"named","name":"--log_level"}],"environmentVariables":[{"description":"Snowflake account identifier","format":"string","name":"SNOWFLAKE_ACCOUNT"},{"description":"Snowflake username","format":"string","name":"SNOWFLAKE_USER"},{"description":"Password (not required for key-pair / SSO)","format":"string","isSecret":true,"name":"SNOWFLAKE_PASSWORD"},{"description":"Virtual warehouse to use","format":"string","name":"SNOWFLAKE_WAREHOUSE"},{"description":"Default database","format":"string","name":"SNOWFLAKE_DATABASE"},{"description":"Default schema","format":"string","name":"SNOWFLAKE_SCHEMA"},{"description":"Role to assume","format":"string","name":"SNOWFLAKE_ROLE"},{"description":"Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials","format":"string","name":"SNOWFLAKE_AUTHENTICATOR"},{"description":"Absolute path to .p8 private key file","format":"string","name":"SNOWFLAKE_PRIVATE_KEY_FILE"},{"description":"Passphrase for encrypted private key","format":"string","isSecret":true,"name":"SNOWFLAKE_PRIVATE_KEY_FILE_PWD"},{"description":"OAuth 2.0 client ID (required for oauth_client_credentials authenticator)","format":"string","name":"SNOWFLAKE_OAUTH_CLIENT_ID"},{"description":"OAuth 2.0 client secret (required for oauth_client_credentials authenticator)","format":"string","isSecret":true,"name":"SNOWFLAKE_OAUTH_CLIENT_SECRET"},{"description":"OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)","format":"string","name":"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL"},{"description":"OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)","format":"string","name":"SNOWFLAKE_OAUTH_SCOPE"},{"description":"Pre-fetched OAuth bearer token (required for oauth authenticator)","format":"string","isSecret":true,"name":"SNOWFLAKE_TOKEN"}]},{"registryType":"oci","identifier":"docker.io/nsphung/mcp-snowflake-server-nsp:0.14.3","runtimeHint":"docker","transport":{"type":"stdio"},"runtimeArguments":[{"value":"--rm","type":"positional"},{"value":"-i","type":"positional"}],"packageArguments":[{"description":"Snowflake account identifier","type":"named","name":"--account"},{"description":"Snowflake username","type":"named","name":"--user"},{"description":"Password (not required for key-pair / SSO)","type":"named","name":"--password"},{"description":"Virtual warehouse to use","type":"named","name":"--warehouse"},{"description":"Default database","type":"named","name":"--database"},{"description":"Default schema","type":"named","name":"--schema"},{"description":"Role to assume","type":"named","name":"--role"},{"description":"Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials","type":"named","name":"--authenticator"},{"description":"Absolute path to .p8 private key file","type":"named","name":"--private_key_file"},{"description":"Passphrase for encrypted private key","type":"named","name":"--private_key_file_pwd"},{"description":"Path to TOML connections file","type":"named","name":"--connections-file"},{"description":"Connection profile name in TOML file (required with --connections-file)","type":"named","name":"--connection-name"},{"description":"Enable write_query and create_table tools","type":"named","name":"--allow_write"},{"description":"Pre-load table schema as context://table/* resources (disables list_tables / describe_table)","type":"named","name":"--prefetch"},{"description":"Space-separated list of tool names to disable","type":"named","name":"--exclude_tools"},{"description":"Omit embedded JSON resources from responses (reduces context window usage)","type":"named","name":"--exclude-json-results"},{"description":"Directory for log file output","type":"named","name":"--log_dir"},{"description":"Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL","default":"INFO","choices":["DEBUG","INFO","WARNING","ERROR","CRITICAL"],"type":"named","name":"--log_level"}],"environmentVariables":[{"description":"Snowflake account identifier","format":"string","name":"SNOWFLAKE_ACCOUNT"},{"description":"Snowflake username","format":"string","name":"SNOWFLAKE_USER"},{"description":"Password (not required for key-pair / SSO)","format":"string","isSecret":true,"name":"SNOWFLAKE_PASSWORD"},{"description":"Virtual warehouse to use","format":"string","name":"SNOWFLAKE_WAREHOUSE"},{"description":"Default database","format":"string","name":"SNOWFLAKE_DATABASE"},{"description":"Default schema","format":"string","name":"SNOWFLAKE_SCHEMA"},{"description":"Role to assume","format":"string","name":"SNOWFLAKE_ROLE"},{"description":"Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials","format":"string","name":"SNOWFLAKE_AUTHENTICATOR"},{"description":"Absolute path to .p8 private key file","format":"string","name":"SNOWFLAKE_PRIVATE_KEY_FILE"},{"description":"Passphrase for encrypted private key","format":"string","isSecret":true,"name":"SNOWFLAKE_PRIVATE_KEY_FILE_PWD"},{"description":"OAuth 2.0 client ID (required for oauth_client_credentials authenticator)","format":"string","name":"SNOWFLAKE_OAUTH_CLIENT_ID"},{"description":"OAuth 2.0 client secret (required for oauth_client_credentials authenticator)","format":"string","isSecret":true,"name":"SNOWFLAKE_OAUTH_CLIENT_SECRET"},{"description":"OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)","format":"string","name":"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL"},{"description":"OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)","format":"string","name":"SNOWFLAKE_OAUTH_SCOPE"},{"description":"Pre-fetched OAuth bearer token (required for oauth authenticator)","format":"string","isSecret":true,"name":"SNOWFLAKE_TOKEN"}]}],"tools":[{"name":"append_insight","description":"Add a data insight to the memo","write_action":false,"price_micros":0,"input_schema":null},{"name":"create_table","description":"Create a new table in the Snowflake database","write_action":true,"price_micros":0,"input_schema":null},{"name":"describe_table","description":"Get the schema information for a specific table","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_databases","description":"List all available databases in Snowflake","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_schemas","description":"List all schemas in a database","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"List all tables in a specific database and schema","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_query","description":"Execute a SELECT query.","write_action":true,"price_micros":0,"input_schema":null},{"name":"write_query","description":"Execute an INSERT, UPDATE, or DELETE query on the Snowflake database","write_action":true,"price_micros":0,"input_schema":null}],"scan":{"score":83,"grade":"B","scanned_at":"2026-09-20T16:16:34.806Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-20T16:16:34.774Z","components":{"code":{"score":25,"max":25,"notes":["15 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 3 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-snowflake-server-nsp","version":"0.14.3","found":true,"weeklyDownloads":55,"dependencyCount":6,"publishedAt":"2026-09-04T07:41:51.603152Z","repositoryUrl":"https://github.com/nsphung/mcp-snowflake-server"}],"repo":{"found":true,"owner":"nsphung","repo":"mcp-snowflake-server","archived":false,"pushedAt":"2026-09-17T12:36:28Z","stars":2,"forks":0,"openIssues":3,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/946533?v=4","ownerCreatedAt":"2011-07-29T10:49:18Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/946533?v=4&s=128","source":"github"},"presence":{"stars":2,"forks":0,"downloadsWeek":55,"license":"MIT","lastPushAt":"2026-09-17T12:36:28.000Z","score":28}}}},"grade_history":[],"reviews":[]}