Snowflake MCP Server
Connects Claude to Snowflake data warehouses through the Model Context Protocol. You get SQL query execution, schema introspection across databases and tables, and data exploration capabilities right in your AI conversations. Useful when you need to pull insights from Snowflake without context switching between your assistant and a SQL client. The server handles authentication and query execution, letting Claude navigate your warehouse structure and run queries on your behalf. Built in Python with stdio transport, so it runs locally and integrates with Claude Desktop or any MCP-compatible client.
- GitHub stars
- 2
- tools
- 8
- auth
- Secret needed
- transport
- STDIO
- env vars
- 15
- last updated
- Sep 24, 2026
Tools
8 toolsPublic tool metadata for what this MCP can expose to an agent.
read_queryExecute SELECT queries.
Execute SELECT queries.
No parameter schema in public metadata yet.
write_queryExecute INSERT, UPDATE, or DELETE queries.
Execute INSERT, UPDATE, or DELETE queries.
No parameter schema in public metadata yet.
create_tableExecute CREATE TABLE statements.
Execute CREATE TABLE statements.
No parameter schema in public metadata yet.
list_databasesList all databases in the Snowflake instance.
List all databases in the Snowflake instance.
No parameter schema in public metadata yet.
list_schemasList all schemas within a database.
List all schemas within a database.
No parameter schema in public metadata yet.
list_tablesList all tables within a database and schema.
List all tables within a database and schema.
No parameter schema in public metadata yet.
describe_tableDescribe columns of a table (name, type, nullability, default, comment).
Describe columns of a table (name, type, nullability, default, comment).
No parameter schema in public metadata yet.
append_insightAdd a data insight to the memo://insights resource.
Add a data insight to the memo://insights resource.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
SNOWFLAKE_ACCOUNTSnowflake account identifier
SNOWFLAKE_USERSnowflake username
SNOWFLAKE_PASSWORDsecretPassword (not required for key-pair / SSO)
SNOWFLAKE_WAREHOUSEVirtual warehouse to use
SNOWFLAKE_DATABASEDefault database
SNOWFLAKE_SCHEMADefault schema
SNOWFLAKE_ROLERole to assume
SNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
SNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWDsecretPassphrase for encrypted private key
SNOWFLAKE_OAUTH_CLIENT_IDOAuth 2.0 client ID (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_CLIENT_SECRETsecretOAuth 2.0 client secret (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_TOKEN_REQUEST_URLOAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_SCOPEOAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
SNOWFLAKE_TOKENsecretPre-fetched OAuth bearer token (required for oauth authenticator)
Readme
Details
- Repository
- github.com/nsphung/mcp-snowflake-server
- Categories
- Databases, Data & Analytics
- Package
mcp-snowflake-server-nsp- Transport
- STDIO
- Auth
- Required
- Registry
- MCP registry, active
Related Databases MCP servers
View all
LogBearteralabx/logbearLocal dev server logs for coding agents: errors, runs and diffs as read-only SQL.2stars
Usda Mcp Servercyanheads/usda-mcp-serverSearch foods, compare nutrients, and look up the full USDA FoodData Central database.1stars
Mcp Tool Factoryheshamfs/mcp-tool-factory-tsGenerate MCP servers from natural language, OpenAPI specs, or database schemas.0stars
Gdeltpipeworx-io/mcp-gdeltGDELT MCP — Global Database of Events, Language, and Tone (free, no auth)1starsThegamesdbpipeworx-io/mcp-thegamesdbTheGamesDB MCP — wraps TheGamesDB API (thegamesdb.net), a community video-game metadata database…1stars