Snowflake MCP Server by CData
by CData Software
This is a read-only Model Context Protocol (MCP) server for Snowflake, enabling LLMs to query live Snowflake data. It leverages the CData JDBC Driver for Snowflake to expose Snowflake data as relational SQL models through a simple MCP interface.
Last updated: N/A
What is Snowflake MCP Server by CData?
The Snowflake MCP Server by CData is a read-only server that allows Large Language Models (LLMs) to query live data from Snowflake. It wraps the CData JDBC Driver for Snowflake, making Snowflake data accessible through a simple Model Context Protocol (MCP) interface.
How to use Snowflake MCP Server by CData?
To use the server, you need to clone the repository, build the server using Maven, download and license the CData JDBC Driver for Snowflake, configure a connection to Snowflake using the driver, create a .prp file with connection details, and then configure your client (e.g., Claude Desktop) to use the server.
Key features of Snowflake MCP Server by CData
Read-only access to Snowflake data
MCP interface for LLM integration
Leverages CData JDBC Driver for Snowflake
Enables natural language querying of Snowflake data
Simple setup and configuration
Use cases of Snowflake MCP Server by CData
Enabling LLMs to answer questions about Snowflake data
Integrating Snowflake data with AI applications
Providing a natural language interface to Snowflake data
Querying live Snowflake data without SQL knowledge
FAQ from Snowflake MCP Server by CData
How do I troubleshoot connection issues?
How do I troubleshoot connection issues?
Ensure your connection string is configured correctly using the Connection String builder. Verify the connection details in the .prp file. Contact CData Support if needed.
How do I update the data?
How do I update the data?
This server is read-only. For read, write, update, delete, and action capabilities, use the CData MCP Server for Snowflake (beta).
What data sources are supported?
What data sources are supported?
This server is specifically for Snowflake. However, CData offers JDBC Drivers for many other data sources.
I can't see the server in Claude Desktop. What do I do?
I can't see the server in Claude Desktop. What do I do?
Ensure you have fully quit and restarted Claude Desktop. Check the configuration file path and contents.
Where can I get support?
Where can I get support?
Contact the CData Support Team or join the CData Community for assistance.