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.
@CDataSoftware
Basic information
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
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
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.
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.
get_tables, get_columns, and run_query (SQL SELECT).stdio.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.
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.
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.
The server uses `stdio` transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop).
Data remains in Snowflake; the server only queries live data. No local persistence is used.
A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
Connect ClickHouse to your AI assistants.
A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Local MCP server for DuckDB and MotherDuck
Comments