Snowflake MCP Server

Example Use Cases

• 1

  Translate natural-language questions into executable Snowflake SQL and run queries programmatically.

• 2

  Inspect database structure, list tables, and fetch table schemas from a Snowflake account.

• 3

  Integrate Snowflake access into MCP-compatible tools (Claude, Cursor IDE) or deploy the connector in a hosted environment.

Description

This repository implements a Model Context Protocol (MCP) server that translates natural-language requests into SQL and executes them on Snowflake. It manages Snowflake connection lifecycle (connect, reconnect, close), formats query results, and exposes tools such as query execution, listing tables, and fetching table schemas. The server integrates with MCP-compatible clients like Claude and Cursor IDE, supports local/stdio and WebSocket transports, and includes deployment guidance and a Dockerfile. Credentials are provided via environment variables and the project is MIT-licensed for reuse.