mcp-snowflake-service logo

mcp-snowflake-service

by datawiz168

A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. It allows Claude to execute SQL queries on Snowflake databases and automatically manages database connections.

View on GitHub

Last updated: N/A

What is mcp-snowflake-service?

This is a Model Context Protocol (MCP) server that enables the Claude AI model to interact with Snowflake databases. It acts as a bridge, allowing Claude to execute SQL queries and retrieve data from Snowflake.

How to use mcp-snowflake-service?

To use this server, you need to configure it within the Claude Desktop client by adding the server's command and arguments to the claude_desktop_config.json file. You also need to configure Snowflake connection details in a .env file. The server starts automatically with the Claude Desktop client, allowing Claude to execute Snowflake queries.

Key features of mcp-snowflake-service

  • Secure Snowflake database access

  • Robust error handling and reporting

  • Automatic connection management (connect, reconnect, close)

  • Query execution and result processing

Use cases of mcp-snowflake-service

  • Allowing Claude to answer questions based on data stored in Snowflake

  • Enabling Claude to perform data analysis tasks on Snowflake data

  • Integrating Snowflake data into Claude's conversational capabilities

  • Automating database operations through Claude

FAQ from mcp-snowflake-service

How do I configure the server?

Configure the server within claude_desktop_config.json and set Snowflake credentials in .env.

Does the server start automatically?

Yes, the server starts automatically with the Claude Desktop client.

What if the database connection times out?

The server automatically reconnects if the connection is lost.

Can I manually start the server for testing?

Yes, you can manually start the server using python server.py.

What kind of database operations are supported?

The server supports secure SQL query execution and result processing.

mcp-snowflake-service - MCP Server | MCP Directory