Snowflake MCP Server

What it does\nConnects an AI assistant to a Snowflake data warehouse, allowing it to perform read/write SQL operations, explore database structures, and maintain a running memo of data insights.\n\n## Tools\n- read_query: Execute SELECT queries to retrieve data.\n- write_query: Execute INSERT, UPDATE, or DELETE queries (requires --allow-write).\n- create_table: Create new tables in the database (requires --allow-write).\n- list_databases: List all available databases.\n- list_schemas: List schemas within a specific database.\n- list_tables: List tables within a specific database and schema.\n- describe_table: Retrieve column information and metadata for a specific table.\n- append_insight: Add a data insight to the persistent memo resource.\n\n## Installation\nAdd the following to your claude_desktop_config.json:\n\njson\n{\n "mcpServers": {\n "snowflake": {\n "command": "uvx",\n "args": [\n "--python=3.12",\n "mcp_snowflake_server",\n "--account", "your_account",\n "--warehouse", "your_warehouse",\n "--user", "your_user",\n "--password", "your_password",\n "--role", "your_role",\n "--database", "your_database",\n "--schema", "your_schema"\n ]\n }\n }\n}\n\n\n## Supported hosts\n- Claude Desktop