A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / Claude Snowflake MCP ( )
This server implements the Model Context Protocol to allow Claude to:
- Execute SQL queries on Snowflake databases
- Automatically handle database connection lifecycle (connect, reconnect on timeout, close)
- Handle query results and errors
- Perform database operations safely
- Snowflake SQL
Installation /
Installing via Smithery
To install mcp-service-snowflake for Claude Desktop automatically via Smithery:
Manual Installation
- Clone this repository /
- Install dependencies /
Configuration /
MCP Client Configuration Example / MCP
Add the following configuration to
claude_desktop_config.json / claude_desktop_config.json :Configuration parameters / :
command: Full path to your Python interpreter. Please modify this according to your Python installation location. / Python Python
args: Full path to the server script. Please modify this according to where you cloned the repository. /
Example paths for different operating systems / :
Windows:
MacOS/Linux:
Snowflake Configuration / Snowflake
Create a
.env file in the project root directory and add the following configuration / .env Connection Management /
The server provides automatic connection management features /
- Automatic connection initialization /
- Connection maintenance /
- Connection cleanup /
Usage /
The server will start automatically with the Claude Desktop client. No manual startup is required. Once the server is running, Claude will be able to execute Snowflake queries. / Claude Desktop Claude Snowflake
For development testing, you can start the server manually using / :
Note: Manual server startup is not needed for normal use. The Claude Desktop client will automatically manage server startup and shutdown based on the configuration. / Claude Desktop
Features /
- Secure Snowflake database access / Snowflake
- Robust error handling and reporting /
- Automatic connection management /
- Query execution and result processing /
Development /
To contribute code or report issues / :
- Fork this repository / Fork
- Create your feature branch / (
git checkout -b feature/AmazingFeature)
- Commit your changes / (
git commit -m 'Add some AmazingFeature')
- Push to the branch / (
git push origin feature/AmazingFeature)
- Open a Pull Request / Pull Request
notes /
mcp server snowflake controls database access rights precisely by way of database users. If you only need to read data, just assign a user with read only database permissions./
mcp-server-snowflake
License /
This project is licensed under the MIT License.
A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / Claude Snowflake MCP ( )
This server implements the Model Context Protocol to allow Claude to:
- Execute SQL queries on Snowflake databases
- Automatically handle database connection lifecycle (connect, reconnect on timeout, close)
- Handle query results and errors
- Perform database operations safely
- Snowflake SQL
Installation /
Installing via Smithery
To install mcp-service-snowflake for Claude Desktop automatically via Smithery:
Manual Installation
- Clone this repository /
- Install dependencies /
Configuration /
MCP Client Configuration Example / MCP
Add the following configuration to
claude_desktop_config.json / claude_desktop_config.json :Configuration parameters / :
command: Full path to your Python interpreter. Please modify this according to your Python installation location. / Python Python
args: Full path to the server script. Please modify this according to where you cloned the repository. /
Example paths for different operating systems / :
Windows:
MacOS/Linux:
Snowflake Configuration / Snowflake
Create a
.env file in the project root directory and add the following configuration / .env Connection Management /
The server provides automatic connection management features /
- Automatic connection initialization /
- Connection maintenance /
- Connection cleanup /
Usage /
The server will start automatically with the Claude Desktop client. No manual startup is required. Once the server is running, Claude will be able to execute Snowflake queries. / Claude Desktop Claude Snowflake
For development testing, you can start the server manually using / :
Note: Manual server startup is not needed for normal use. The Claude Desktop client will automatically manage server startup and shutdown based on the configuration. / Claude Desktop
Features /
- Secure Snowflake database access / Snowflake
- Robust error handling and reporting /
- Automatic connection management /
- Query execution and result processing /
Development /
To contribute code or report issues / :
- Fork this repository / Fork
- Create your feature branch / (
git checkout -b feature/AmazingFeature)
- Commit your changes / (
git commit -m 'Add some AmazingFeature')
- Push to the branch / (
git push origin feature/AmazingFeature)
- Open a Pull Request / Pull Request
notes /
mcp server snowflake controls database access rights precisely by way of database users. If you only need to read data, just assign a user with read only database permissions./
mcp-server-snowflake
License /
This project is licensed under the MIT License.