snowflake-mcp-server-by-cdata

Name: snowflake-mcp-server-by-cdata
Author: CDataSoftware

@CDataSoftware

About snowflake-mcp-server-by-cdata

This read-only MCP Server allows you to connect to Snowflake data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

#snowflake #mcp-server #cdata

Basic information

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is snowflake-mcp-server-by-cdata?

snowflake-mcp-server-by-cdata is a read-only MCP (Model Context Protocol) server that allows LLMs like Claude Desktop to query live data in Snowflake using natural language. It wraps the CData JDBC Driver for Snowflake and exposes Snowflake tables as relational SQL models through a simple MCP interface.

How to use snowflake-mcp-server-by-cdata?

Clone the repository, build it with mvn clean install, then download and license the CData JDBC Driver for Snowflake. Create a .prp file with your JDBC connection string, driver path, and settings. Configure Claude Desktop by adding the server to its claude_desktop_config.json with the path to Java and the JAR and .prp file. The server uses stdio transport and must run on the same machine as the client.

Key features of snowflake-mcp-server-by-cdata

Read‑only querying of Snowflake data via natural language.
Built on the CData JDBC Driver for Snowflake.
Exposes Snowflake tables as relational SQL models.
Provides tools: get_tables, get_columns, and run_query (SQL SELECT).
Works with Claude Desktop and other MCP clients using stdio.
MIT licensed and open source.

Use cases of snowflake-mcp-server-by-cdata

Ask an LLM to analyze Snowflake data without writing SQL.
Let Claude Desktop answer questions about live Snowflake tables.
Quickly explore Snowflake schemas and run SELECT queries from a chatbot.
Integrate Snowflake data into AI workflows for reporting or analytics.

FAQ from snowflake-mcp-server-by-cdata

What does snowflake-mcp-server-by-cdata do?

It lets LLMs like Claude Desktop query live Snowflake data by asking natural-language questions, without needing to write SQL. It is a read‑only server based on the CData JDBC Driver for Snowflake.

What dependencies are required?

You need Java, Maven to build, and the CData JDBC Driver for Snowflake (requires installation and licensing). The server runs on any OS with Java.

Is snowflake-mcp-server-by-cdata read‑only?

Yes, this MCP server is read‑only. For full CRUD and action capabilities, CData offers a separate beta MCP Server for Snowflake with a simplified setup.