snowflake-mcp-server-by-cdata

snowflake-mcp-server-by-cdata

0
databases

CData's MCP Server for Snowflake allows querying live data from Snowflake using a simple interface that supports natural language processing, bypassing the need for SQL. It is designed to work with LLMs like Claude Desktop, providing a seamless data interaction experience through the MCP interface.

snowflake-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for Snowflake provides a read-only server allowing LLMs like Claude Desktop to query live data from Snowflake using the CData JDBC Driver. The server exposes Snowflake data through an MCP interface enabling natural language queries without SQL knowledge.

Purpose

  • Allows querying live Snowflake data through natural language.
  • Uses CData JDBC Driver to connect Snowflake data as SQL models.
  • Provides a simplified interface for LLMs.

Setup Guide

  1. Clone the repository.
  2. Build the server.
  3. Download and install the CData JDBC Driver.
  4. License the JDBC Driver and configure connection.
  5. Create a .prp file for JDBC connection.
  6. Configure Claude Desktop with the server.

Usage Details

  • The AI client can read, write, update, delete data using the built-in tools without explicitly calling them.
  • Example queries include checking ticket statuses or calendar events.

Tools & Descriptions

  • {servername}_get_tables - Retrieves available tables.
  • {servername}_get_columns - Retrieves columns for a specific table.
  • {servername}_run_query - Executes SQL SELECT queries.

Troubleshooting

  1. Ensure Claude Desktop is fully quit to see the server.
  2. Verify connection configuration if data retrieval fails.
  3. Contact CData Support for connection issues.
  4. Join CData Community for server feedback.

License

Licensed under the MIT License. Free to use, modify, and distribute under the terms of the MIT License. See LICENSE file for details.