sgriffin-magnoliacap/mcp-snowflake-server-readonly

3.1

If you are the rightful owner of mcp-snowflake-server-readonly and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Snowflake MCP Server is a Model Context Protocol server implementation designed for database interaction with Snowflake, focusing on executing read-only SQL queries and providing data insights and schema context.

Tools

Functions exposed to the LLM to take actions

read_query

Execute SELECT queries to read data from the database.

list_databases

List all databases in the Snowflake instance.

list_schemas

List all schemas within a specific database.

list_tables

List all tables within a specific database and schema.

describe_table

View column information for a specific table.

append_insight

Add new data insights to the memo resource.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

sgriffin-magnoliacap

Claim Ownership

Verify you have write access to the repository

Version

v0.4.6

Repository

https://github.com/sgriffin-magnoliacap/mcp-snowflake-server-readonly

License

GNU General Public License v3.0

Last publish date

2025-06-30

Last update date

2025-06-30

Server configs

via uvx in claude desktop

"mcpServers": {
  "snowflake_pip": {
    "command": "uvx",
    "args": [
      "--python=3.12",  // Optional: specify Python version <=3.12
      "mcp_snowflake_server",
      "--account", "your_account",
      "--warehouse", "your_warehouse",
      "--user", "your_user",
      "--password", "your_password",
      "--role", "your_role",
      "--database", "your_database",
      "--schema", "your_schema"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

in claude desktop

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",  // Optional
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}